springboot2.x 数据库连接池学习

spring:
  datasource:
   username: root
   password: root
   url: jdbc:mysql://localhost:3306/lfy-practice?useUnicode=true&characterEncoding=utf-8&useSSL=true&zeroDateTimeBehavior=convertToNull&serverTimezone=Asia/Shanghai
   driver-class-name: com.mysql.jdbc.Driver
   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=500000

@Configuration
public class DruidConfig {
	//prefix = "spring.datasource"对应yml中的路径
	@ConfigurationProperties(prefix = "spring.datasource")
	@Bean
	public DataSource deuid() {
		return new DruidDataSource();
	}
	
	//配置Druid的监控
	//配置一个管理后台的server
	@Bean
	public ServletRegistrationBean<?> statViewServlet() {
		ServletRegistrationBean<StatViewServlet> seBean = new ServletRegistrationBean<>(new StatViewServlet(),"/druid/*");
		Map<String,String> initParmas = new HashMap<>();
		initParmas.put("loginUsername", "admin");
		initParmas.put("loginPassword", "1234");
		initParmas.put("allow", "");//允许谁访问，不写就是允许所有
		initParmas.put("deny", "");//拒绝谁访问，不写就是允许所有
		seBean.setInitParameters(initParmas);
		return seBean;
		
	}
	//配置一个web监控filter
	@Bean
	public FilterRegistrationBean<?> webStatFiter(){
		FilterRegistrationBean<Filter> filBean = new FilterRegistrationBean<>();
		filBean.setFilter(new WebStatFilter());
		
		Map<String,String> initParmas = new HashMap<>();
		initParmas.put("exclusions","*.js,*.css,/druid/*");
		
		filBean.setInitParameters(initParmas);
		
		filBean.setUrlPatterns(Arrays.asList("/*"));
		return filBean;
		
	}

}