SpringBoot入门之集成Druid的方法示例

<dependency>

       <groupid>com.alibaba</groupid>

       <artifactid>druid-spring-boot-starter</artifactid>

       <version> 1.1 . 10 </version>

     </dependency>

spring.mvc.view.prefix=/view/

spring.mvc.view.suffix=.jsp

mybatis.type-aliases- package =com.example.model

mybatis.config-location=classpath:mybatis/mybatis-config.xml

mybatis.mapper-locations=classpath:mybatis/mapper/*.xml

#spring.datasource.driverclassname = com.mysql.cj.jdbc.driver

#spring.datasource.url = jdbc:mysql: //localhost:3306/mybatis

spring.datasource.url =jdbc:mysql: //127.0.0.1:3306/mybatis?useunicode=true&characterencoding=utf-8&servertimezone=utc

spring.datasource.username = root

spring.datasource.password = 123456

#spring.datasource.driver- class -name=com.mysql.cj.jdbc.driver

spring.datasource.type=com.alibaba.druid.pool.druiddatasource

spring.datasource.druid.max-active= 20

spring.datasource.druid.initial-size= 1

spring.datasource.druid.max-wait= 60000

spring.datasource.druid.pool-prepared-statements= true

spring.datasource.druid.max-pool-prepared-statement-per-connection-size= 20

spring.datasource.druid.connection-properties=druid.stat.mergesql= true ;druid.stat.slowsqlmillis= 5000

spring.datasource.druid.min-idle= 1

spring.datasource.druid.time-between-eviction-runs-millis= 60000

spring.datasource.druid.min-evictable-idle-time-millis= 300000

spring.datasource.druid.validation-query=select 1 from dual

spring.datasource.druid.test- while -idle= true

spring.datasource.druid.test-on-borrow= true

spring.datasource.druid.test-on- return = true

package com.example.demo;

import org.springframework.boot.web.servlet.filterregistrationbean;

import org.springframework.boot.web.servlet.servletregistrationbean;

import org.springframework.context.annotation.*;

import com.alibaba.druid.support.http.statviewservlet;

import com.alibaba.druid.support.http.webstatfilter;

@configuration

public class druidconfiguration {

   @bean

   public servletregistrationbean statviewservlet(){

     //创建servlet注册实体

     servletregistrationbean servletregistrationbean = new servletregistrationbean( new statviewservlet(), "/druid/*" );

     //设置ip白名单

     servletregistrationbean.addinitparameter( "allow" , "127.0.0.1" );

     //设置ip黑名单，如果allow与deny共同存在时,deny优先于allow

     servletregistrationbean.addinitparameter( "deny" , "192.168.0.19" );

     //设置控制台管理用户

     servletregistrationbean.addinitparameter( "loginusername" , "druid" );

     servletregistrationbean.addinitparameter( "loginpassword" , "123456" );

     //是否可以重置数据

     servletregistrationbean.addinitparameter( "resetenable" , "false" );

     return servletregistrationbean;

   }

   @bean

   public filterregistrationbean statfilter(){

     //创建过滤器

     filterregistrationbean filterregistrationbean = new filterregistrationbean( new webstatfilter());

     //设置过滤器过滤路径

     filterregistrationbean.addurlpatterns( "/*" );

     //忽略过滤的形式

     filterregistrationbean.addinitparameter( "exclusions" , "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*" );

     return filterregistrationbean;

   }

}