proxool配置文档（一）

一、      所需要包

conmmons-logging.jar、proxool-0.9.1.jar、proxool-cglib.jar

二、      jdbc的配置及调用方法

1.         *.properties文件，配置如下：

jdbc-0.proxool.alias=mysql

jdbc-0.proxool.driver-url=jdbc:mysql://127.0.0.1:3306/owner

jdbc-0.proxool.driver-class=com.mysql.jdbc.Driver

jdbc-0.user=root

jdbc-0.password=root

jdbc-0.proxool.maximum-connection-count=10

jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE

调用：

PropertyConfigurator.configure("src/proxool.properties");

Connection conn = DriverManager.getConnection("proxool.mysql");

2.         在类中进行配置：

Properties info = new Properties();

       info.setProperty("proxool.maximum-connection-count", "20");

       info.setProperty("proxool.house-keeping-test-sql", "select CURRENT_DATE");

       info.setProperty("user", "root");

       info.setProperty("password", "root");

       String alias = "mysql2";

       String driverClass = "com.mysql.jdbc.Driver";

       String driverUrl = "jdbc:mysql://127.0.0.1:3306/test?characterEncoding=gb2312";

       String url = "proxool." + alias + ":" + driverClass + ":" + driverUrl;

         调用：

Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");这里为proxool驱动，不是数据库驱动。

    Connection conn= DriverManager.getConnection(url, info);

http://hi.baidu.com/hanxiaoyidi/blog/item/8cca44585161ccd79c820493.html