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