Java数据库连接池

c3p0数据库连接池的两种方式
导入c3p0jar包
方式一

 ComboPooledDataSource cpds = new ComboPooledDataSource();
    cpds.setDriverClass("com.mysql.jdbc.Driver");
    cpds.setJdbcUrl("jdbc:mysql://localhost:3306/test");
    cpds.setUser("root");
    cpds.setPassword("123456");
    cpds.setInitialPoolSize(10);
    Connection conn = cpds.getConnection();
    system.out.println(conn);

//销毁连接池
//DataSource.destory(cpds);

方式二
JDBCUtil中的c3p0
使用配置文件c3p0-config.xml



com.mysql.jdbc.Driver
jdbc:mysql://localhost:3306/test
root
123456

5

10

10

50

50

2

 ComboPooledDataSource cpds = new ComboPooledDataSource("c3p0");
	 Connection conn = cpds.getConnection();
	 System.out.println(conn);
	 

dbcp数据库连接的两种方式
导入commons-dbcp.jar和common-pool.jar包
方式一

 //创建了dbcp的数据库连接池
    DataSource source = new BasicDataScource();
    //设置基本信息
    source.setDriverClassName("com.mysql.jdbc.Driver");
    source.setUrl("jdbc:mysql://localhost:3306/test");
    source.setUser("root");
    source.setPassword("123456");
    source.setInitialSize(10);
    source.setMaxActive(10);
    Connection conn = source.getConnection();
    System.out.println(conn);

方式二
使用配置文件
dbcp.properties
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://3306
user=root
password=123456

 Properties pros = new Properties();
 FileInputStream is = new FileInputStream(new File("filepath");
 pros.load(is);
 DataSource source = BasicDataSourceFactory.createDataSource(pros);
 Connection conn = source.getConnection();
 return conn;
 public void test(){
Connection conn = null;
try{
	conn = JDBCUtils.getConnection();
}catch(Exception e){
	e.printStackTrace();
}finally{
     JDBCUtils.closeResource(conn,null);
}
 }

Druid数据库连接方式
导入druidjar包
durid.preperties
jdbcUrl=jdbc:mysql://test
username=root
password=123456
driverClassName=com.mysql.jdbc.Driver
initialSize=5
maxActive=5

  Properties pros = new Properties();
   InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("durid.properties");
   pros.load(is);
   DataSource source = DuridDataSourceFactory.createDataSource(pros);
   System.out.println(conn);