spring整合c3p0连接池
<!-- 读取db.properties文件 --> <context:property-placeholder location="classpath:db.properties"/> <!-- 配置c3p0连接池 --> <bean name="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="${jdbc.driverClass}"></property> <property name="user" value="${jdbc.user}"></property> <property name="password" value="${jdbc.password}"></property> <property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property> </bean>
db.properties内容
jdbc.driverClass=com.mysql.jdbc.Driver jdbc.user=root jdbc.password=password jdbc.jdbcUrl=jdbc:mysql://localhost:3306/mybase?characterEncoding=utf8&useUnicode=true&useSSL=false&serverTimezone=UTC