spring 集成 druid

2025-02-08 技术教程

先在gradle里配置相应的包

compilegroup:'com.alibaba',name:'druid',version:'1.0.27'

在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><init-param><param-name>sessionStatMaxCount</param-name><param-value>1000</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><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>

spring上下文配置增加,

<beanid="propertyConfigurer"class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"><propertyname="locations"><list><value>/WEB-INF/config/dbconfig.properties</value></list></property></bean>

datasource配置注释掉的是原来的配置信息

<?xmlversion="1.0"encoding="UTF-8"?><beansxmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans.xsd"><beanid="dataSource"class="com.alibaba.druid.pool.DruidDataSource"init-method="init"destroy-method="close"><propertyname="url"value="${url}"/><propertyname="username"value="${username}"/><propertyname="password"value="${password}"/><propertyname="driverClassName"value="${driverClassName}"/><propertyname="filters"value="${filters}"/><propertyname="maxActive"value="${maxActive}"/><propertyname="initialSize"value="${initialSize}"/><propertyname="maxWait"value="${maxWait}"/><propertyname="minIdle"value="${minIdle}"/><propertyname="timeBetweenEvictionRunsMillis"value="${timeBetweenEvictionRunsMillis}"/><propertyname="minEvictableIdleTimeMillis"value="${minEvictableIdleTimeMillis}"/><propertyname="validationQuery"value="${validationQuery}"/><propertyname="testWhileIdle"value="${testWhileIdle}"/><propertyname="testOnBorrow"value="${testOnBorrow}"/><propertyname="testOnReturn"value="${testOnReturn}"/><propertyname="maxOpenPreparedStatements"value="${maxOpenPreparedStatements}"/><propertyname="removeAbandoned"value="${removeAbandoned}"/><propertyname="removeAbandonedTimeout"value="${removeAbandonedTimeout}"/><propertyname="logAbandoned"value="${logAbandoned}"/><propertyname="connectionProperties"value="config.decrypt=true;config.decrypt.key=${publickey};druid.stat.slowSqlMillis=5000"/></bean></beans>

dbconfig.properties, 这里使用了密码加密.加密方法也很简单

https://github.com/alibaba/druid/wiki/%E4%BD%BF%E7%94%A8ConfigFilter

url:jdbc:mysql://localhost:3306/myweibo?serverTimezone=UTCdriverClassName:com.mysql.cj.jdbc.Driverusername:rootpassword:UwJJ7yszUBhKKPdIv6ihaO+USCeNhJ+u2l4lagPLYWvAWkQN9dvAt4hxo1j6MI5h7qb6n0eaDxOLZI/kGm9kYw==filters:config,stat,wallmaxActive:20initialSize:1maxWait:60000minIdle:10maxIdle:15timeBetweenEvictionRunsMillis:60000minEvictableIdleTimeMillis:300000validationQuery:SELECT'x'testWhileIdle:truetestOnBorrow:falsetestOnReturn:falsemaxOpenPreparedStatements:20removeAbandoned:trueremoveAbandonedTimeout:1800logAbandoned:truepublickey:MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBALFxQkYrqVkDjqqedvqBe0RSOkewypkss5JX3kdoodmy38llEQaDhJfLwCfQEjAZtQy7xmJ6okmyf9MmepZ77rcCAwEAAQ==

代码方面不用变

最终效果

drui配置相关的问题https://github.com/alibaba/druid/wiki/%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98