写道
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();
}
}
}
}
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();
}
}
}
}