Druid集成实战

Druid介绍：https://www.iteye.com/magazines/90#111

1. 引用依赖

        <!-- mybatis -->
		<mybatis.spring.boot.starter.version>2.0.0</mybatis.spring.boot.starter.version>
		<mybatis.spring.version>2.0.0</mybatis.spring.version>
		<mybatis.version>3.5.0</mybatis.version>
		<druid.version>1.1.14</druid.version>

 <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
        </dependency>
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
        </dependency>
        
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
        </dependency>
        

2.配置DataSource type

spring:datasource: 
    # 使用druid数据库连接池
    type: com.alibaba.druid.pool.DruidDataSource  

 datasource:
    # 使用druid数据库连接池
    type: MountainDruidDataSource

3. yml中配置属性

4. 注入bean

@Value("${spring.datasource.type}")
private Class<? extends DataSource> datasourceType;

如下图druid源码，会自动注入属性

 

 

 

 

 

5.配置druid 过滤规则

  第一种方式

package microservice.qssj.config;

import javax.servlet.annotation.WebFilter;
import javax.servlet.annotation.WebInitParam;
import com.alibaba.druid.support.http.WebStatFilter;
/**
 * 配置druid过滤规则
 * @author Administrator
 *
 */
@WebFilter(filterName="druidWebStatFilter",urlPatterns="/*",
initParams={
    @WebInitParam(name="exclusions",value="*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*")// 忽略资源
})
public class DruidStatFilter extends WebStatFilter {

}

第二种方式 

 @Bean
 public FilterRegistrationBean<WebStatFilter> filterRegistrationBean() {
        FilterRegistrationBean<WebStatFilter> filterRegistrationBean = new     
        FilterRegistrationBean<>();
        filterRegistrationBean.setFilter(new WebStatFilter());
        filterRegistrationBean.addUrlPatterns("/*");
        filterRegistrationBean.addInitParameter("exclusions", 
          "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");

        return filterRegistrationBean;
    }

6. 配置druid访问

 

 

7.访问druid

 /druid/login.html 

内容详解，待续。。。