Springboot集成Druid数据库连接池

1、在【pom.xml】添加依赖

---

<!--druid-->
<dependency>
   <groupId>com.alibaba</groupId>
   <artifactId>druid</artifactId>
   <version>1.1.6</version>
</dependency>
<!--log4j-->
<dependency>
   <groupId>log4j</groupId>
   <artifactId>log4j</artifactId>
   <version>1.2.17</version>
</dependency>

---

2、在application.yml文件添加配置项

---

spring:
  mvc:
    servlet:
      load-on-startup: 1  #项目启动时加载
  datasource:   #数据库连接
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/springtest?useSSL=false&serverTimezone=UTC&zeroDateTimeBehavior=CONVERT_TO_NULL
    username: root
    password: root
    type: com.alibaba.druid.pool.DruidDataSource
    #   Druid数据源配置
    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

3、创建Druid配置类

---

package com.it.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 cpm
 */
@Configuration
public class DruidConfig {
   /**
    * @ConfigurationProperties 加载application.yaml中的Druid配置
    * @Bean 交给Spring管理
    */
   @ConfigurationProperties(prefix = "spring.datasource")
   @Bean
   public DataSource druid() {
      return new DruidDataSource();
   }

   /**
    * 1、配置Druid的监控
    * 1、1配置一个管理后台的Servlet
    * @Bean 交给Spring管理
    */
   @Bean
   public ServletRegistrationBean statViewServlet() {
      ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
      Map<String, String> initParams = new HashMap<>();
      /**
       * 设置账号
       */
      initParams.put("loginUsername", "admin");
      /**
       * 设置密码
       */
      initParams.put("loginPassword", "admin");
      /**
       * 默认就是允许所有访问
       */
      initParams.put("allow", "");
      bean.setInitParameters(initParams);
      return bean;
   }

   /**
    * 1、2配置一个web监控的filter
    * @Bean 交给Spring管理
    */
   @Bean
   public FilterRegistrationBean webStatFilter() {
      FilterRegistrationBean bean = new FilterRegistrationBean();
      bean.setFilter(new WebStatFilter());
      Map<String, String> initParams = new HashMap<>();
      initParams.put("exclusions", "*.js,*.css,/druid/*");

      bean.setInitParameters(initParams);

      bean.setUrlPatterns(Arrays.asList("/*"));

      return bean;
   }
}

---

4、测试

在浏览器输入访问地址：http://localhost:8080/druid/

输入刚才设置账号密码

页面显示