proxool使用（DataSource、MySQL）

最新推荐文章于 2021-02-28 23:41:19 发布

最新推荐文章于 2021-02-28 23:41:19 发布 · 258 阅读

文章标签：

#数据库 #java

本文详细介绍了如何使用Proxool配置数据库连接池，并通过示例代码展示了如何在Java Web应用中设置和使用Proxool连接池。包括proxool.xml配置文件、web.xml和context.xml的具体设置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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

proxool.xml

 
  <?xmlversion="1.0"encoding="gbk"?> 
<!--
Document:proxool.xml
Createdon:2008年12月2日,下午1:09
Author:zhappy
Description:
Purposeofthedocumentfollows.
 --> 
 <something-else-entirely> 
 <proxool> 
 <alias>test</alias> 
 <driver-url>jdbc:mysql://127.0.0.1:3306/happy</driver-url> 
 <driver-class>com.mysql.jdbc.Driver</driver-class> 
 <driver-properties> 
 <propertyname="user"value="happy"/> 
 <propertyname="password"value="happy"/> 
 </driver-properties> 
 <house-keeping-sleep-time>90000</house-keeping-sleep-time> 
 <house-keeping-test-sql>selectcurdate()</house-keeping-test-sql> 
 <simultaneous-build-throttle>150</simultaneous-build-throttle> 
 <prototype-count>3</prototype-count> 
 <maximum-connection-count>100</maximum-connection-count> 
 <minimum-connection-count>3</minimum-connection-count> 
 </proxool> 
 </something-else-entirely> 

web.xml

 
  <?xmlversion="1.0"encoding="UTF-8"?> 
 <web-appversion="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/javaeehttp://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"> 
 <resource-ref> 
 <description>DBConnection</description> 
 <res-ref-name>jdbc/TestDB</res-ref-name> 
 <res-type>javax.sql.DataSource</res-type> 
 <res-auth>Container</res-auth> 
 </resource-ref> 
 <servlet> 
 <servlet-name>ServletConfigurator</servlet-name> 
 <servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class> 
 <init-param> 
 <param-name>xmlFile</param-name> 
 <param-value>WEB-INF/proxool.xml</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> 
 <session-config> 
 <session-timeout> 
30
 </session-timeout> 
 </session-config> 
 <welcome-file-list> 
 <welcome-file>index.jsp</welcome-file> 
 </welcome-file-list> 
 </web-app> 

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

 
  <?xmlversion="1.0"encoding="UTF-8"?> 
 <ContextantiJARLocking="true"path="/test"> 
 <!--Resourcename="jdbc/TestDB"auth="Container" 
 type="javax.sql.DataSource" 
 maxActive="100"maxIdle="30"maxWait="10000" 
 username="happy"password="happy" 
 driverClassName="com.mysql.jdbc.Driver" 
 url="jdbc:mysql://localhost:3306/happy"/--> 
 <Resource 
 name="jdbc/TestDB" 
 auth="Container" 
 type="javax.sql.DataSource" 
 factory="org.logicalcobwebs.proxool.ProxoolDataSource" 
 proxool.alias="test" 
 user="happy" 
 password="happy" 
 proxool.driver-url="jdbc:mysql://127.0.0.1:1521/happy" 
 proxool.driver-class="com.mysql.jdbc.Driver"/> 
 </Context> 

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

 
  packagecn.happy; 
 importjava.sql.Connection; 
 importjavax.naming.Context; 
 importjavax.naming.InitialContext; 
 importjavax.sql.DataSource; 
 /** 
*
*@authorzhappy
 */ 
 publicclassConn{ 
 publicConn(){ 
}
 publicstaticsynchronizedConnectionget()throwsException{ 
 Contextctx=newInitialContext(); 
 Contextenvctx=(Context)ctx.lookup("java:comp/env"); 
 DataSourceds=(DataSource)envctx.lookup("jdbc/TestDB"); 
 returnds.getConnection(); 
}
}

index.jsp

 
  <%@pagelanguage="java"pageEncoding="GB2312"%> 
 <%@pageimport="java.sql.*"%> 
 <%@pageimport="javax.sql.*"%> 
 <%@pageimport="java.util.*"%> 
 <%@pageimport="java.io.*"%> 
 <%@pageimport="javax.naming.*"%> 
 <%@pageimport="cn.happy.*"%> 
 <html> 
 <head> 
 <title>测试</title> 
 </head> 
 <body> 
 <% 
 Connectionconn=null; 
 Statementst=null; 
 ResultSetrs=null; 
try{
 conn=Conn.get(); 
 st=conn.createStatement(); 
 rs=st.executeQuery("select*fromgoodsmain"); 
while(rs.next()){
 out.print(rs.getString(3));%><br><% 
}
st.close();
rs.close();
conn.close();
}catch(Exceptione){
e.printStackTrace();
}
 %> 
 </body> 
 </html> 