Question

java怎么连接oracle数据库连接

Answer 1

public static ResultSet oracleConn(String sql) {

String driver = "oracle.jdbc.driver.OracleDriver";
//写明你数据的连接串
String url = "jdbc:Oracle:thin:@192.168.1.1:3004/xe";
Statement stmt = null;
ResultSet res = null;
Connection conn = null;
CallableStatement proc = null;
List<SqlResult> list = new ArrayList();
try {
Class.forName(driver);
//连接数据库
conn = DriverManager.getConnection(url, "username",
"password");
stmt = conn.createStatement();
//执行sql语句，并返回结果
res = stmt.executeQuery(sql);

} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return res ;

}