独角兽企业重金招聘Python工程师标准>>>
需要的jar包包括
WEB-INF/proxool-mysql.xml
<?xmlversion="1.0"encoding="UTF-8"?><something-else-entirely><proxool><alias>mysql</alias><driver-url>jdbc:mysql://localhost:3306/likereading</driver-url><driver-class>com.mysql.jdbc.Driver</driver-class><driver-properties><propertyname="user"value="root"/><propertyname="password"value="root"/></driver-properties><maximum-connection-count>100</maximum-connection-count><prototype-count>15</prototype-count><minimum-connection-count>5</minimum-connection-count><maximum-active-time>1000</maximum-active-time><house-keeping-sleep-time>30000</house-keeping-sleep-time><house-keeping-test-sql>selectCURRENT_DATE</house-keeping-test-sql></proxool></something-else-entirely>
WEB-INF/web.xml
<?xmlversion="1.0"encoding="UTF-8"?><web-appxmlns:xsi="/2001/XMLSchema-instance"xmlns="/xml/ns/javaee"xmlns:web="/xml/ns/javaee/web-app_2_5.xsd"xsi:schemaLocation="/xml/ns/javaee/xml/ns/javaee/web-app_3_0.xsd"version="3.0"><display-name>LikeReading</display-name><context-param><param-name>webAppRootKey</param-name><param-value>LikeReading.root</param-value></context-param><!------proxool配置---------------><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-mysql.xml</param-value></init-param><load-on-startup>1</load-on-startup></servlet><servlet><servlet-name>proxool</servlet-name><servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class></servlet><!------proxool配置---------------><servlet><servlet-name>UserCtxServlet</servlet-name><servlet-class>cn.twt.svx.controllers.UserCtxServlet</servlet-class></servlet><servlet-mapping><servlet-name>UserCtxServlet</servlet-name><url-pattern>/UserCtx.do</url-pattern></servlet-mapping><servlet><servlet-name>BookCtxServlet</servlet-name><servlet-class>cn.twt.svx.controllers.BookCtxServlet</servlet-class></servlet><servlet-mapping><servlet-name>BookCtxServlet</servlet-name><url-pattern>/BookCtx.do</url-pattern></servlet-mapping><servlet><servlet-name>HomeCtrlServlet</servlet-name><servlet-class>cn.twt.svx.controllers.HomeCtrlServlet</servlet-class></servlet><servlet-mapping><servlet-name>proxool</servlet-name><url-pattern>/proxool</url-pattern></servlet-mapping><filter><filter-name>setCharacterEncoding</filter-name><filter-class>cn.twt.svx.filter.EncodingFilter</filter-class><init-param><param-name>encoding</param-name><param-value>utf-8</param-value></init-param></filter><filter-mapping><filter-name>setCharacterEncoding</filter-name><url-pattern>/*</url-pattern></filter-mapping><filter><filter-name>logfilter</filter-name><filter-class>cn.twt.svx.filter.LogFilter</filter-class></filter><filter-mapping><filter-name>logfilter</filter-name><url-pattern>/*</url-pattern></filter-mapping><servlet-mapping><servlet-name>HomeCtrlServlet</servlet-name><url-pattern>/index.jsp</url-pattern></servlet-mapping><servlet-mapping><servlet-name>HomeCtrlServlet</servlet-name><url-pattern>/index.html</url-pattern></servlet-mapping><servlet-mapping><servlet-name>HomeCtrlServlet</servlet-name><url-pattern>/index.htm</url-pattern></servlet-mapping><servlet-mapping><servlet-name>HomeCtrlServlet</servlet-name><url-pattern>/index.php</url-pattern></servlet-mapping><servlet-mapping><servlet-name>HomeCtrlServlet</servlet-name><url-pattern>/index.asp</url-pattern></servlet-mapping><servlet-mapping><servlet-name>HomeCtrlServlet</servlet-name><url-pattern>/index.do</url-pattern></servlet-mapping><welcome-file-list><welcome-file>index.jsp</welcome-file><welcome-file>index.html</welcome-file></welcome-file-list><session-config><session-timeout>3600000</session-timeout></session-config><error-page><error-code>404</error-code><location>/NotFound.jsp</location></error-page><error-page><exception-type>exception.ServletNotFound</exception-type><location>/sorry.jsp</location></error-page><error-page><exception-type>java.lang.NullPointerException</exception-type><location>/sorry.jsp</location></error-page></web-app>
连接工具类
packagecn.twt.svx.utils;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;mons.logging.Log;mons.logging.LogFactory;publicclassDBFactory{privatestaticDBFactoryinstance=null;publicstaticLoglog=LogFactory.getLog(DBFactory.class);privateDBFactory(){try{Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");}catch(ClassNotFoundExceptione){log.error(e.getLocalizedMessage(),e);}}publicstaticDBFactorygetInstance(){if(instance==null){synchronized(DBFactory.class){if(instance==null){instance=newDBFactory();}}}returninstance;}publicConnectiongetConnection(){Connectionconn=null;try{conn=DriverManager.getConnection("proxool.mysql");}catch(SQLExceptione){e.printStackTrace();}returnconn;}publicstaticvoidquietClose(ConnectionsqlConn){if(sqlConn!=null){try{sqlConn.close();}catch(SQLExceptione){e.printStackTrace();log.error(e.getLocalizedMessage(),e);}}}}
如果觉得《JSP proxool+mysql数据库连接池配置》对你有帮助，请点赞、收藏，并留下你的观点哦！
