一文秒懂springboot druid 配置

Druid是阿里巴巴开发的一个连接池，他提供了一个高效、功能强大、可扩展性好的数据库连接池，区别于hikari。如果选择高性能可以选hikari，如果要功能多就选，druid。

首先pom引入依赖

				?

									<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>

然后yml配置参数

				?

									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

然后在项目config下配置参数

				?

									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;

									    }

									}