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=testjdbc-1.proxool.driver-class=com.mysql.jdbc.Driverjdbc-1.proxool.driver-url=jdbc:mysql://localhost:3306/test?allowMultiQueries=true&useUnicode=true&characterEncoding=utf-8jdbc-1.user=rootjdbc-1.password=123456jdbc-1.proxool.maximum-connection-count=20jdbc-1.proxool.minimum-connection-count=5jdbc-1.proxool.prototype-count=4jdbc-1.proxool.verbose=truejdbc-1.proxool.statistics=10s,1m,1djdbc-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();    }}