springboot整合Druid

 <!-- druid数据库连接池依赖-->

    
 <dependency>
    
     <groupId>com.alibaba</groupId>
    
     <artifactId>druid-spring-boot-starter</artifactId>
    
     <version>1.2.11</version>
    
 </dependency>
    
    
    
    
    AI写代码

 spring:

    
   datasource:
    
     url: jdbc:mysql://127.0.0.1:3306/team?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&nullCatalogMeansCurrent=true
    
     username: root
    
     password: 123456
    
     driver-class-name: com.mysql.cj.jdbc.Driver
    
     # 以下是Durid配置
    
     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
    
     # 打开PSCache，并且指定每个连接上PSCache的大小
    
     poolPreparedStatements: true
    
     maxPoolPreparedStatementPerConnectionSize: 20
    
     # 配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
    
     filters: stat,wall,log4j
    
     # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
    
     connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
    
    
    
    
    AI写代码

 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.HashMap;
    
 import java.util.Map;
    
  
    
 /** * @Description
    
  * @Author Corey
    
  * @Date 2022/8/8 11:12
    
  */
    
 @Configuration
    
 public class DruidConfig {
    
  
    
     // 将DataSource对象的实现类变为了DruidDataSource对象
    
     @Bean
    
     @ConfigurationProperties(prefix = "spring.datasource")
    
     public DataSource druidDataSource() {
    
     return new DruidDataSource();
    
     }
    
  
    
     //因为Springboot内置了servlet容器，所以没有web.xml，相当于servlet的web.xml。替代方法就是将ServletRegistrationBean注册进去
    
     //加入后台监控
    
     @Bean
    
     public ServletRegistrationBean<StatViewServlet> statViewServlet() {
    
     ServletRegistrationBean<StatViewServlet> bean =
    
             new ServletRegistrationBean<>(new StatViewServlet(), "/druid/*");
    
     Map<String, String> initParas = new HashMap<>();
    
     initParas.put("loginUsername", "admin");//它这个账户密码是固定的
    
     initParas.put("loginPassword", "123456");
    
     // IP白名单 (没有配置或者为空，则允许所有访问)
    
     initParas.put("allow","127.0.0.1,10.141.134.9");
    
     // ip黑名单，拒绝谁访问 deny和allow同时存在优先deny initParas.put("deny","")
    
     initParas.put("resetEnable", "false");//禁用HTML页面的Reset按钮
    
     bean.setInitParameters(initParas);
    
     return bean;
    
     }
    
  
    
     // 配置过滤器，Servlet按上面的方式注册Filter也只能这样
    
     @Bean
    
     public FilterRegistrationBean<WebStatFilter> webStatFilter(){
    
     FilterRegistrationBean<WebStatFilter> bean = new FilterRegistrationBean<>();
    
     //可以设置也可以获取,设置一个阿里巴巴的过滤器
    
     bean.setFilter(new WebStatFilter());
    
     bean.addUrlPatterns("/*");
    
     //可以过滤和排除哪些东西
    
     Map<String,String> initParams = new HashMap<>();
    
     //把不需要监控的过滤掉,这些不进行统计
    
     initParams.put("exclusions","*.js,*.css,/druid/*");
    
     bean.setInitParameters(initParams);
    
     return bean;
    
     }
    
 }
    
    
    
    
    AI写代码

 java -cp /Users/gavin/Documents/maven-repo/com/alibaba/druid/1.1.21/druid-

    
 1.1.21.jar com.alibaba.druid.filter.config.ConfigTools 你的密码
    
    
    
    
    AI写代码

 druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000;config.decrypt=true;con

    
 fig.decrypt.key=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAM9l5I7/YAFtLPr2Ep1G70ovzMX8Ncd9jcuKUWaWEiJ/3SLu90v/K0IPxqYGDYaI+QmulYgecmyQ+XJIdpimtqsCAwEAAQ==
    
    
    
    
    AI写代码

 #通过connectProperties属性来打开mergeSql功能；慢SQL记录，这⾥里里⽅方publickey

    
 connectionProperties:
    
 druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000;config.decrypt=true;con
    
 fig.decrypt.key=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAM9l5I7/YAFtLPr2Ep1G70ovzMX8Nc
    
 d9jcuKUWaWEiJ/3SLu90v/K0IPxqYGDYaI+QmulYgecmyQ+XJIdpimtqsCAwEAAQ
    
    
    
    
    AI写代码