jdbc oracle 需要jar,什么jdbc jar用于oracle 11g&jdk 1.6以及如何连接到db本身

> Oracle将Jar与Oracle客户端或服务器安装捆绑在一起,可以在$ORACLE_HOME / jdbc / lib / ojdbc6.jar中找到.我总是用那个.

> Driver类名是oracle.jdbc.OracleDriver,URL是jdbc：oracle：thin：@ // [HOST] [：PORT] / SERVICE.

这是一个例子(取自here)：

import java.sql.*;

class Conn {

public static void main (String[] args) throws Exception

{

Class.forName ("oracle.jdbc.OracleDriver");

Connection conn = DriverManager.getConnection

("jdbc:oracle:thin:@//localhost:1521/orcl", "scott", "tiger");

// @//machineName:port/SID, userid, password

try {

Statement stmt = conn.createStatement();

try {

ResultSet rset = stmt.executeQuery("select BANNER from SYS.V_$VERSION");

try {

while (rset.next())

System.out.println (rset.getString(1)); // Print col 1

}

finally {

try { rset.close(); } catch (Exception ignore) {}

}

}

finally {

try { stmt.close(); } catch (Exception ignore) {}

}

}

finally {

try { conn.close(); } catch (Exception ignore) {}

}

}

}