SpringBoot 集成 Druid 连接池

傷城~ 2021-07-04 17:29 487阅读 0赞

# 配置文件 pom.xml #

<dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.1.10</version>
    </dependency>

# DruidConfig.java #

package com.zwd.house.config;
    
    import com.alibaba.druid.filter.Filter;
    import com.alibaba.druid.filter.stat.StatFilter;
    import com.alibaba.druid.pool.DruidDataSource;
    import com.alibaba.druid.support.http.StatViewServlet;
    import com.google.common.collect.Lists;
    import org.springframework.boot.context.properties.ConfigurationProperties;
    import org.springframework.boot.web.servlet.ServletRegistrationBean;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    
    @Configuration
    public class DruidConfig { 
    
        @ConfigurationProperties(prefix = "spring.druid")
        @Bean(initMethod = "init",destroyMethod = "close")
        public DruidDataSource dataSource(){ 
            DruidDataSource dataSource = new DruidDataSource();
            dataSource.setProxyFilters(Lists.newArrayList(statFilter()));
            return dataSource;
        }
    
        @Bean
        public Filter statFilter(){ 
            StatFilter filter = new StatFilter();
            filter.setSlowSqlMillis(1);
            // druid 配置输出慢SQL日志记录
            // 例如Console上输出的：slow sql 34 millis. SELECT id,name,email,phone FROM user[]
            filter.setLogSlowSql(true);
            filter.setMergeSql(true);
            return filter;
        }
    
        @Bean
        public ServletRegistrationBean servletRegistrationBean(){ 
            return new ServletRegistrationBean(new StatViewServlet(),"/druid/*");
        }
    }

# application.yml #

spring:
      druid:
        driverClassName: com.mysql.jdbc.Driver
        url: jdbc:mysql://localhost:3306/houses?characterEncoding=UTF-8
        username: root
        password: root
    #最大连接数
        maxActive: 30
    #最小连接数
        minIdle: 5
    #获取连接的最大等待时间
        maxWait: 10000
    #解决 mysql 8小时的问题，
        validationQuery: SELECT 'x'
    #空闲连接检查时间间隔
        timeBetweenEvictionRunsMillis: 60000
    #空闲连接最小空闲时间
        minEvictableIdleTimeMillis: 300000

# 测试 #

启动项目后，可以在浏览器输入 http://localhost:8080/druid 进入druid 为我们提供的数据监控页面。