数据库连接池配置

一、Tomcat中的Server.xml配置

<Context docBase="Olympic" path="/Olympic" reloadable="true" source="org.eclipse.jst.jee.server:Olympic">           <Logger className="org.apache.catalina.logger.FileLogger" prefix="localhost_MSSQL_Log." suffix=".txt" timestamp="true"/>             <Resource name="jdbc/olympic" auth="Container" type="javax.sql.DataSource"             factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="5" minIdle="2" maxWait="5"             username="sa" password="sa" driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"             url="jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=olympic" />       </Context>

此Context放到Server.xml文件的Host中
二、在WEB应用中引用数据源

<resource-ref>         <description>Movie Datasource</description>         <res-ref-name>jdbc/olympic</res-ref-name>         <res-type>javax.sql.DataSource</res-type>         <res-auth>Container</res-auth>     </resource-ref>

将此内容放到WEB.xml文件中