springboot整合druid连接池的步骤

使用springboot默认的连接池

导入springboot data-jdbc依赖

    <dependency>
      <groupid>org.springframework.boot</groupid>
      <artifactid>spring-boot-starter-data-jdbc</artifactid>
    </dependency>

配置文件配置连接池

spring:
 datasource:
  username: root
  password: 5201314
  url: jdbc:mysql:///jqmb?servertimezone=utc
  driver-class-name: com.mysql.cj.jdbc.driver

springboot默认的连接池

@autowired
   datasource datasource;
  @test
  void contextloads() {
    system.out.println(datasource.getclass());
    system.out.println("____________________________________");
  }

使用连接池druid

导入druid依赖

<dependency>
      <groupid>com.alibaba</groupid>
      <artifactid>druid</artifactid>
      <version>1.0.18</version>
    </dependency>

配置文件配置druid的属性

spring:
 datasource:
  username: root
  password: 5201314
  url: jdbc:mysql:///jqmb?servertimezone=utc
  driver-class-name: com.mysql.cj.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: stat,wall,log4j
  maxpoolpreparedstatementperconnectionsize: 20
  useglobaldatasourcestat: true
  connectionproperties: druid.stat.mergesql=true;druid.stat.slowsqlmillis=500

配置类中对druid属性进行绑定

@configuration
public class datasource_druid_configure {

  @configurationproperties(prefix = "spring.datasource")
  @bean
  public druiddatasource getdatasour(){
    return new druiddatasource();
  }

配置druid的监控后台

//配置druid的监控
  //1、配置一个管理后台的servlet
  @bean
  public servletregistrationbean statviewservlet(){
    servletregistrationbean bean = new servletregistrationbean(new statviewservlet(), "/druid/*");
    map<string,string> initparams = new hashmap<>();

    initparams.put("loginusername","admin");//登录用户名
    initparams.put("loginpassword","123456");//登录密码
    initparams.put("allow","");//默认就是允许所有访问
    initparams.put("deny","192.168.15.21");//拒绝访问

    bean.setinitparameters(initparams);
    return bean;
  }


  //2、配置一个web监控的filter
  @bean
  public filterregistrationbean webstatfilter(){
    filterregistrationbean bean = new filterregistrationbean();
    bean.setfilter(new webstatfilter());
    map<string,string> initparams = new hashmap<>();
    initparams.put("exclusions","*.js,*.css,/druid/*");
    bean.setinitparameters(initparams);
    bean.seturlpatterns(arrays.aslist("/*"));

    return bean;
  }

访问http://localhost:8090/druid/login.html

如果sql监控失效需要导入log4j 依赖

  <dependency>
      <groupid>log4j</groupid>
      <artifactid>log4j</artifactid>
      <version>1.2.17</version>
    </dependency>

以上就是springboot整合druid连接池的步骤的详细内容，更多关于springboot整合druid连接池的资料请关注其它相关文章！