package com.yqx.springboot.day060.config;
import com.alibaba.druid.filter.Filter;
import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;
import com.alibaba.druid.wall.WallConfig;
import com.alibaba.druid.wall.WallFilter;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
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 java.sql.SQLException;
import java.util.*;
/**
* @author yangqiaoxin
* @date 2021/01/01
*/
@Configuration
public class DruidConfig {
private Logger logger = LoggerFactory.getLogger(DruidConfig.class);
@ConfigurationProperties(prefix = "spring.datasource")
@Bean
public DruidDataSource druidDataSource() {
DruidDataSource dataSource = new DruidDataSource();
try {
// 启动程序时,在连接池中初始化多少个连接(10-50已足够)
dataSource.setInitialSize(50);
// 回收空闲连接时,将保证至少有 minIdle 个连接(与 initialSize 相同)
dataSource.setMinIdle(50);
// 连接池中最多支持多少个活动会话
dataSource.setMaxActive(10000);
// 程序向连接池中请求连接时,超过 maxWait 的值后,认为本次请求失败,即连接池,没有可用连接,单位毫秒,设置 -1 时表示无限等待(建议值为100)
dataSource.setMaxWait(100);
Druid 数据源 Spring Boot 配置
最新推荐文章于 2024-05-03 16:12:22 发布