使用属性文件为mysql数据库配连接池proxool

1、先写一个属性文件：Proxool.properties,放入你的WEB应用程序的WEB-INF/classes下面,内容如下：
jdbc-0.proxool.alias=mysql
jdbc-0.proxool.driver-class=org.gjt.mm.mysql.Driver
jdbc-0.proxool.driver-url=jdbc:mysql://localhost:3306/soft?user=root&password=

jdbc-0.proxool.maximum-connection-count=20
jdbc-0.proxool.prototype-count=4

jdbc-0.proxool.house-keeping-test-sql=select CURRENT_DATE
jdbc-0.proxool.verbose=true
jdbc-0.proxool.statistics=10s,1m,1d
jdbc-0.proxool.statistics-log-level=DEBUG

2、web.xml如是写：
<?xml version="1.0" encoding="ISO-8859-1"?>

<!DOCTYPE web-app
    PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
    "http://java.sun.com/dtd/web-app_2_3.dtd">

 

<web-app>
 <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>
    
  <servlet>
   <servlet-name>Admin</servlet-name>
   <servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>
  </servlet>

  <servlet-mapping>
   <servlet-name>Admin</servlet-name>
   <url-pattern>/Admin</url-pattern>
  </servlet-mapping>

</web-app>

3、将驱动程序mm.mysql-2.0.14-bin.jar与proxool-0.8.3.jar放入WEB-INF/lib目录下。
4、下面是测试的jsp文件：
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=GB2312" %>

 
 
  <title>CH14 - Proxool.jsp</title>
 
 

<h2>使用 Proxool Connection Pool</h2>

<%
        Connection con = null;
        Statement stmt = null;
        ResultSet rs = null;
        try{
                con = DriverManager.getConnection("proxool.mysql");
                stmt = con.createStatement();
                String query = "select * from count_num";
                rs = stmt.executeQuery(query);
                while(rs.next()) {
                       out.print(rs.getLong(1)+"--OK");
                }

                stmt.close();
                con.close();
        }catch(SQLException sqle){
                out.println("sqle="+sqle);
        }
        finally{
                 try {
                       if(con != null){
                                    con.close();
                       }
                }catch(SQLException sqle){
                      out.println("sqle="+sqle);
                }
       }

%>