SpringBoot使用druid

配置application.yml文件

spring:

datasource:

username: root

password: 123456

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

url: jdbc:mysql://127.0.0.1:3306/test1?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true

type: com.alibaba.druid.pool.DruidDataSource

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

initialization-mode:  always

@Configuration

public class myDruid {

@ConfigurationProperties(prefix = "spring.datasource")

[@Bean](https://my.oschina.net/bean)

public DataSource dataSource(){

   return new DruidDataSource();

}

//配置Druid监控

[@Bean](https://my.oschina.net/bean)

public ServletRegistrationBean statViewServlet(){

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

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

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

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


  servletRegistrationBean.setInitParameters(map);

  return  servletRegistrationBean;

}

[@Bean](https://my.oschina.net/bean)
public FilterRegistrationBean webStatFilter(){

    FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean();

    filterRegistrationBean.setFilter(new WebStatFilter());


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

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

    filterRegistrationBean.setInitParameters(map);

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

    return  filterRegistrationBean;
}

}