SpringBoot整合druid

 

SpringBoot整合druid

1.导入jar包

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jdbc</artifactId>
    </dependency>

    <!-- druid数据库连接池 -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.1.10</version>
    </dependency>

    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
    <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>1.2.17</version>
    </dependency>

    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <scope>runtime</scope>
    </dependency>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>
</dependencies>

2.配置文件

修改配置文件，缩进用空格区分。

spring:
    datasource:
        driver-class-name: com.mysql.jdbc.Driver
        url: jdbc:mysql://ip地址/数据库
        name: ***
        password: ***
        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
        maxPoolPreparedStatementPerConnectionSize: 20
        filters: stat,wall,log4j
        connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500

3.扩展配置

由于以上配置的属性默认是不会有效，所以在新建一个配置包，在包下建立配置类DruidConfig，并配置后台管理的servlet以及filter，设置参数等等。

@Configuration
public class DruidConfig {

    // 将配置的所有属性都映射出来
    @ConfigurationProperties(prefix = "spring.datasource")
    @Bean
    public DataSource druid(){
        return new DruidDataSource();
    }

    // 配置Druid的监控
    // 1.配置一个管理后台的servlet
    @Bean
    public ServletRegistrationBean servletRegistrationBean(){
        ServletRegistrationBean<StatViewServlet> bean = new ServletRegistrationBean<>(new StatViewServlet(), "/druid/*");
        Map map = new HashMap();
        map.put("loginUsername","admin");
        map.put("loginPassword","123");
        map.put("allow","");// 默认所有访问
        map.put("deny",""); // 不能访问者

        bean.setInitParameters(map);
        return bean;
    }

    // 配置web监控的filter
    public FilterRegistrationBean wegStatFilter(){
        FilterRegistrationBean bean = new FilterRegistrationBean();
        Map map = new HashMap();

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

        bean.setInitParameters(map);
        bean.setUrlPatterns(Arrays.asList("/*"));
        return bean;
    }
}

4.启动项目

启动项目以后访问地址：http://localhost:8080/druid,出现登录界面以后输入刚刚设置的用户名和密码，也就是admin和123，进入druid管理界面。