SpringBoot 2.1.1.RELEASE 集成Druid

短命女 2022-04-05 09:50 246阅读 0赞

SpringBoot 2.1.1.RELEASE 集成Druid  
详情：  
[http://www.qchcloud.cn/system/article/show/68][http_www.qchcloud.cn_system_article_show_68]  
配置依赖：

<dependency>
       <groupId>mysql</groupId>
       <artifactId>mysql-connector-java</artifactId>
    </dependency>
    
    <dependency>
       <groupId>com.alibaba</groupId>
       <artifactId>druid</artifactId>
       <version>1.1.4</version>
    </dependency>

配置applicaton.properties

spring.datasource.driverClassName = com.mysql.cj.jdbc.Driver
    spring.datasource.url = jdbc:mysql://localhost:3306/iot?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
    spring.datasource.username = root
    spring.datasource.password = 1234
    
    ### log4j配置
    logging.config=classpath:log4j2.xml
    ###  数据源类别
    spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
    ### 初始化大小，最小，最大
    spring.datasource.initialSize=5
    spring.datasource.minIdle=5
    spring.datasource.maxActive=20
    ### 配置获取连接等待超时的时间，单位是毫秒
    spring.datasource.maxWait=60000
    ### 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
    spring.datasource.timeBetweenEvictionRunsMillis=60000
    ### 配置一个连接在池中最小生存的时间，单位是毫秒
    spring.datasource.minEvictableIdleTimeMillis=300000
    spring.datasource.validationQuery=SELECT 1 FROM DUAL
    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
    配置监控：

@Configuration
    public class DruidConfiguration {
    
            @Bean
            public ServletRegistrationBean druidStatViewServle(){
                //ServletRegistrationBean提供类的进行注册.
                ServletRegistrationBean servletRegistrationBean
                        = new ServletRegistrationBean(new StatViewServlet(),"/druid/*");
                //添加初始化参数：initParams
                //白名单：
                servletRegistrationBean.addInitParameter("allow","127.0.0.1");
                //IP黑名单 (存在共同时，deny优先于allow)
                // 如果满足deny的话提示:Sorry, you are not permitted to view this page.
                servletRegistrationBean.addInitParameter("deny","192.168.1.7");
                //登录查看信息的账号和密码.
                servletRegistrationBean.addInitParameter("loginUsername","admin");
                servletRegistrationBean.addInitParameter("loginPassword","123456");
                //是否能够重置数据.
                servletRegistrationBean.addInitParameter("resetEnable","false");
                return servletRegistrationBean;
            }
    
            @Bean
            public FilterRegistrationBean druidStatFilter(){
                FilterRegistrationBean filterRegistrationBean
                        = new FilterRegistrationBean(new WebStatFilter());
                //添加过滤规则.
                filterRegistrationBean.addUrlPatterns("/*");
                //添加不需要忽略的格式信息.
                filterRegistrationBean.addInitParameter("exclusions",
                        "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
                return filterRegistrationBean;
            }
    }

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3llYmljaGFv_size_16_color_FFFFFF_t_70]

[http_www.qchcloud.cn_system_article_show_68]: http://www.qchcloud.cn/system/article/show/68
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3llYmljaGFv_size_16_color_FFFFFF_t_70]: /images/20220405/1c44922836814318a6142ffc8b0281da.png