Proxool连接池的完整配置

发布时间：2020-12-12 15:43:14 所属栏目：MsSql教程来源：网络整理

导读：1.http://proxool.sourceforge.net/下载最新版本的Proxool,是一个名为proxool-0.9.1.zip的压缩包，解压后将lib下的proxool-0.9.1.jar和proxool-cglib.jar拷贝到项目的lib下. 2.Sql Server的jdbc驱动msbase.jar、mssqlserver.jar、msutil.jar拷贝到项目的lib

1.http://proxool.sourceforge.net/下载最新版本的Proxool,是一个名为proxool-0.9.1.zip的压缩包，解压后将lib下的proxool-0.9.1.jar和proxool-cglib.jar拷贝到项目的lib下.

2.Sql Server的jdbc驱动msbase.jar、mssqlserver.jar、msutil.jar拷贝到项目的lib下.

3.在WEB-INF下新建一个proxool.xml文件

<?xml version="1.0" encoding="UTF-8"?>  <something-else-entirely> <proxool> <alias>mydata</alias> <driver-url>jdbc:microsoft:sqlserver://192.168.1.12:1433;DatabaseName=BrainWeb_QAQC</driver-url> <driver-class>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver-class> <driver-properties> <property name="user" value="sa" /> <property name="password" value="yuanli" /> </driver-properties> <maximum-connection-count>10</maximum-connection-count> <house-keeping-test-sql> select CURRENT_DATE </house-keeping-test-sql> </proxool> </something-else-entirely>

4.修改web.xml

<?xml version="1.0" encoding="UTF-8"?> <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">  <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>  <servlet> <description>ThisisthedescriptionofmyJ2EEcomponent</description> <display-name> ThisisthedisplaynameofmyJ2EEcomponent </display-name> <servlet-name>ConServlet</servlet-name> <servlet-class>servletPackage.ConServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>ConServlet</servlet-name> <url-pattern>/servlet/ConServlet</url-pattern> </servlet-mapping> </web-app>

5.新建测试jsp页面

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>My JSP 'index.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page">  </head> <body> welcome <form method="post" action="servlet/ConServlet" name="form1"> <input type="submit" value="测试连接" name="button1"> </form> </body> </html>

6.新建db包，新建DBConnection.java类

package db; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DBConnection { /** * 方法作用：从连接池取得连接并返回 */ public static Connection getConnection() { Connection conn = null; try { try { // 产生proxool对象 Class.forName("org.logicalcobwebs.proxool.ProxoolDriver") .newInstance(); } catch (InstantiationException e1) { e1.printStackTrace(); } catch (IllegalAccessException e1) { e1.printStackTrace(); } try { // 从连接池获得连接 conn = DriverManager.getConnection("proxool.mydata"); } catch (SQLException e) { e.printStackTrace(); } } catch (ClassNotFoundException e) { e.printStackTrace(); } return conn; } }

7.新建servletPackage包，新建ConServlet.java类(Servlet)

package servletPackage; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import db.DBConnection; import java.sql.*; public class ConServlet extends HttpServlet { /** * Constructor of the object. */ public ConServlet() { super(); } /** * Destruction of the servlet. <br> */ public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } /** * The doGet method of the servlet. <br> * * This method is called when a form has its tag value method equals to get. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException { } /** * The doPost method of the servlet. <br> * * This method is called when a form has its tag value method equals to post. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doPost(HttpServletRequest request,IOException { Connection conn=DBConnection.getConnection(); } /** * Initialization of the servlet. <br> * * @throws ServletException if an error occure */ public void init() throws ServletException { // Put your code here } }

8.测试http://localhost:8080/test/9.监控连接状态：http://localhost:8080/test/Admin

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!