67,512
社区成员
发帖
与我相关
我的任务
分享
DataSource unpooled = DataSources.unpooledDataSource(
"jdbc:mysql://localhost:3306/mysql", "root", "root");
DataSource pooled = DataSources.pooledDataSource(unpooled);
con = pooled.getConnection();
ComboPooledDataSource dataSource;
dataSource = new ComboPooledDataSource();
dataSource.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/mysql?user=root&password=root&autoReconnect=true");
dataSource.setDriverClass("com.mysql.jdbc.Driver");
dataSource.setMaxPoolSize(50);
dataSource.setMinPoolSize(1);
dataSource.setMaxStatements(80);
dataSource.setMaxIdleTime(1500);
dataSource.setAcquireIncrement(10);
dataSource.setIdleConnectionTestPeriod(600);
// get hold of a Connection an do stuff, in the usual way
con = null;
stmt = null;
rs = null;
con = dataSource.getConnection();