1.连接代码
package
Util;
import
java.sql.Connection;
import
java.sql.DriverManager;
import
java.sql.PreparedStatement;
import
java.sql.ResultSet;
import
java.sql.SQLException;
public
class
DBUtil {
public
static
void
main (String args[]){
try
{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
} catch (InstantiationException | IllegalAccessException | ClassNotFoundException e) {
// TODO Auto-generated catch block e.printStackTrace();
}
String user = "system";
String password = "密码";
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
Connection connection = null;
try {
connection = DriverManager.getConnection(url,user,password);
System.out.println("连接成功");
} catch (SQLException e) {
System.out.println("连接失败");
e.printStackTrace();
}
}
publicstaticvoid close(Connection connection ) {
try {
if (connection != null) {
connection.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block e.printStackTrace();
}
}
publicstaticvoid close(PreparedStatement preparedStatement ) {
try {
if (preparedStatement != null) {
preparedStatement.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block e.printStackTrace();
}
}
publicstaticvoid close(ResultSet resultSet ) {
try {
if (resultSet != null) {
resultSet.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block e.printStackTrace();
}
}
}
2.加载驱动
bulid path->Add External JARs 找到Oracle安装路径下的appAdministratorproduct11.2.0dbhome_1jdbclibojbc6_g.jar

3.在WEB-INT 下lib 复制一个ojbc6_g.jar
原文:https://www.cnblogs.com/wxd136/p/9602593.html
【说明】:本文章由站长整理发布,文章内容不代表本站观点,如文中有侵权行为,请与本站客服联系(QQ:254677821)!