<!-- 数据源 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/autotest" />
<property name="username" value="******" />
<property name="password" value="******" />
<property name="maxActive" value="20"></property>
<property name="initialSize" value="1"></property>
<property name="maxWait" value="1000"></property>
<property name="maxIdle" value="20"></property>
<property name="minIdle" value="3"></property>
<!-- 验证使用的SQL语句 -->
<property name="validationQuery" value="SELECT 1"></property>
<!-- 指明连接是否被空闲连接回收器(如果有)进行检验.如果检测失败,则连接将被从池中去除. -->
<property name="testWhileIdle" value="true"></property>
<!-- 借出连接时不要测试,否则很影响性能 -->
<property name="testOnBorrow" value="false"></property>
<!-- 每30秒运行一次空闲连接回收器 -->
<property name="timeBetweenEvictionRunsMillis" value="30000"></property>
<!-- 池中的连接空闲30分钟后被回收 -->
<property name="minEvictableIdleTimeMillis" value="1800000"></property>
<!-- 在每次空闲连接回收器线程(如果有)运行时检查的连接数量 -->
<property name="numTestsPerEvictionRun" value="10"></property>
<property name="logAbandoned" value="true"></property>
<property name="removeAbandoned" value="true"></property>
<property name="removeAbandonedTimeout" value="180"></property>
<property name="connectionProperties" value="clientEncoding=UTF-8"></property>
</bean>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/autotest" />
<property name="username" value="******" />
<property name="password" value="******" />
<property name="maxActive" value="20"></property>
<property name="initialSize" value="1"></property>
<property name="maxWait" value="1000"></property>
<property name="maxIdle" value="20"></property>
<property name="minIdle" value="3"></property>
<!-- 验证使用的SQL语句 -->
<property name="validationQuery" value="SELECT 1"></property>
<!-- 指明连接是否被空闲连接回收器(如果有)进行检验.如果检测失败,则连接将被从池中去除. -->
<property name="testWhileIdle" value="true"></property>
<!-- 借出连接时不要测试,否则很影响性能 -->
<property name="testOnBorrow" value="false"></property>
<!-- 每30秒运行一次空闲连接回收器 -->
<property name="timeBetweenEvictionRunsMillis" value="30000"></property>
<!-- 池中的连接空闲30分钟后被回收 -->
<property name="minEvictableIdleTimeMillis" value="1800000"></property>
<!-- 在每次空闲连接回收器线程(如果有)运行时检查的连接数量 -->
<property name="numTestsPerEvictionRun" value="10"></property>
<property name="logAbandoned" value="true"></property>
<property name="removeAbandoned" value="true"></property>
<property name="removeAbandonedTimeout" value="180"></property>
<property name="connectionProperties" value="clientEncoding=UTF-8"></property>
</bean>