注意:该方法只限于web项目
第一步:下载jar包,导包
第二部:写配置文件
jdbc-1.proxool.alias=test
#jdbc-1.proxool.driver-class=com.mysql.jdbc.Driver
#jdbc-1.proxool.driver-url=jdbc:mysql://127.0.0.1:3306?useUnicode=true&characterEncoding=utf8
jdbc-1.proxool.driver-class=com.mysql.jdbc.Driver
jdbc-1.proxool.driver-url=jdbc:mysql://localhost:3306/hechen
jdbc-1.user=root
jdbc-1.password=root
jdbc-1.proxool.maximum-connection-count=100
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
第三步:配置web.xml文件
在web.xml下添加如下代码
<!-- Web项目中配置proxool,并自动加载 -->
<servlet>
<servlet-name>ServletConfigurator</servlet-name>
<servlet-class>
org.logicalcobwebs.proxool.configuration.ServletConfigurator
</servlet-class>
<init-param>
<param-name>propertyFile</param-name>
<param-value>WEB-INF/classes/proxool.properties</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<!-- 监控 proxool 连接池 -->
<servlet>
<servlet-name>AdminServlet</servlet-name>
<servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>
</servlet>
第四步:创建连接
public class DButil {
static String url = "jdbc:mysql://localhost:3306/hechen";
static Connection connection = null;
public static Connection getConnection() {
try {
// 常规jdbc建立连接
//Class.forName("com.mysql.jdbc.Driver");
//connection = DriverManager.getConnection(url, "root", "root");
//proxool数据库连接池建立连接
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
connection = DriverManager.getConnection("proxool.test");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return connection;
}
第五步:测试
成功连接!!