c3p0数据连接池更换为druid

参考：

Druid 介绍及配置

http://www.cnblogs.com/niejunlei/p/5977895.html

配置_DruidDataSource参考配置

https://github.com/alibaba/druid/wiki/%E9%85%8D%E7%BD%AE_DruidDataSource%E5%8F%82%E8%80%83%E9%85%8D%E7%BD%AE

阿里巴巴-德鲁伊druid连接池配置

http://blog.csdn.net/archer119/article/details/51771671

pom.xml文件中加入依赖

<!-- 连接池 --> <dependency>     <groupId>com.alibaba</groupId>     <artifactId>druid</artifactId>     <version>1.1.1</version> </dependency> 

修改spring中的连接池配置

web.xml中添加

<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">      <!-- 数据库基本信息配置 -->    <property name="url" value="${url}" />     <property name="username" value="${user}" />     <property name="password" value="${password}" /> <property name="driverClassName" value="${driverClassName}" /><property name="filters" value="${filters}" /><!-- 最大并发连接数 --><property name="maxActive" value="${maxActive}" /><!-- 初始化连接数量 --><property name="initialSize" value="${initialSize}" /><!-- 最小空闲连接数 --><property name="minIdle" value="${minIdle}" /><!-- 配置获取连接等待超时的时间 --><property name="maxWait" value="${maxWait}" /><!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 --><property name="timeBetweenEvictionRunsMillis" value="${timeBetweenEvictionRunsMillis}" /><!-- 配置一个连接在池中最小生存的时间，单位是毫秒 --><property name="minEvictableIdleTimeMillis" value="${minEvictableIdleTimeMillis}" /><property name="validationQuery" value="${validationQuery}" /><property name="testWhileIdle" value="${testWhileIdle}" /><property name="testOnBorrow" value="${testOnBorrow}" /><property name="testOnReturn" value="${testOnReturn}" /><property name="maxOpenPreparedStatements" value="${maxOpenPreparedStatements}" /><!-- 打开removeAbandoned功能 --><property name="removeAbandoned" value="${removeAbandoned}" /><!-- 1800秒，也就是30分钟 --><property name="removeAbandonedTimeout" value="${removeAbandonedTimeout}" /><!-- 关闭abanded连接时输出错误日志 --><property name="logAbandoned" value="${logAbandoned}" />  </bean>

db-config.properties

url=jdbc:mysql://xx.xx.xx.xx:3306user=password=driverClassName=com.mysql.jdbc.Driverfilters=statmaxActive=20initialSize=1maxWait=60000minIdle=10maxIdle=15timeBetweenEvictionRunsMillis=60000minEvictableIdleTimeMillis=300000validationQuery=SELECT 'x'testWhileIdle=truetestOnBorrow=falsetestOnReturn=falsemaxOpenPreparedStatements=20removeAbandoned=trueremoveAbandonedTimeout=1800logAbandoned=true

web.xml中添加

   <servlet>          <servlet-name>DruidStatView</servlet-name>          <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>      </servlet>      <servlet-mapping>          <servlet-name>DruidStatView</servlet-name>          <url-pattern>/druid/*</url-pattern>     </servlet-mapping>  

配置修改完成

为Druid监控配置访问权限(配置访问监控信息的用户与密码)

http://blog.csdn.net/renfufei/article/details/39553639