Question

Java连接Oracle数据库的代码多少

11

Answer 1

public class DBConnection {

/**
* 获取数据连接
* */
public static Connection getConnection(String ip,String port,String sid,String userName,String passWord ){
String driverName="oracle.jdbc.driver.OracleDriver";
String dbUrl="jdbc:oracle:thin:@"+ip+":"+port+":"+sid+"";
Connection conn=null;
try {
Class.forName(driverName);
conn = DriverManager.getConnection(dbUrl, userName, passWord);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;

}

}

Answer 2

驱动：oracle.jdbc.driver.OracleDriver
URL：jdbc:oracle:thin:@<machine_name><:port>:dbname
jdbc:oracle:thin:@localhost:1521:orcl
注：machine_name：数据库所在的机器的名称；
port：端口号，默认是1521
username:默认是scott
password:默认是tiger

Answer 3

你的多少是什么意思啊？