public class DBUtils2 {
public static final String DRIVERNAME = "oracle.jdbc.driver.OracleDriver";
public static final String URL = "jdbc:oracle:thin:@192.168.1.116:1521:orcl";
public static final String USER = "oa_admin";
public static final String PASSWORD = "123456";
protected QueryRunner run;
protected Connection conn ;
{
run = new QueryRunner();
conn = getConnection();
}
public Connection getConnection(){
try {
Class.forName(DRIVERNAME);
return DriverManager.getConnection(URL, USER, PASSWORD);
} catch (ClassNotFoundException | SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
public static Connection getConnectionC3p0() {
try {
Class.forName(DRIVERNAME);
return DriverManager.getConnection(URL, USER, PASSWORD);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
}