【JDBC】2.DBCP连接池

DBCP连接池是Apache提供的,性能也不错:

准备:

1):拷贝jar:commons-dbcp-1.4.jar  ,    commons-pool-1.5.6.jar

2):build path,添加到classpath路径.

3):阅读文档:commons-dbcp-1.3-src\doc\BasicDataSourceExample.java

4):将连接池信息配置到配置文件中使用

示列：

key名必须等于BasicDataSource中的属性名(由setter方法决定).

driverClassName=com.mysql.jdbc.Driver

url=jdbc:mysql:///jdbcdemo

username=root

password=admin

maxActive=10

[数据库连接池] Java数据库连接池--DBCP浅析.

5):

package DBCP;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.util.Properties;

import javax.sql.DataSource;

import org.apache.commons.dbcp.BasicDataSourceFactory;

public class dbpcUtil {

    private dbpcUtil() {
        super();
        // TODO Auto-generated constructor stub
    }
    private static Properties properties = new Properties();
    private static DataSource dataSource = null;
    static{
        InputStream inputStream = Thread.currentThread().getContextClassLoader().getResourceAsStream("dbpc.properties");
        
        try {
            properties.load(inputStream);
            //使用工厂方法
            dataSource = BasicDataSourceFactory.createDataSource(properties);
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } 
    }
    
    public static Connection getConn(){
        try {
            return dataSource.getConnection();
        } catch (Exception e) {
            // TODO: handle exception
        }
        return null;
    }
}