DBCP
public class TestDbcp {
public static void main(String[] args) throws SQLException {
BasicDataSource basicDataSource = new BasicDataSource();
basicDataSource.setUrl("jdbc:mysql://localhost:3306/mr"); //mr是DataBaseName
basicDataSource.setUsername("root");
basicDataSource.setPassword("root");
basicDataSource.setInitialSize(20); //初始化连接池连接个数
basicDataSource.setMaxIdle(10); //最大闲置连接数
basicDataSource.setMaxWait(100); //最大等待时间
//maxActive 最大激活连接数
System.out.println(basicDataSource.getConnection());
//单独使用dbcp的时候需要三个jar包 common-dbcp.jar,common-pool.jar,common-collections.jar
}
}
C3P0
public class TestC3p0 { //需要jar包
public static void main(String[] args) throws SQLException {
ComboPooledDataSource comboPooledDataSource = new ComboPooledDataSource();
comboPooledDataSource.setJdbcUrl("jdbc:mysql://localhost:3306/mr");
comboPooledDataSource.setUser("root");
comboPooledDataSource.setPassword("root");
comboPooledDataSource.setInitialPoolSize(30); //初始化连接数
comboPooledDataSource.setMaxPoolSize(20); //设置最大连接数
comboPooledDataSource.setMinPoolSize(10); //设置最小连接数
System.out.println(comboPooledDataSource.getConnection());
}
}