在项目下创建一个db.properties的文件,需要在applicationContext.xml里进行数据解析配置C3P0连接池。
==========================================================
db.properties文件
driverClass=com.mysql.jdbc.Driver
jdbcUrl=jdbc:mysql:///hib_demo
user=root
password=root
initialPoolSize=3
maxPoolSize=6
acquireIncrement=2
============================================================
applicationContext.xml文件
<beans ...>
<!-- 加载Proerties配置文件 -->
<context:property-placeholder location="classpath:xx/xx/xx/db.properties"/>
<!-- 1. 实例化连接池 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${driverClass}"></property>
<property name="jdbcUrl" value="${jdbcUrl}"></property>
<property name="user" value="${user}"></property>
<property name="password" value="${password}"></property>
<property name="initialPoolSize" value="${initialPoolSize}"></property>
<property name="maxPoolSize" value="${maxPoolSize}"></property>
<property name="acquireIncrement" value="${acquireIncrement}"></property>
</bean>
</beans>