(一) DBCP 引入jar文件 commons-dbcp-1.2.1.jar
commons-pool-1.3.jar二个包。 spring配置文件 <bean id="dataSource3" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="${DBCP.driverClass}"></property> <property name="url" value="${DBCP.url}"></property> <property name="username" value="${DBCP.user}"></property> <property name="password" value="${DBCP.password}"></property> </bean> (二) C3P0 引入jar文件 c3p0-0.9.1.2.jar spring配置文件 <bean id="dataSource2" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close"> <property name="driverClass" value="${c3p0.driverClass}"></property> <property name="jdbcUrl" value="${c3p0.url}"></property> <property name="user" value="${c3p0.user}"></property> <property name="password" value="${c3p0.password}"></property> </bean> jdbc.properties配置文件 ######C3P0 MySQL config ####### c3p0.driverClass=com.mysql.jdbc.Driver c3p0.url=jdbc\:mysql\://localhost\:3306/smscore?useUnicode\=true&characterEncoding\=utf8&mysqlEncoding\=utf8 c3p0.user=root c3p0.password=***** (三) Bonecp 引入jar文件 Bonecp-0.7.0.jar google-collections-1.0.jar spring配置文件 <bean id="dataSource4" class="com.jolbox.bonecp.BoneCPDataSource" destroy-method="close"> <property name="driverClass" value="${BONECP.driverClass}"></property> <property name="jdbcUrl" value="${BONECP.url}"></property> <property name="username" value="${BONECP.user}"></property> <property name="password" value="${BONECP.password}"></property> </bean> jdbc.properties配置文件 ######BONECP MySQL config ####### BONECP.driverClass=com.mysql.jdbc.Driver BONECP.url=jdbc\:mysql\://localhost\:3306/smscore?user=root&password=***** BONECP.user=root BONECP.password=***** (四) proxool 引入jar文件 proxool-0.9.1.jar proxool-cglib.jar spring配置文件 <bean id="dataSource5" class="org.logicalcobwebs.proxool.ProxoolDataSource"> <property name="alias" value="QuancunPool"></property> <property name="driver" value="${Proxool.driverClass}"></property> <property name="driverUrl" value="${Proxool.url}"></property> <property name="user" value="${Proxool.user}"></property> <property name="password" value="${Proxool.password}"></property> </bean> 补充 <!-- 配置DataSource --> <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="locations"> <list> <value>classpath:jdbc.properties</value> </list> </property> </bean>
常用的4种,分别是DBCP,C3P0,Bonecp,proxool,关于这个4个连接池的具体参数设置我再另写;
分别说下这4种在spring中如何配置;