spring boot整合druid数据源

druid源代码仓库地址：https://github.com/alibaba/druid

一、通过配置类进行设置

1、pom.xml中添加dependency

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>${druid-version}</version>
</dependency>

2、配置数据库连接池(MySQL8)
在application.yml文件中配置

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/xxx
    username: xxx
    password: xxx
    driver-class-name: com.mysql.cj.jdbc.Driver

3、配置_StatFilter

    @ConfigurationProperties(prefix = "spring.datasource")   //获取配置文件中的参数
    @Bean
    public DataSource dataSource() throws SQLException {
        DruidDataSource druidDataSource = new DruidDataSource();

        //Druid内置提供一个StatFilter，用于统计监控信息
        //也可以在yml文件中配置
        druidDataSource.setFilters("stat");

        return druidDataSource;
    }

4、配置_StatViewServlet
根据配置中的url-pattern来访问内置监控页面，例如：
http://localhost:8080/druid/index.html

    @Bean
    public ServletRegistrationBean statViewServlet() {
        StatViewServlet statViewServlet = new StatViewServlet();

        // 内置监控页面的首页是/druid/index.html
        ServletRegistrationBean<StatViewServlet> servletServletRegistrationBean = new ServletRegistrationBean<>(statViewServlet,"/druid/*");

        //配置监控页面访问密码
        servletServletRegistrationBean.addInitParameter("loginUsername","druid");
        servletServletRegistrationBean.addInitParameter("loginPassword","druid");

        return servletServletRegistrationBean;
    }

5、配置WebStatFilter

    @Bean
    public FilterRegistrationBean webStatFilter() {

        WebStatFilter webStatFilter = new WebStatFilter();
        FilterRegistrationBean<WebStatFilter> webStatFilterFilterRegistrationBean = new FilterRegistrationBean<>(webStatFilter);

        webStatFilterFilterRegistrationBean.setUrlPatterns(Arrays.asList("/*"));
        //排除 *.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/* 相关文件
        webStatFilterFilterRegistrationBean.addInitParameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");

        return webStatFilterFilterRegistrationBean;
    }

6、配置 wallfilter
在第三步配置_StatFilter中，添加wall

    @ConfigurationProperties(prefix = "spring.datasource")   //获取配置文件中的参数
    @Bean
    public DataSource dataSource() throws SQLException {
        DruidDataSource druidDataSource = new DruidDataSource();

        //Druid内置提供一个StatFilter，用于统计监控信息
        //也可以在yml文件中配置
        druidDataSource.setFilters("stat,wall");
        druidDataSource.setMaxActive(12);

        return druidDataSource;
    }

所有代码如下：

MyDataSourceConfig类

package com.greenery.admin.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.sql.SQLException;
import java.util.Arrays;

@Configuration
public class MyDataSourceConfig {

    @ConfigurationProperties(prefix = "spring.datasource")   //获取配置文件中的参数
    @Bean
    public DataSource dataSource() throws SQLException {
        DruidDataSource druidDataSource = new DruidDataSource();

        //Druid内置提供一个StatFilter，用于统计监控信息
        //也可以在yml文件中配置
        druidDataSource.setFilters("stat,wall");
        druidDataSource.setMaxActive(12);

        return druidDataSource;
    }

    /**
     * 配置druid的内置监控
     *
     * Druid内置提供了一个StatViewServlet用于展示Druid的统计信息。
     *
     * 这个StatViewServlet的用途包括：
     *      提供监控信息展示的html页面
     *      提供监控信息的JSON API
     */
    @Bean
    public ServletRegistrationBean statViewServlet() {
        StatViewServlet statViewServlet = new StatViewServlet();

        // 内置监控页面的首页是/druid/index.html
        ServletRegistrationBean<StatViewServlet> servletServletRegistrationBean = new ServletRegistrationBean<>(statViewServlet,"/druid/*");

        //配置监控页面访问密码
        servletServletRegistrationBean.addInitParameter("loginUsername","druid");
        servletServletRegistrationBean.addInitParameter("loginPassword","druid@2023");

        return servletServletRegistrationBean;
    }

    /**
     * WebStatFilter用于采集web-jdbc关联监控的数据
     */
    @Bean
    public FilterRegistrationBean webStatFilter() {

        WebStatFilter webStatFilter = new WebStatFilter();
        FilterRegistrationBean<WebStatFilter> webStatFilterFilterRegistrationBean = new FilterRegistrationBean<>(webStatFilter);

        webStatFilterFilterRegistrationBean.setUrlPatterns(Arrays.asList("/*"));
        //排除 *.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/* 相关文件
        webStatFilterFilterRegistrationBean.addInitParameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");

        return webStatFilterFilterRegistrationBean;
    }

}

TestController类

@Controller
public class TestController {
    @Autowired
    JdbcTemplate jdbcTemplate;

    @ResponseBody
    @GetMapping("/sql")
    public String mySql() {

        Long aLong = jdbcTemplate.queryForObject("select count(*) from g_user", long.class);
        return aLong.toString();
    }
}

二、通过yml文件配置

1、pom.xml中加上dependency

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>${druid-version}</version>
</dependency>

2、application.yml文件中进行配置

spring:
  # 处理druid-1.1.22及以上版本无法监控SpringBean问题
  aop:
    auto: false

  datasource:
    url: jdbc:mysql://localhost:3306/xxx
    username: xxx
    password: xxx
    driver-class-name: com.mysql.cj.jdbc.Driver


    druid:
      filters: stat,wall,slf4j                #底层开启功能：sql监控，防火墙，日志
      aop-patterns: com.greenery.admin.*      #监控SpringBean
      stat-view-servlet:                      #配置监控页
        enabled: true
        login-username: xxx
        login-password: xxx
        reset-enable: false
      web-stat-filter:                        #监控web
        enabled: true
        url-pattern: /*
        exclusions: '*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*'

      # 详细配置
      filter:
        stat:
          log-slow-sql: true
          slow-sql-millis: 1000
        wall:
          enabled: true
          config:
            drop-table-allow: false