项目使用druid连接池

69 阅读 0 评论 46 点赞

我是靠谱客的博主温柔蜜蜂，最近开发中收集的这篇文章主要介绍项目使用druid连接池，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

步骤一：pom.xml

< dependency >

< groupId > com.alibaba </ groupId >

< artifactId > druid </ artifactId >

< version > 1.0.24 </ version >

</ dependency >

步骤二： applicationContext.xml

< bean id = "dataSource" class = "com.alibaba.druid.pool.DruidDataSource"

init-method = "init" destroy-method = "close" >

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

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

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

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

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

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

< property name = "maxIdle" value = "${maxIdle}" />

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

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

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

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

< 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 = "poolPreparedStatements" value = "${poolPreparedStatements}" />

< property name = "maxPoolPreparedStatementPerConnectionSize" value = "${maxPoolPreparedStatementPerConnectionSize}" />

<!--属性类型是字符串，通过别名的方式配置扩展插件，常用的插件有：

监控统计用的filter:stat

日志用的filter:log4j

防御SQL注入的filter:wall -->

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

</ bean >

步骤三：jdbc.properties

driverClassName = oracle.jdbc.driver.OracleDriver

url = jdbc:oracle:thin:@127.0.0.1:1521:ORCL

username = apm

password = root

initialSize = 5

maxActive = 10

minIdle = 3

maxIdle = 10

maxWait = 60000

removeAbandoned = true

removeAbandonedTimeout = 180

timeBetweenEvictionRunsMillis = 60000

minEvictableIdleTimeMillis = 300000

validationQuery = SELECT 1 FROM DUAL

testWhileIdle = true

testOnBorrow = false

testOnReturn = false

poolPreparedStatements = true

maxPoolPreparedStatementPerConnectionSize = 50

filters = stat

步骤四：web.xml

< 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 > *.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/* </ param-value >

</ init-param >

</ filter >

< filter-mapping >

< filter-name > DruidWebStatFilter </ filter-name >

< url-pattern > /* </ url-pattern >

</ filter-mapping >

< 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 >

监控的url为： http://localhost:8888/xxzx /druid/index.html

最后

以上就是温柔蜜蜂为你收集整理的项目使用druid连接池的全部内容，希望文章能够帮你解决项目使用druid连接池所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。

本图文内容来源于网友提供，作为学习参考使用，或来自网络收集整理，版权属于原作者所有。

本文分类：Maven
浏览次数：69 次浏览
发布日期：2023-12-26 06:00:19
本文链接：https://www.kaopuke.com/article/k-p-k_13_u_23_ocfw_14_jc1.html

项目使用druid连接池

概述

最后

评论列表共有 0 条评论

发表评论取消回复

项目使用druid连接池

概述

最后

相关文章

评论列表共有 0 条评论

发表评论 取消回复

发表评论取消回复