SpringBoot配置Druid开启监控

1.导入Druid依赖

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

2.在application.properties中说明使用Druid

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
# mapper文件路径
mybatis.mapper-locations=classpath:mappers/*xml

3.创建Druid配置文件

username=admin
password=243718

druid.url=jdbc:mysql://127.0.0.1:3306/wei_disk?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
druid.username=root
druid.password=root
druid.driver-class-name=com.mysql.cj.jdbc.Driver
# 初始化时建立物理连接的个数。
druid.initial-size=1
# 最大连接池数量
druid.max-active=20
# 最小连接池数量
druid.min-idle=1
# 获取连接时最大等待时间，单位毫秒。
druid.max-wait=60000
# 是否缓存preparedStatement，也就是PSCache。
druid.pool-prepared-statements=false
druid.max-open-prepared-statements=20
# 用来检测连接是否有效的sql，要求是一个查询语句
druid.validation-query=select 1 from dual
# 检测连接是否有效的超时时间。
druid.validation-query-timeout=50000
# 申请连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能。
druid.test-on-borrow=false
# 归还连接时执行validationQuery检测连接是否有效，做了这个配置会降低性能。
druid.test-on-return=false
# 建议配置为true，不影响性能，并且保证安全性。
druid.test-while-idle=true
druid.time-between-eviction-runs-millis=60000
druid.min-evictable-idle-time-millis=300000
druid.remove-abandoned=true
druid.remove-abandoned-timeout=1800
druid.connection-properties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
druid.max-pool-prepared-statement-per-connection-size=20
druid.filters=stat,wall

3.创建DruidConfig配置类

import com.alibaba.druid.pool.DruidDataSource;
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;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.ClassPathResource;
import javax.sql.DataSource;
import java.io.IOException;
import java.io.InputStream;
import java.util.HashMap;
import java.util.Map;
import java.util.Properties;

@Configuration
public class DruidConfig {

    private final Properties druidConfig;

    public MyDruidConfig() {
        ClassPathResource classPathResource = new ClassPathResource("configs/druid.properties");
        druidConfig = new Properties();
        InputStream inputStream = null;
        try {
            inputStream = classPathResource.getInputStream();
            druidConfig.load(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            if (inputStream != null) {
                try {
                    inputStream.close();
                } catch (IOException e) {
                    e.printStackTrace();
                }
            }
        }
    }

    /**
     配置dataSource
     **/
    @Bean
    @Primary
    public DataSource dataSource() {
        DruidDataSource datasource = new DruidDataSource();
        // 读取druid配置文件
        datasource.configFromPropety(druidConfig);
        return datasource;
    }

    /**
     配置StatViewServlet
     **/
    @Bean
    public ServletRegistrationBean<StatViewServlet> druidServlet() {
        ServletRegistrationBean<StatViewServlet> servletRegistrationBean = new ServletRegistrationBean<>();
        servletRegistrationBean.setServlet(new StatViewServlet());
        servletRegistrationBean.addUrlMappings("/druid/*");
        Map<String, String> initParameters = new HashMap<>(2);
        initParameters.put("loginUsername", druidConfig.getProperty("username"));
        initParameters.put("loginPassword", druidConfig.getProperty("password"));
//        initParameters.put("allow", ""); // IP白名单 (没有配置或者为空，则允许所有访问)
        // initParameters.put("deny", "192.168.52.17"); // IP黑名单 (存在共同时，deny优先于allow)
        servletRegistrationBean.setInitParameters(initParameters);
        return servletRegistrationBean;
    }

    /**
     配置WebStatFilter
     **/
    @Bean
    public FilterRegistrationBean<WebStatFilter> druidWebStatViewFilter() {
        FilterRegistrationBean<WebStatFilter> registrationBean = new FilterRegistrationBean<>(new WebStatFilter());
        registrationBean.addInitParameter("urlPatterns", "/*");
        registrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*");
        return registrationBean;
    }