本文共 2799 字，大约阅读时间需要 9 分钟。

整合Druid

引入依赖

               
    
     com.alibaba
                
    
     druid
                
    
     1.1.9
            
   

配置

spring:  datasource:    username: root    password: 123456    url: jdbc:mysql://localhost:3306/chapter05?useUnicode=true&characterEncoding=UTF-8    driver-class-name: com.mysql.jdbc.Driver    type: com.alibaba.druid.pool.DruidDataSource    #   数据源其他配置    initialSize: 5    minIdle: 5    maxActive: 20    maxWait: 60000    timeBetweenEvictionRunsMillis: 60000    minEvictableIdleTimeMillis: 300000    validationQuery: SELECT 1 FROM DUAL    testWhileIdle: true    testOnBorrow: false    testOnReturn: false    poolPreparedStatements: true    #   配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙    filters: stat,wall,log4j    maxPoolPreparedStatementPerConnectionSize: 20    useGlobalDataSourceStat: true    connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500

编写配置类

package pers.zhang.config;import com.alibaba.druid.pool.DruidDataSource;import com.alibaba.druid.support.http.StatViewServlet;import com.alibaba.druid.support.http.WebStatFilter;import org.springframework.boot.context.properties.ConfigurationProperties;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;import javax.sql.DataSource;import java.util.Arrays;import java.util.HashMap;import java.util.Map;/** * @author zhang * @date 2019/12/13 - 22:59 */@Configurationpublic class DruidConfig {
       @Bean//注册数据源    @ConfigurationProperties(prefix = "spring.datasource")//绑定配置    public DataSource druid(){
           return new DruidDataSource();    }    //配置Druid的监控    //1、配置一个管理后台的Servlet    @Bean    public ServletRegistrationBean statViewServlet(){
           ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");        Map
   
     initParams = new HashMap<>();        initParams.put("loginUsername","admin");//用户名        initParams.put("loginPassword","123456");//密码        initParams.put("allow","");//默认就是允许所有访问        initParams.put("deny","192.168.15.21");//不允许访问的        bean.setInitParameters(initParams);        return bean;    }    //2、配置一个web监控的filter    @Bean    public FilterRegistrationBean webStatFilter(){
           FilterRegistrationBean bean = new FilterRegistrationBean();        bean.setFilter(new WebStatFilter());        Map
    
      initParams = new HashMap<>();        initParams.put("exclusions","*.js,*.css,/druid/*");//不拦截静态文件        bean.setInitParameters(initParams);        bean.setUrlPatterns(Arrays.asList("/*"));//拦截所有        return  bean;    }}
    
   

访问http://localhost:8080/druid

根据自己设置的账号密码登录：

可以监控数据源的各种记录：

转载地址：http://uzpqb.baihongyu.com/