spring配置 数据源datasource和连接池 的7种方式

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>