spring 中c3p0的优化配置

jdbc.properties 

driverClass=com.mysql.jdbc.Driver
jdbcUrl=jdbc:mysql://localhost:3306/testdb
user=root
password=123456
initialPoolSize=3
maxPoolSize=20

dataSource Bean配置

 1 <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
 2         destroy-method="close">
 3         <property name="driverClass" value="${driverClass}"></property>
 4         <property name="jdbcUrl" value="${jdbcUrl}"></property>
 5         <property name="user" value="${user}"></property>
 6         <property name="password" value="${password}"></property>
 7         <property name="initialPoolSize" value="${initialPoolSize}"></property>
 8         <property name="maxPoolSize" value="${maxPoolSize}"></property>
 9         <property name="maxIdleTime" value="300"></property>
10 </bean>