一文秒懂springboot druid 配置

<dependency>

           <groupId>log4j</groupId>

           <artifactId>log4j</artifactId>

           <version> 1.2 . 17 </version>

       </dependency>

      <dependency>

           <groupId>com.alibaba</groupId>

           <artifactId>druid</artifactId>

           <version> 1.2 . 6 </version>

       </dependency>

server:

   port: 8888

spring:

   datasource:

     username: root

     password: root

     url: jdbc:mysql: //localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC

     driver- class -name: com.mysql.cj.jdbc.Driver

     type: com.alibaba.druid.pool.DruidDataSource

     initialSize: 10

     minIdle: 1

     maxActive: 10

     maxWait: 10000

     timeBetweenEvictionRunsMillis: 6000

     minEvictableIdleTimeMillis: 300000

     testWhileIdle: true

     testOnBorrow: true

     testOnReturn: true

     poolPreparedStatements: true

     maxPoolPreparedStatementPerConnectionSize: 20

     validationQuery: select 1

#    stat 监控统计,wall 防止sql注入,log4j   （yml 要配置，不然会报错）  日志统计

     filters: stat,wall,log4j

import java.util.HashMap;

@Configuration

public class DruidConfig implements WebMvcConfigurer {

     @Bean

     @ConfigurationProperties (prefix = "spring.datasource" )

     public DataSource druidDataSource(){

         return new DruidDataSource();

     }

     //后台监控

     @Bean

     public ServletRegistrationBean statViewServlet(){

         ServletRegistrationBean<StatViewServlet> statViewServlet = new ServletRegistrationBean<>( new StatViewServlet(), "/druid/*" );

         //配置后台登录用户名密码

         HashMap<String, String> objectObjectHashMap = new HashMap<>();

         //用户名参数密码不能改变，系统配置

         objectObjectHashMap.put( "loginUsername" , "admin" );

         objectObjectHashMap.put( "loginPassword" , "admin" );

         //允许谁可以访问  为空时所有人可以访问 例如：objectObjectHashMap.put("allow","localhost"); 代表只能自己访问

         objectObjectHashMap.put( "allow" , "" );

         //禁止谁访问 objectObjectHashMap.put("name","192.168.0.1");

         statViewServlet.setInitParameters(objectObjectHashMap);

         return statViewServlet;

     }

}