采用struts集成DBCP连接数据库时,只需要配置struts-config.xml,并且把包commons-collections-3.1.jar,commons-dbcp-1.2.1.jar,commons-pool-1.2.jar,mysql-connector-java-5.0.0-beta-bin.jar放到/WEB-INF/lib下,注意---mysql的驱动包不需要放置到Tomcat(容器)下的common/lib下,因为当前的连接池不属于容器管理!!
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName"
value="org.gjt.mm.mysql.Driver" />
<set-property property="url"
value="jdbc:mysql://localhost:3306/struts" />
<set-property property="username" value="root" />
<set-property property="password" value="5228" />
<set-property property="maxActive" value="10" />
<set-property property="maxWait" value="5000" />
<set-property property="defaultAutoCommit" value="false" />
<set-property property="defaultReadOnly" value="false" />
<set-property property="validationQuery"
value="SELECT * FROM USER_INFO" />
</data-source>
</data-sources>