/**
* 数据库的公共类
* @author bobo
*
*/
public class DBUtils {
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USER = "admin";
private static final String PASSWORD = "admin";
private static final String DRIVERNAME = "oracle.jdbc.driver.OracleDriver";
protected QueryRunner run;
protected Connection conn ;
{
run = new QueryRunner();
conn = getConnection();
}
/**
* 获取Connection对象
* @return
*/
public Connection getConnection(){
try {
Class.forName(DRIVERNAME);
return DriverManager.getConnection(URL, USER, PASSWORD);
} catch (ClassNotFoundException | SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
System.out.println("数据库连接出错!请检查相关的配置参数");
}
return null;
}
/**
* 通过c3p0获取连接通道
* @return
*/
public Connection getConnectionC3p0(){
ComboPooledDataSource pool = new ComboPooledDataSource();
try {
// 设置驱动路径
pool.setDriverClass(DRIVERNAME);
// 设置URL地址
pool.setJdbcUrl(URL);
// 设置用户名
pool.setUser(USER);
// 设置密码
pool.setPassword(PASSWORD);
// 设置初始连接数
pool.setInitialPoolSize(5);
// 设置最大连接数
pool.setMaxPoolSize(50);
// 设置客户端等待超时时长
pool.setCheckoutTimeout(3000);
return pool.getConnection();
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
}