Druid 数据源

Druid能够提供强大的监控和扩展功能。隶属于阿里巴巴旗下的连接池
我们使用druid和SpingBoot结合

首先我们引入druid 的maven依赖

<!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.0</version>
</dependency>

yml配置如下

spring:
  datasource:
    username: root
    password: root
    url: jdbc:mysql://192.168.13.131:3306/springboot01
    driver-class-name: com.mysql.jdbc.Driver
	type: com.alibaba.druid.pool.DruidDataSource

我们仍然可以使用druid其他的yml配置

#   数据源其他配置
    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

然后由于很多属性值druid无法映射，我们可以使用yml属性绑定的方式

@ConfigurationProperties(prefix = "spring.datasource")
   @Bean
   public DataSource druid(){
       return new DruidDataSource();
   }

然后我们需要配置druid的后台管理servlet以及监控的filter

//配置管理后台的servlet
   @Bean
   public ServletRegistrationBean statViewServlet(){
       ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(), "/druid/*");
       Map<String,String> map = new HashMap<>();
       map.put("loginUsername","admin");
       map.put("loginPassword","admin");
       map.put("allow","");//默认允许所有访问
       map.put("deny","192.168.13.132");//禁止192.168.13.132访问
       bean.setInitParameters(map);//初始化参数
       return bean;
   }
   //配置一个web监控的filter
   @Bean
   public FilterRegistrationBean webStatFilter(){
       FilterRegistrationBean<Filter> bean = new FilterRegistrationBean<>();
       bean.setFilter(new WebStatFilter());
       Map<String,String> map = new HashMap<>();
       map.put("exclusions","*.js,*.css,/druid/*"); //不拦截这些
       bean.setInitParameters(map); //初始化参数
       bean.setUrlPatterns(Arrays.asList("/*")); //表示拦截所有请求
       return bean;
   }

然后输入localhost/druid就可运行成功