62,614
社区成员
发帖
与我相关
我的任务
分享
public Connection getConnection () throws SQLException {
//对池进行四大参数的配置
ConfigInfo cf=ConfigInfo.getInstance();
try {
dataSource.setDriverClass(cf.getDbDriver());
dataSource.setJdbcUrl(cf.getDbUrl());
dataSource.setUser(cf.getDbUser());
dataSource.setPassword(cf.getDbPwd());
//池配置,可以不配,有默认值
dataSource.setAcquireIncrement(5);
dataSource.setInitialPoolSize(20);
dataSource.setMinPoolSize(10);
dataSource.setMaxPoolSize(100);
dataSource.setMaxIdleTime(60);
//dataSource.setMaxConnectionAge(60);
dataSource.setCheckoutTimeout(3000);
dataSource.setAcquireRetryDelay(1000);
dataSource.setBreakAfterAcquireFailure(false);
dataSource.setIdleConnectionTestPeriod(60);
dataSource.setMaxStatements(100);
return dataSource.getConnection();
}catch(Exception e){
e.printStackTrace();
}
return null;
}