<!-- 配置数据源 -->
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:mysql://localhost:3306/dbname</value>
</property>
<property name="username">
<value>root</value>
</property>
<property name="password">
<value>******</value>
</property>
<property name="maxActive"> //最大活动连接数
<value>100</value>
</property>
<property name="maxWait"> //最长等待时间
<value>1000</value>
</property>
<property name="maxIdle">
<value>30</value>
</property>
<property name="defaultAutoCommit">
<value>true</value>
</property>
<property name="removeAbandoned"> //自动回收连接池,避免连接池泄露
<value>true</value>
</property>
<property name="removeAbandonedTimeout">
<value>60</value>
</property>
</bean>