SSH框架整合连接池proxool的配置

1. 添加所需架包：proxool-0.9.jar.

2. 准备属性文件：pool.properties.

?

#pool-proxooldriver=com.mysql.jdbc.DriverdriverUrl=jdbc\:mysql\://127.0.0.1\:3306/StudentDB?user\=root&password\=***&useUnicode\=true&characterEncoding\=utf-8&characterSetResults\=UTF-8user=rootpassword=***alias=proxoolPoolhouseKeepingSleepTime=30000prototypeCount=20minimumConnectionCount=5maximumConnectionCount=30maximumActiveTime=300000trace=trueverbose=truehouseKeepingTestSql=select CURRENT_DATEsimultaneousBuildThrottle=50

?

3. 修改spring配置文件

?

    <!-- ========================================================= -->    <!--                   加载属性文件                      -->    <!-- ========================================================= --><context:property-placeholder location="/WEB-INF/*.properties"/>    <!-- ========================================================= -->    <!--                  配置  proxool  连接池                  -->    <!-- ========================================================= --><bean id="dataSource" value="${driver}" /><property name="driverUrl" value="${driverUrl}" /><property name="user" value="${user}" /><property name="password" value="${password}" /><property name="alias" value="${alias}" /><property name="maximumActiveTime" value="${maximumActiveTime}" /><property name="prototypeCount" value="${prototypeCount}" /><property name="trace" value="${trace}" /><property name="verbose" value="${verbose}" /><property name="houseKeepingSleepTime" value="${houseKeepingSleepTime}" /><property name="maximumConnectionCount" value="${maximumConnectionCount}" /><property name="minimumConnectionCount" value="${simultaneousBuildThrottle}" /><property name="simultaneousBuildThrottle" value="${simultaneousBuildThrottle}" /><property name="houseKeepingTestSql" value="${houseKeepingTestSql}" /></bean>

?

?