1、spring-jdbc-DriverManagerDataSource
使用org.springframework.jdbc.datasource.DriverManagerDataSource
说明:需要jar包:spring-jdbc.jar。DriverManagerDataSource只是新建连接,根本没有连接池的作用,不推荐使用
-
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
-
<property name="driverClassName" value="${jdbc.driverClassName}" />
-
<property name="url" value="${jdbc.url}"/>
-
<property name="username" value="${jdbc.username}"/>
-
<property name="password" value="${jdbc.password}"/>
-
</bean>
2、spring-JNDI
使用org.springframework.jndi.JndiObjectFactoryBean
说明:需要在web server中配置数据源,不方便于部署,如果使用高性能服务器WebLogic或Websphere,可以配置
-
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
-
<property name="jndiName" value="java:comp/env/jdbc/bbt"/>
-
</bean>
3、apache-DBCP
使用org.apache.commons.dbcp.BasicDataSource
说明:没有自动回收空闲连接的功能,没有连接池监控,高并发的压力下稳定性有所下降,hibernate已经放弃了DBCP
-
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
-
<property name="driverClassName" value="${jdbc.driverClassName}"/>
-
<property name="url" value="${jdbc.url}"/>
-
<property name="username" value="${jdbc.username}"/>
-
<property name="password" value="${jdbc.password}"/>
-
<property name="initialSize" value="${jdbc.initialSize}"/>
-
<property name="maxActive" value="${jdbc.maxActive}"/>
-
<property name="maxIdle" value="${jdbc.maxIdle}"/>
-
<property name="minIdle" value="${jdbc.minIdle}"/>
-
<property name="maxWait" value="${jdbc.maxWait}"></property>
-
<property name="maxOpenPreparedStatements" value="${jdbc.maxOpenPreparedStatements}" />
-
</bean>
4、c3p0
使用com.mchange.v2.c3p0.ComboPooledDataSource
说明:需要jar包c3p0-0.9.5.1.jar
jdbc.properties
-
driver=com.mysql.jdbc.Driver
-
url=jdbc:mysql://127.0.0.1:3306/steamedbun?useUnicode=true&characterEncoding=UTF-8
-
username=root
-
password=root
-
#连接池初始化时创建的连接数
-
c3p0.initialPoolSize=3
-
#连接池中保留的最小连接数
-
c3p0.minPoolSize=5
-
#连接池中保留的最大连接数
-
c3p0.maxPoolSize=100
-
#连接池无空闲连接可用时,一次性创建的新连接数
-
c3p0.acquireIncrement=3
-
#最大空闲时间
-
c3p0.maxIdleTime=60
-
#每60秒检查所有连接池中的空闲连接
-
c3p0.idleConnectionTestPeriod=60
-
#连接池在获得新连接失败时重试的次数
-
c3p0.acquireRetryAttempts=30
-
#用以控制数据源内加载的PreparedStatements数量
-
c3p0.maxStatements=100
-
#c3p0是异步的,可以提升性能,通过多线程实现多个操作同时被执行
-
c3p0.numHelperThreads=10
spring-mybatis.xml
-
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" destroy-method="close">
-
<property name="driverClassName" value="${driver}" />
-
<property name="url" value="${url}" />
-
<property name="username" value="${username}" />
-
<property name="password" value="${password}" />
-
<property name="password" value="${c3p0.initialPoolSize}" />
-
<property name="password" value="${c3p0.minPoolSize}" />
-
<property name="password" value="${c3p0.maxPoolSize}" />
-
<property name="password" value="${c3p0.acquireIncrement}" />
-
<property name="password" value="${c3p0.maxIdleTime}" />
-
<property name="password" value="${c3p0.idleConnectionTestPeriod}" />
-
<property name="password" value="${c3p0.acquireRetryAttempts}" />
-
<property name="password" value="${c3p0.maxStatements}" />
-
<property name="password" value="${c3p0.numHelperThreads}" />
-
</bean>
5、proxool使用的人比较少,有明显的性能问题,但由于它具备监控功能,因此建议在开发测试时使用
6、weblogic(oracle)的连接池和websphere(IBM)的连接池
7、alibaba druid(德鲁伊)连接池
说明:需要druid.jar,使用com.alibaba.druid.pool.DruidDataSource,据网上测试对比,比目前的DBCP或C3P0数据库连接池性能更好
web.xml
-
<servlet>
-
<servlet-name>DruidStatView</servlet-name>
-
<servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>
-
<init-param>
-
<!-- 允许清空统计数据 -->
-
<param-name>resetEnable</param-name>
-
<param-value>true</param-value>
-
</init-param>
-
<init-param>
-
<!-- 用户名 -->
-
<param-name>loginUsername</param-name>
-
<param-value>druid</param-value>
-
</init-param>
-
<init-param>
-
<!-- 密码 -->
-
<param-name>loginPassword</param-name>
-
<param-value>druid</param-value>
-
</init-param>
-
</servlet>
-
<servlet-mapping>
-
<servlet-name>DruidStatView</servlet-name>
-
<url-pattern>/druid/*</url-pattern>
-
</servlet-mapping>
-
<filter>
-
<filter-name>druidWebStatFilter</filter-name>
-
<filter-class>com.alibaba.druid.support.http.WebStatFilter</filter-class>
-
<init-param>
-
<param-name>exclusions</param-name>
-
<param-value>/public/*,*.js,*.css,/druid*,*.jsp,*.swf</param-value>
-
</init-param>
-
<init-param>
-
<param-name>principalSessionName</param-name>
-
<param-value>sessionInfo</param-value>
-
</init-param>
-
<init-param>
-
<param-name>profileEnable</param-name>
-
<param-value>true</param-value>
-
</init-param>
-
</filter>
-
<filter-mapping>
-
<filter-name>druidWebStatFilter</filter-name>
-
<url-pattern>/*</url-pattern>
-
</filter-mapping>
spring-mybatis.xml
-
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
-
<property name="url" value="${db.master.url}" />
-
<property name="username" value="${db.master.user}" />
-
<property name="password" value="${db.master.password}" />
-
<property name="filters" value="mergeStat,wall,log4j2" /> <!-- 配置监控统计拦截的filters -->
-
<property name="initialSize" value="5" />
-
<property name="maxActive" value="100" />
-
<property name="minIdle" value="10" />
-
<property name="maxWait" value="60000" />
-
<property name="validationQuery" value="SELECT 'x'" />
-
<property name="testOnBorrow" value="true" />
-
<property name="testOnReturn" value="true" />
-
<property name="testWhileIdle" value="true" />
-
<property name="timeBetweenEvictionRunsMillis" value="60000" />
-
<property name="minEvictableIdleTimeMillis" value="300000" />
-
<property name="removeAbandoned" value="true" />
-
<property name="removeAbandonedTimeout" value="1800" />
-
<property name="logAbandoned" value="true" />
-
</bean>