716
proxool數據庫連接池使用實例
proxool數據庫連接池使用實例
1. 引入 proxool-0.8.3.jar
2. 創建配置文件:
pool_aspboy.xml
<?xml version="1.0" encoding="ISO-8859-1"?>
<!-- the proxool configuration can be embedded within your own application's.
Anything outside the "proxool" tag is ignored. -->
<something-else-entirely>
<proxool>
<alias>jxc</alias>
<driver-url>jdbc:mysql://127.0.0.1:3306/jxc?useUnicode=true&characterEncoding=GBK</drive
r-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<driver-properties>
<property name="user" value="root"/>
<property name="password" value="root"/>
</driver-properties>
<!--<maximum-active-time>3</maximum-active-time>-->
<minimum-connection-count>1</minimum-connection-count>
<maximum-connection-count>20</maximum-connection-count>
<!--<house-keeping-test-sql>select getdate() as nowdate</house-keeping-test-sql>-->
</proxool>
</something-else-entirely>
其中<alias>jxc</alias> 為別名
調用:
public static Connection getConnection(final String poolName)
throws SQLException {
try {
return DriverManager.getConnection(poolName);
} catch (Exception e) {
return null;
}
}
其中 poolName 傳入: proxool.jxc 就是 proxool.別名
同時需要在配置文件中配置
web.xml中 通過servlet初始化連接池
<servlet>
<servlet-name>proxoolInitialServlet</servlet-name>
<servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
<init-param>
<param-name>xmlFile</param-name>
<param-value>WEB-INF//pool_aspboy.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet>
<servlet-name>proxool</servlet-name>
<servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>proxool</servlet-name>
<url-pattern>/pool/admin</url-pattern>
</servlet-mapping>
這裏配置後,可以通過 /pool/admin 察看數據庫連接的使用情況
如: https://127.0.0.1:8086/testpool//pool/admin
在tomcat 和resin測試通過
最後更新：2017-04-02 03:13:28