Proxool:java连接池中的一种,众议,proxool>c3p0>dbcp
1.http://proxool.sourceforge.net下载proxool的jar
2.将proxool的jar导入web工程的lib中,导入mysql的jar
3.于web-info下建立文件proxool.xml,内容如下:
mysql
jdbc:mysql://127.0.0.1:3306/mydb
com.mysql.jdbc.Driver
10
4.于web-info/web.xml添加2个servlet,内容:
xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2eehttp://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
proxoolServletConfigurator
org.logicalcobwebs.proxool.configuration.ServletConfigurator
xmlFile
WEB-INF/proxool.xml
1
Admin
org.logicalcobwebs.proxool.admin.servlet.AdminServlet
Admin
/admin
5.测试jsp
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>