BoneCP(马勒・格・彼得)

 1) BoneCP加入工程

Xml代码 

<dependency><groupId>com.jolbox</groupId><artifactId>bonecp</artifactId><version>0.7.1.RELEASE</version></dependency>

2)bonecp.properties放在classpath下

Properties代码  

################################################################################### BoneCP 数据库连接池###################################################################################---------------------------------------------------------------------------------# 基本设置#---------------------------------------------------------------------------------bonecp.driverClass=com.mysql.jdbc.Driverbonecp.jdbcUrl=jdbc:mysql://localhost:3306/testbonecp.username=rootbonecp.password=root#---------------------------------------------------------------------------------# 高级设置#  idleConnectionTestPeriodInMinutes - 检查数据库连接池中空闲连接的间隔时间(分) 默认：240#  idleMaxAgeInMinutes - 连接池中未使用的链接最大存活时间(分) 默认：240#  minConnectionsPerPartition - 每个分区最小的连接数#  maxConnectionsPerPartition - 每个分区最大的连接数#  partitionCount - 分区数 默认值：2，最小值：1，#  acquireIncrement - 连接数不够时，每次创建的新链接个数 默认值：2#  statementsCacheSize - Statement实例缓存个数 默认值：0#  releaseHelperThreads - 每个分区释放链接助理进程的数量 默认值：3#---------------------------------------------------------------------------------bonecp.idleConnectionTestPeriodInMinutes=240bonecp.idleMaxAgeInMinutes=60bonecp.minConnectionsPerPartition=5bonecp.maxConnectionsPerPartition=15bonecp.partitionCount=1bonecp.acquireIncrement=2bonecp.statementsCacheSize=0bonecp.releaseHelperThreads=3

 

3)在Spring中配置数据源

 

Xml代码   

<context:property-placeholder location="classpath:bonecp.properties" /><bean id="dataSource" class="com.jolbox.bonecp.BoneCPDataSource" destroy-method="close"><property name="driverClass" value="${bonecp.driverClass}" /><property name="jdbcUrl" value="${bonecp.jdbcUrl}" /><property name="username" value="${bonecp.username}" /><property name="password" value="${bonecp.password}" /><property name="idleConnectionTestPeriodInMinutes" value="${bonecp.idleConnectionTestPeriodInMinutes}" /><property name="idleMaxAgeInMinutes" value="${bonecp.idleMaxAgeInMinutes}" /><property name="minConnectionsPerPartition" value="${bonecp.minConnectionsPerPartition}" /><property name="maxConnectionsPerPartition" value="${bonecp.maxConnectionsPerPartition}" /><property name="partitionCount" value="${bonecp.partitionCount}" /><property name="acquireIncrement" value="${bonecp.acquireIncrement}" /><property name="statementsCacheSize" value="${bonecp.statementsCacheSize}" /><property name="releaseHelperThreads" value="${bonecp.releaseHelperThreads}" /></bean>