DBCP

导包：

commons-dbcp.jar：连接池的实现

commons-pool.jar：链接池实现的依赖库

配置文件属性  dbcp.properties ，放在 src 根目录下：

driverClassName=com.mysql.jdbc.Driver

url=jdbc:mysql://localhost:3306/jdbc

username=root

password=

示例代码：

public  class  DBCPDemo1{
	public  static  void  main(String[]  args){
		Connection  conn = null;
		PreparedStatement  ps = null;
		ResultSet  rs = null;

	//因为配置信息写死了，所以已淘汰
	//	BasicDataSource  source = new  BasicDataSource();
	//	source.setDriverClassName("com.mysql.jdbc.Driver");	//加驱动
	//	source.setUrl("jdbc:mysql:///day11");	//加路径
	//	source.setUsername("root");	//加用户名
	//	source.setPassword("root");	//加密码


		Properties  prop = new Properties();
		prop.load(new FileReader("dbcp.properties"));
		BasicDataSourceFactory  factory = new  BasicDataSourceFactory();
		DataSource  source  = factory.createDataSource();

		try{
			conn = source.getConnection();
			ps = conn.prepareStatement("select  * from  account");
			rs = ps.executeQuery();
			while(rs.next()){
				String  name = rs.getString("name");
				s.o.p(name);
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			if( rs!= null){
				try{
					rs.close();
				}catch(SQLException  e){
					e.printStackTrace();
				}finally{
					rs = null;
				}
			}

			if( ps!= null){
				try{
					ps.close();
				}catch(SQLException  e){
					e.printStackTrace();
				}finally{
					ps = null;
				}
			}

			if( conn!= null){
				try{
					pool.retConn( conn);
				}catch(SQLException  e){
					e.printStackTrace();
				}finally{
					ps = null;
				}
			}
		}
	}
}