SpringBoot 集成数据库连接池Druid

时间：2023-03-09 23:34:10
SpringBoot 集成数据库连接池Druid

1. maven依赖

<dependency>

　　<groupId>com.alibaba</groupId>

   <artifactId>druid</artifactId>

   <version>1.1.20</version>
</dependency>

2. application.properties配置文件

# 数据源类型
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

spring.datasource.url=jdbc:mysql://127.0.0.0:3306/user?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&useSSL=false

spring.datasource.username=admin

spring.datasource.password=123456

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
# 最小连接池数量

spring.datasource.minIdle=100
# 最大连接池数量
spring.datasource.maxActive=200
# 初始化时建立物理连接的个数
spring.datasource.initialSize=100

spring.datasource.timeBetweenEvictionRunsMillis=3000

spring.datasource.minEvictableIdleTimeMillis=300000
# 用来检查连接是否有效的sql
spring.datasource.validationQuery=SELECT 'ZTM' FROM DUAL

spring.datasource.validationQueryTimeout=10000

spring.datasource.testWhileIdle=true

spring.datasource.testOnBorrow=false

spring.datasource.testOnReturn=false
# 获取连接最大等待时间
spring.datasource.maxWait=60000
# 是否缓存preparedStatement
spring.datasource.poolPreparedStatements=true

spring.datasource.maxPoolPreparedStatementPerConnectionSize=200

spring.datasource.maxPoolSize=200

spring.datasource.minPoolSize=100

spring.datasource.borrowConnectionTimeout=60

3. Druid监控

# 监控配置 启用相应的内置Filter，多个以逗号分隔

spring.datasource.druid.filters=stat, wall

# 配置StatFilter

spring.datasource.druid.filter.stat.db-type=mysql

spring.datasource.druid.filter.stat.log-slow-sql=true

spring.datasource.druid.filter.stat.slow-sql-millis=1000

# 配置WallFilter

spring.datasource.druid.filter.wall.enabled=true

4. DruidConfig配置

package com.ruhuanxingyun.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;

/**

 * @description: 阿里数据源配置

 * @author: ruphie

 * @date: Create in 2020/1/11 14:31

 * @company: ruhuanxingyun

 */

@Configuration

public class DruidConfig {

    @ConfigurationProperties(prefix = "spring.datasource")

    @Bean

    public DataSource dataSource() {

        return new DruidDataSource();

    }

    @Bean

    public ServletRegistrationBean servletRegistrationBean() {

        ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");

        Map<String, String> map = new HashMap<>();

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

        map.put("loginPassword", "123456");

        servletRegistrationBean.setInitParameters(map);

        return servletRegistrationBean;

    }

    @Bean

    public FilterRegistrationBean filterRegistrationBean() {

        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());

        Map<String, String> map = new HashMap<>();

        map.put("exclusions", "*.js,*.css,/druid/*");

        filterRegistrationBean.setInitParameters(map);

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

        return filterRegistrationBean;

    }

}

可参考：Druid官网地址

　　     Druid问题：https://github.com/alibaba/druid/wiki/%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98

　　    配置详解：https://blog.****.net/hj7jay/article/details/51686418

　　   连接池比较：https://blog.****.net/fysuccess/article/details/66972554

相关文章