<!--引入druid数据源-->

<!-- https://mvnrepository.com/artifact/com.alibaba/druid -->

<dependency>

<groupId>com.alibaba</groupId>

<artifactId>druid</artifactId>

<version>1.1.10</version>

</dependency>

@Configuration

public class DruidConfig {

      //prefix = "spring.datasource:" 配置文件属性名称

    @ConfigurationProperties(prefix = "spring.datasource")

    @Bean

    public DataSource druid(){

        return  new DruidDataSource();

    }

    //配置Druid监控

    //1，配置管理后台的servlet

    @Bean

    public ServletRegistrationBean statViewServlet(){

        //StatViewServlet 把我们的servlet和要截获的url传进去,url必须写"/druid/*"

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

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

        //loginUsername，loginPassword不可写错，否则无法登陆

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

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

        initParams.put("allow","");//默认允许所有

        initParams.put("deny","192.168.0.114");

        bean.setInitParameters(initParams);

        return  bean;

    }

    //2,配置一个web监控的filter

    @Bean

    public FilterRegistrationBean  webStatFilter(){

        FilterRegistrationBean bean = new FilterRegistrationBean();

        bean.setFilter(new WebStatFilter());

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

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

        bean.setInitParameters(initParams);

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

        return  bean;

     }
}

spring:

  datasource:

    username: root

    password: 123456

    url: jdbc:mysql://192.168.0.113/jdbc

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

    type: com.alibaba.druid.pool.DruidDataSource

#    schema:

#       - classpath:department.sql

#   数据源其他配置

    initialSize: 5

    minIdle: 5

    maxActive: 20

    maxWait: 60000

    timeBetweenEvictionRunsMillis: 60000

    minEvictableIdleTimeMillis: 300000

    validationQuery: SELECT 1 FROM DUAL

    testWhileIdle: true

    testOnBorrow: false

    testOnReturn: false

    poolPreparedStatements: true

    #   配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙

    filters: stat,wall,log4j

    maxPoolPreparedStatementPerConnectionSize: 20

    useGlobalDataSourceStat: true

    connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500