proxool使用（DataSource、MySQL）

Proxool使用，通过DataSource，简单记录下，做个备份，参考了网上很多的资料，在此表示感谢。

 

proxool.xml

1. <?xml version="1.0" encoding="gbk"?>
3. <!--
4.     Document   : proxool.xml
5.     Created on : 2008年12月2日, 下午1:09
6.     Author     : zhappy
7.     Description:
8.         Purpose of the document follows.
9. -->
11. <something-else-entirely>
12.     <proxool>
13.         <alias>test</alias>
14.         <driver-url>jdbc:mysql://127.0.0.1:3306/happy</driver-url>
15.         <driver-class>com.mysql.jdbc.Driver</driver-class>
16.         <driver-properties>
17.             <property name="user" value="happy"/>
18.             <property name="password" value="happy"/>
19.         </driver-properties>
20.         <house-keeping-sleep-time>90000</house-keeping-sleep-time>
21.         <house-keeping-test-sql>select curdate()</house-keeping-test-sql>
22.         <simultaneous-build-throttle>150</simultaneous-build-throttle>
23.         <prototype-count>3</prototype-count>
24.         <maximum-connection-count>100</maximum-connection-count>
25.         <minimum-connection-count>3</minimum-connection-count>
26.     </proxool>
27. </something-else-entirely>

web.xml

1. <?xml version="1.0" encoding="UTF-8"?>
2. <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">
3.     <resource-ref>
4.         <description>DB Connection</description>
5.         <res-ref-name>jdbc/TestDB</res-ref-name>
6.         <res-type>javax.sql.DataSource</res-type>
7.         <res-auth>Container</res-auth>
8.     </resource-ref>
9.     
10.     <servlet>
11.         <servlet-name>ServletConfigurator</servlet-name>
12.         <servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
13.         <init-param>
14.             <param-name>xmlFile</param-name>
15.             <param-value>WEB-INF/proxool.xml</param-value>
16.         </init-param>
17.         <load-on-startup>1</load-on-startup>
18.     </servlet>
20.     <servlet>
21.         <servlet-name>Admin</servlet-name>
22.         <servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class>
23.     </servlet>
25.     <servlet-mapping>
26.         <servlet-name>Admin</servlet-name>
27.         <url-pattern>/admin</url-pattern>
28.     </servlet-mapping>
29.     
30.     <session-config>
31.         <session-timeout>
32.             30
33.         </session-timeout>
34.     </session-config>
35.     
36.     <welcome-file-list>
37.         <welcome-file>index.jsp</welcome-file>
38.     </welcome-file-list>
39.     
40. </web-app>

 

context.xml(META-INF文件夹中，可以配置多应用)

1. <?xml version="1.0" encoding="UTF-8"?>
2. <Context antiJARLocking="true" path="/test">
3.     <!--Resource name="jdbc/TestDB" auth="Container"
4.               type="javax.sql.DataSource"
5.               maxActive="100" maxIdle="30" maxWait="10000"
6.               username="happy" password="happy" 
7.               driverClassName="com.mysql.jdbc.Driver"
8.               url="jdbc:mysql://localhost:3306/happy"/-->
10.     <Resource
11.         name="jdbc/TestDB"
12.         auth="Container"
13.         type="javax.sql.DataSource"
14.         factory="org.logicalcobwebs.proxool.ProxoolDataSource"
15.         proxool.alias="test"
16.         user="happy"
17.         password="happy"
18.         proxool.driver-url="jdbc:mysql://127.0.0.1:1521/happy"
19.         proxool.driver-class="com.mysql.jdbc.Driver"/>
21. </Context>

Conn.java(通过数据源获取连接的类)

 

1. package cn.happy;
3. import java.sql.Connection;
4. import javax.naming.Context;
5. import javax.naming.InitialContext;
6. import javax.sql.DataSource;
8. /**
9.  *
10.  * @author zhappy
11.  */
12. public class Conn {
14.     public Conn() {
15.     }
17.     public static synchronized Connection get() throws Exception {
18.         Context ctx = new InitialContext();
19.         Context envctx = (Context) ctx.lookup("java:comp/env");
20.         DataSource ds = (DataSource) envctx.lookup("jdbc/TestDB");
21.         return ds.getConnection();
22.     }
23. }

index.jsp

1. <%@ page language="java" pageEncoding="GB2312"%>
2. <%@ page import="java.sql.*" %>
3. <%@ page import="javax.sql.*" %>
4. <%@ page import="java.util.*" %>
5. <%@ page import="java.io.*" %>
6. <%@ page import="javax.naming.*" %>
7. <%@ page import="cn.happy.*" %>
9. <html>
10.     <head>
11.         <title>测试</title>
12.     </head>
13.     <body>
14.         <%
16.         Connection conn = null;
17.         Statement st = null;
18.         ResultSet rs = null;
20.         try {
22.             conn = Conn.get();
23.             st = conn.createStatement();
24.             rs = st.executeQuery("select * from goodsmain");
26.             while (rs.next()) {
27.                 out.print(rs.getString(3));%><br><%
28.             }
30.             st.close();
31.             rs.close();
32.             conn.close();
34.         } catch (Exception e) {
35.             e.printStackTrace();
36.         }
38.         %>
39.     </body>
40. </html>

http://localhost:8080/test可以访问index.jsp

http://localhost:8080/test/admin可以访问连接池监控