spring boot整合druid以及druid监控

一时失言乱红尘 2022-06-12 13:25 267阅读 0赞

Druid是[Java][]语言中最好的[数据库][Link 1]连接池(我个人知识范围内)，并且能够提供强大的监控和扩展功能。

下面来说明如何在 [ spring][spring] Boot 中配置使用druid

**1:添加druid和spring boot的依赖**

<dependency>
    		   <groupId>com.alibaba</groupId>
    		   <artifactId>druid-spring-boot-starter</artifactId>
    		   <version>1.1.1</version>
    		</dependency>

2:如果spring-boot-starter-parent你用的版本还是1.3.2那现在要升级了,在后面运行项目的时候就报错了.找不到  
java.lang.NoClassDefFoundError: org/springframework/boot/web/servlet/ServletRegistrationBean

改为1.5.2吧.比较新

**2:在application.properties中添加最基本的数据源配置文件**

#数据库配置文件
    spring.datasource.type=com.alibaba.druid.pool.DruidDataSource 
    spring.datasource.url=jdbc:mysql://127.0.0.1:3306/xyy_v2?useUnicode=true&characterEncoding=utf8&allowMultiQueries=true
    spring.datasource.username=admin
    spring.datasource.password=admin
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver
    #连接池配置信息
    spring.datasource.initial-size=5  
    spring.datasource.min-idle=5  
    spring.datasource.max-active=20  
    spring.datasource.max-wait=60000  
    spring.datasource.time-between-eviction-runs-millis=60000  
    spring.datasource.min-evictable-idle-time-millis=300000  
    spring.datasource.validation-query=SELECT 1 FROM DUAL  
    spring.datasource.test-while-idle=true  
    spring.datasource.test-on-borrow=false  
    spring.datasource.test-on-return=false  
    spring.datasource.pool-prepared-statements=true  
    spring.datasource.max-pool-prepared-statement-per-connection-size=20  
    spring.datasource.filters=stat 
    spring.datasource.connection-properties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000

**3-1:spring boot整合druid的方式也和其它一样,可以分为javabean和配置文件properties的方式**

我们先来说说bean的方式吧,直接上代码!

a>配置监控拦截器

package com.xyy.util;
    
    import javax.servlet.annotation.WebFilter;
    import javax.servlet.annotation.WebInitParam;
    
    import com.alibaba.druid.support.http.WebStatFilter;
    
    /**
     * druid监控拦截去
     * @ClassName: DruidStatFilter 
     * @author wangqinghua
     * @date 2017年7月24日 上午10:53:40
     */
    @WebFilter(filterName="druidWebStatFilter",
    urlPatterns="/*",
    initParams={
        @WebInitParam(name="exclusions",value="*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*")// 忽略资源
    })
    public class DruidStatFilter extends WebStatFilter {
    
    }

b>druid监控视图配置

package com.xyy.util;
    
    import javax.servlet.annotation.WebInitParam;
    import javax.servlet.annotation.WebServlet;
    
    import com.alibaba.druid.support.http.StatViewServlet;
    
    /**
     * druid监控视图配置
     * @ClassName: DruidStatViewServlet 
     * @author wangqinghua
     * @date 2017年7月24日 上午10:54:27
     */
    @WebServlet(urlPatterns = "/druid/*", initParams={
        @WebInitParam(name="allow",value="192.168.16.110,127.0.0.1"),// IP白名单 (没有配置或者为空，则允许所有访问)
        @WebInitParam(name="deny",value="192.168.16.111"),// IP黑名单 (存在共同时，deny优先于allow)
        @WebInitParam(name="loginUsername",value="shanhy"),// 用户名
        @WebInitParam(name="loginPassword",value="shanhypwd"),// 密码
        @WebInitParam(name="resetEnable",value="false")// 禁用HTML页面上的“Reset All”功能
    })
    public class DruidStatViewServlet extends StatViewServlet {
    	private static final long serialVersionUID = 6588499385893299545L;
    
    }

**3-2:配置文件配置的方式application.properties(具体配置视个人而定)**

#druid WebStatFilter监控配置
    spring.datasource.druid.web-stat-filter.enabled= true
    spring.datasource.druid.web-stat-filter.url-pattern=/*
    spring.datasource.druid.web-stat-filter.exclusions=*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*
    spring.datasource.druid.web-stat-filter.session-stat-enable=true
    spring.datasource.druid.web-stat-filter.session-stat-max-count=10
    spring.datasource.druid.web-stat-filter.principal-session-name=
    spring.datasource.druid.web-stat-filter.principal-cookie-name=
    spring.datasource.druid.web-stat-filter.profile-enable=
    #druid StatViewServlet监控配置
    spring.datasource.druid.stat-view-servlet.enabled= true
    spring.datasource.druid.stat-view-servlet.url-pattern= /druid/*
    spring.datasource.druid.stat-view-servlet.reset-enable=false
    spring.datasource.druid.stat-view-servlet.login-username=admin
    spring.datasource.druid.stat-view-servlet.login-password=admin
    spring.datasource.druid.stat-view-servlet.allow=192.168.1.110,127.0.0.1
    spring.datasource.druid.stat-view-servlet.deny=192.168.16.111
    spring.datasource.druid.aop-patterns=com.xyy.service

上述配置具体含义我就不描述了,英文水平可以或者之前有使用过的,应该很清楚 ![害羞][shy.gif],我就不装逼了,免得有人打我!

4:点击main主入口,运行成功.浏览器输入:http://localhost:8080/druid,帐号:admin 密码:admin,就会看到如下效果了

![Center][]

好了,大功告成!来点掌声!![抓狂][crazy.gif]

[Java]: http://lib.csdn.net/base/java
[Link 1]: http://lib.csdn.net/base/mysql
[spring]: http://lib.csdn.net/base/javaee
[shy.gif]: /images/20220612/697d54730df34b1e8229299afc8c7bde.png
[Center]: /images/20220612/c0067607bf4d4e2b989d9b5f22e8406f.png
[crazy.gif]: /images/20220612/b227b42d1eb44b61ae9ed2f329772531.png