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文件中加入依赖

 

 

1. <!-- 连接池 -->

2. <dependency>

3. <groupId>com.alibaba</groupId>

4. <artifactId>druid</artifactId>

5. <version>1.1.1</version>

6. </dependency>

 

 

修改spring中的连接池配置

web.xml中添加

 

1. <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">

2. <!-- 数据库基本信息配置 -->

3. <property name="url" value="${url}" />

4. <property name="username" value="${user}" />

5. <property name="password" value="${password}" />

6. <property name="driverClassName" value="${driverClassName}" />

7. <property name="filters" value="${filters}" />

8. <!-- 最大并发连接数 -->

9. <property name="maxActive" value="${maxActive}" />

10. <!-- 初始化连接数量 -->

11. <property name="initialSize" value="${initialSize}" />

12. <!-- 最小空闲连接数 -->

13. <property name="minIdle" value="${minIdle}" />

14. <!-- 配置获取连接等待超时的时间 -->

15. <property name="maxWait" value="${maxWait}" />

16. <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->

17. <property name="timeBetweenEvictionRunsMillis" value="${timeBetweenEvictionRunsMillis}" />

18. <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->

19. <property name="minEvictableIdleTimeMillis" value="${minEvictableIdleTimeMillis}" />

20. <property name="validationQuery" value="${validationQuery}" />

21. <property name="testWhileIdle" value="${testWhileIdle}" />

22. <property name="testOnBorrow" value="${testOnBorrow}" />

23. <property name="testOnReturn" value="${testOnReturn}" />

24. <property name="maxOpenPreparedStatements" value="${maxOpenPreparedStatements}" />

25. <!-- 打开removeAbandoned功能 -->

26. <property name="removeAbandoned" value="${removeAbandoned}" />

27. <!-- 1800秒，也就是30分钟 -->

28. <property name="removeAbandonedTimeout" value="${removeAbandonedTimeout}" />

29. <!-- 关闭abanded连接时输出错误日志 -->

30. <property name="logAbandoned" value="${logAbandoned}" />

31. </bean>

 

 

db-config.properties

 

1. url=jdbc:mysql://xx.xx.xx.xx:3306

2. user=

3. password=

4. driverClassName=com.mysql.jdbc.Driver

5. filters=stat

6. maxActive=20

7. initialSize=1

8. maxWait=60000

9. minIdle=10

10. maxIdle=15

11. timeBetweenEvictionRunsMillis=60000

12. minEvictableIdleTimeMillis=300000

13. validationQuery=SELECT 'x'

14. testWhileIdle=true

15. testOnBorrow=false

16. testOnReturn=false

17. maxOpenPreparedStatements=20

18. removeAbandoned=true

19. removeAbandonedTimeout=1800

20. logAbandoned=true

web.xml中添加

 

1. <servlet>

2. <servlet-name>DruidStatView</servlet-name>

3. <servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>

4. </servlet>

5. <servlet-mapping>

6. <servlet-name>DruidStatView</servlet-name>

7. <url-pattern>/druid/*</url-pattern>

8. </servlet-mapping>

 

配置修改完成

 

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

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