SpringBoot学习（五）—— springboot快速整合Druid

喜欢ヅ旅行 2023-06-16 10:47 14阅读 0赞

[SpringBoot学习（一）—— idea 快速搭建 Spring boot 框架][SpringBoot_ idea _ Spring boot]

[SpringBoot学习（二）—— springboot快速整合spring security组件][SpringBoot_ springboot_spring security]

[SpringBoot学习（三）—— springboot快速整合swagger文档][SpringBoot_ springboot_swagger]

[SpringBoot学习（四）—— springboot快速整合Mybatis组件][SpringBoot_ springboot_Mybatis]

[SpringBoot学习（五）—— springboot快速整合Druid][SpringBoot_ springboot_Druid]

[SpringBoot学习（六）—— springboot快速整合RabbitMQ][SpringBoot_ springboot_RabbitMQ]

[SpringBoot学习（七）—— springboot快速整合Redis][SpringBoot_ springboot_Redis]

# Druid连接池 #

### 简介 ###

由阿里巴巴开源的druid连接池是目前综合实力最突出的数据库连接池，而且还提供了监控日志功能，能够分析SQL执行情况。

### 引入druid连接池 ###

pom.xml中加入

<dependency>
    	<groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.1.21</version>
    </dependency>

application.properties中加入

# druid
    spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
    
    # 连接池初始化大小，最小，最大
    spring.datasource.initialSize=10
    spring.datasource.minIdle=10
    spring.datasource.maxActive=30
    # 连接等待超时时间
    spring.datasource.maxWait=60000
    # 多久检测需要关闭的空闲连接
    spring.datasource.timeBetweenEvictionRunsMillis=60000
    # 一个连接在池中最小生存的时间
    spring.datasource.minEvictableIdleTimeMillis=300000
    # 校验SQL，Oracle配置 spring.datasource.validationQuery=SELECT 1 FROM DUAL，如果不配validationQuery项，则下面三项配置无用
    spring.datasource.validationQuery=SELECT 'x'
    spring.datasource.testWhileIdle=true
    spring.datasource.testOnBorrow=false
    spring.datasource.testOnReturn=false
    # 打开PSCache，并且指定每个连接上PSCache的大小
    spring.datasource.poolPreparedStatements=true
    spring.datasource.maxPoolPreparedStatementPerConnectionSize=20
    # 配置监控统计拦截的filters，去掉后监控界面sql无法统计，wall用于防火墙
    spring.datasource.filters=stat,wall,log4j
    # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
    spring.datasource.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
    # 合并多个DruidDataSource的监控数据
    spring.datasource.useGlobalDataSourceStat=true

注：之前已经配置好了mysql，mybatis，这里没有重复写了

### 代码实战 ###

新增了一个DruidFilter.java来配置内置的监控

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzc1MDIxMg_size_16_color_FFFFFF_t_70]  
DruidFilter.java

package com.example.config;
    
    import com.alibaba.druid.support.http.StatViewServlet;
    import com.alibaba.druid.support.http.WebStatFilter;
    import org.springframework.boot.web.servlet.FilterRegistrationBean;
    import org.springframework.boot.web.servlet.ServletRegistrationBean;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    
    @Configuration
    public class DruidFilter { 
    
        @Bean
        public ServletRegistrationBean druidStatView() { 
            //指定路径进入内置监控页面
            ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
    
            //IP白名单：
            servletRegistrationBean.addInitParameter("allow", "127.0.0.1");
            //IP黑名单
            servletRegistrationBean.addInitParameter("deny", "192.168.1.73");
            //登录查看信息的账号密码.
            //servletRegistrationBean.addInitParameter("loginUsername", "admin");
            //servletRegistrationBean.addInitParameter("loginPassword", "123456");
            //是否能够重置数据.
            servletRegistrationBean.addInitParameter("resetEnable", "true");
            return servletRegistrationBean;
        }
    
        @Bean
        public FilterRegistrationBean druidWebStatFilter() { 
            FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
            //添加过滤规则.
            filterRegistrationBean.addUrlPatterns("/*");
            //添加不需要忽略的格式信息.
            filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
            return filterRegistrationBean;
        }
    
    }

注：我之前就已经配置好了spring security，如果在和其他教程一样配置druid的账号密码，会导致输入druid的账号密码后无法跳转进入内置监控页面，我知道有很多方法可以避免，但那都需要额外增加代码来判断绕过，既然spring security已经有了账号权限，何必额外非得给druid单独增加一套账号权限，把 `/druid/*` 路径配置在spring security中，公用已有的账号权限不更好嘛。所以我没有单独配置。

还有这只是常用的配置，如若需要进一步了解详细的配置

[内置监控页面配置详情][Link 1]，[Web关联配置详情][Link 1]

效果图如下

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzc1MDIxMg_size_16_color_FFFFFF_t_70 1]  
恩恩，还自带阿里云的广告，果然是阿里的开源产品

[SpringBoot_ idea _ Spring boot]: https://blog.csdn.net/weixin_43750212/article/details/103045425
[SpringBoot_ springboot_spring security]: https://blog.csdn.net/weixin_43750212/article/details/103088150
[SpringBoot_ springboot_swagger]: https://blog.csdn.net/weixin_43750212/article/details/103176744
[SpringBoot_ springboot_Mybatis]: https://blog.csdn.net/weixin_43750212/article/details/103235162
[SpringBoot_ springboot_Druid]: https://blog.csdn.net/weixin_43750212/article/details/103251195
[SpringBoot_ springboot_RabbitMQ]: https://blog.csdn.net/weixin_43750212/article/details/103313483
[SpringBoot_ springboot_Redis]: https://blog.csdn.net/weixin_43750212/article/details/103374195
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzc1MDIxMg_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191126101445831.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzc1MDIxMg==,size_16,color_FFFFFF,t_70
[Link 1]: https://github.com/alibaba/druid/wiki/%E9%85%8D%E7%BD%AE_StatViewServlet%E9%85%8D%E7%BD%AE
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzc1MDIxMg_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20191126101503118.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzc1MDIxMg==,size_16,color_FFFFFF,t_70