数据库连接工具类

写道

public class getDBConnection {

private static String DB_DRIVER="oracle.jdbc.driver.OracleDriver";

private static String DB_URL="jdbc:oracle:thin:@数据库端口";

private static String DB_USERNAME="用户名";

private static String DB_PASSWORD="密码";

//打开数据库
public static Connection GetConnection(){

Connection conn=null;
try {
Class.forName(DB_DRIVER);
try {
conn=DriverManager.getConnection(DB_URL, DB_USERNAME, DB_PASSWORD);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
//关闭数据库
public void ConnectionClose(Connection conn){

if(conn!=null){

try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}

}