📄 在不修改tomcat下的servlet.xml的情况下使用连接池!.txt
字号:
在不修改TOMCAT下的SERVLET.XML的情况下使用连接池!
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" %>
<html>
<head>
<title>CH14 - Proxool.jsp</title>
</head>
<body>
<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);
}
}
%>
</body>
</html>
5、后台统计与信息
请进入：http://127.0.0.1:8080/testpxool/Admin
(testpxool应改为你的WEB应用程序名)
---------------------------------------------------------------------------------
1、先写一个属性文件：Proxool.properties,放入你的WEB应用程序的WEB-INF\classes下面,内容如下：
jdbc-0.proxool.alias=mssql
jdbc-0.proxool.driver-class=com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc-0.proxool.driver-url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=数据库名称","数据库用户名","数据库密码"
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" %>
<html>
<head>
<title>CH14 - Proxool.jsp</title>
</head>
<body>
<h2>使用 Proxool Connection Pool</h2>
<%
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
try{
con = DriverManager.getConnection("proxool.mssql");
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/testpxool/Admin
(testpxool应改为你的WEB应用程序名)
====================================================
以上为ＭＳＳＱＬ的连接方式，把ＭＳＳＱＬ的驱动放到ＬＩＢ下就可以了
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -