Go语言视频零基础入门到精通

javalearner

不少的小应用都用Access！给它也来个连接池，就用很多人推荐的Proxool。
先将proxool-0.8.3.jar复制到你的WEB应用的WEB-INF/lib之下,在web.xml中如是配置:
     <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-INF/classes/Proxool.propertie
jdbc-0.proxool.alias=Access
jdbc-0.proxool.driver-class=sun.jdbc.odbc.JdbcOdbcDriver
jdbc-0.proxool.driver-url=jdbc:odbc:examination

jdbc-0.proxool.maximum-connection-count=10
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

测试方法：test.jsp
<%@ page import="java.sql.*" %>

<%
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet rs=null;
Conn = DriverManager.getConnection("proxool.Access");
Stmt=Conn.createStatement();
%>

由http://127.0.0.1:8080/test/Admin可进入统计信息页面


源码下载：http://file.javaxxz.com/2014/10/1/025611219.zip