TA的每日心情 | 开心
2021-3-12 23:18 |
|---|
签到天数: 2 天 [LV.1]初来乍到
|
|
1、先写xml文件：Proxool.xml放入你的WEB应用程序的WEB-INFclasses下面,内容如下：
<?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>xml-test</alias>
<driver-url>jdbc:mysql://localhost:3306/soft</driver-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<driver-properties>
<property name="user" value="root"/>
<property name="password" value=""/>
</driver-properties>
<maximum-connection-count>10</maximum-connection-count>
<house-keeping-test-sql>select CURRENT_DATE
</house-keeping-test-sql>
</proxool>
</something-else-entirely>
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>xmlFile</param-name>
<param-value>WEB-INF/classes/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>
</web-app>
3、将驱动程序mm.mysql-2.0.14-bin.jar与proxool-0.8.3.jar及crimson.jar放入WEB-INFlib目录下。
4、测试的jsp文件：
<%@ page import="java.sql.*" %>
<%@ page contentType="text/HTML;charset=GB2312" %>
<html>
<head>
<title>CH14 - Proxool.jsp</title>
</head>
<body>
<h2>使用 Proxool Connection Pool,用xml文件配置</h2>
<%
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try{
con = DriverManager.getConnection("proxool.xml-test");
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);
}
}
%>
</body>
</html>
5、后台统计与信息
请进入：http://127.0.0.1:8080/testpxool1/Admin
(testpxool1应改为你的WEB应用程序名)
源码下载：http://file.javaxxz.com/2014/10/11/005859718.zip |
|
|手机版|Java学习者论坛
( 声明：本站资料整理自互联网，用于Java学习者交流学习使用，对资料版权不负任何法律责任，若有侵权请及时联系客服屏蔽删除 )
发表于 2014-10-11 00:59:00