proxool数据连接池使用例子

1、依赖的jar包：

            proxool-0.9.1.jar

            proxool-cglib.jar

            commons-logging-1.1.1.jar

            mysql-connector-java-5.1.37.jar

2、数据库：mysql，建表test,字段：id 类型 int，name 类型varchar(20)

3、代码目录

4、proxool.properties,数据库配置文件

jdbc-1.proxool.alias=test
jdbc-1.proxool.driver-class=com.mysql.jdbc.Driver
jdbc-1.proxool.driver-url=jdbc:mysql://localhost:3306/test?allowMultiQueries=true&useUnicode=true&characterEncoding=utf-8
jdbc-1.user=root
jdbc-1.password=123456
jdbc-1.proxool.maximum-connection-count=20
jdbc-1.proxool.minimum-connection-count=5
jdbc-1.proxool.prototype-count=4
jdbc-1.proxool.verbose=true
jdbc-1.proxool.statistics=10s,1m,1d
jdbc-1.proxool.statistics-log-level=error

5、数据库连接工具类

import org.logicalcobwebs.proxool.ProxoolException;
import org.logicalcobwebs.proxool.configuration.PropertyConfigurator;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class DBUtil {
    static {

	//获取classpath下的proxool.properties文件
        InputStream is = DBUtil.class.getResourceAsStream("/proxool.properties");
        Properties properties = new Properties();
        try {
            properties.load(is);
            PropertyConfigurator.configure(properties);
        } catch (IOException e) {
            e.printStackTrace();
        } catch (ProxoolException e) {
            e.printStackTrace();
        }
    }

    public static Connection getCon(){
        Connection conn = null;
        try{
            Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");

            //这里的proxool是指配置文件中的proxool不是文件名，这里的test是指配置文件中alias对应的值
            conn = DriverManager.getConnection("proxool.test");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return conn;
    }
}

6、数据处理类

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import static com.jin.proxool.demo.DBUtil.getCon;
public class TestDao {
    private void insert() throws SQLException {
        Connection connection = getCon();
        StringBuffer buffer = new StringBuffer();
        buffer.append("insert into test values(8,'111');");
        PreparedStatement statement = (PreparedStatement)connection.prepareStatement(buffer.toString());
        int i = statement.executeUpdate();
        System.out.println(i);
    }

    public static void main(String args[]) throws SQLException {
        TestDao testDao = new TestDao();
        testDao.insert();
    }
}