datasource:

  username: root

  password: root

  url: jdbc:mysql://localhost:3306/early_warning?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8

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

  type: com.alibaba.druid.pool.DruidDataSource

  druid:

    initial-size: 8

    min-idle: 1

    max-active: 20

    max-wait: 60000

    time-between-eviction-runsMillis: 60000

    min-evictable-idle-timeMillis: 300000

    validation-query: select 'x' FROM DUAL

    test-while-idle: true

    test-on-borrow: false

    test-on-return: false

    pool-prepared-statements: true

    max-open-prepared-statements: 20

    max-pool-prepared-statement-per-connection-size: 20

    filters: stat

    connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000

    use-global-data-source-stat: true

package com.dc.config;

import com.alibaba.druid.pool.DruidDataSource;

import com.alibaba.druid.support.http.StatViewServlet;

import org.springframework.boot.context.properties.ConfigurationProperties;

import org.springframework.boot.web.servlet.ServletRegistrationBean;

import org.springframework.context.annotation.Bean;

import org.springframework.stereotype.Component;

import javax.sql.DataSource;

import java.util.HashMap;

import java.util.Map;

/**

 * @author ：llf

 * @date ：Created in 2019-11-20 16:00

 * @description：Druid配置

 * @version: v1.0

 */

@Component

public class DruidConfig {

    /***

     *

     * @return DruidDataSource

     */

    @Bean

    @ConfigurationProperties(prefix = "spring.datasource")

    public DataSource druidDataSource(){

        return  new DruidDataSource();

    }

    /***

     *

     * @return ServletRegistrationBean

     */

    @Bean

    public ServletRegistrationBean servletRegistrationBean(){

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

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

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

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

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

        map.put("deny","192.168.14.26");

        bean.setInitParameters(map);

        return bean;

    }

//    @Bean

//    public FilterRegistrationBean filterRegistrationBean(){

//        FilterRegistrationBean bean=new FilterRegistrationBean();

//        bean.setFilter(new WebStatFilter());

//        bean.addUrlPatterns("/*");

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

//        map.put("exclusions","*.png，*.js");

//        bean.setInitParameters(map);

//        return bean;

//    }

}