DBCP C3P0

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());
	}
}