如何在tomcat中配置數據池

Question

server.xml
----------------------------------------------------------------------------------
<Context path="/ljc" docBase="c:\\ljctest" debug="5" reload="true">
<Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_DBTest_log." suffix=".txt" timestamp="true"/>
<Resource name="jdbc/TestDB" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/TestDb">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10000</value>
</parameter> <parameter>
<name>username</name>
<value>sa</value>
</parameter>
<parameter>
<name>password</name>
<value>syssys</value>
</parameter> <parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter> <parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://10.66.39.100:1433;databasename=javatest</value>
</parameter>
</ResourceParams>
</Context>
web.xml
---------------------------------------------------------------------------------- <resource-ref>
<description>DB connection</description>
<res-ref-name>jdbc/TestDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<recource-ref>bean or servlet or jsp
----------------------------------------------------------------------------------
Connection conn;
Context ctx=new InitialContext();
DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/TestDB");
conn=ds.getConnection();