springboot使用druid连接池和mybatis

maven依赖

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.15</version>
        </dependency>

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.21</version>
        </dependency>

        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>${mybatis.version}</version>
        </dependency>

数据库连接

spring:
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/test?serverTimezone=UTC&characterEncoding=utf8&useUnicode=true&useSSL=false
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver

druid配置

druid:
  initial-size: 5
  min-idle: 1
  max-active: 20
  query-timeout: 6000
  remove-abandoned: false
  async-init: true
  time-between-connect-error-millis: 3000

  log-abandoned: false
  transaction-query-timeout: 6000
  remove-abandoned-timeout: 1800
  filters: wall,stat
  connection-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=10000
  stat-view-servlet:
    login-username: bda
    login-password: bda
    url-pattern: /druid/*
    reset-enable: false
  web-stat-filter:
    url-pattern: /*
    exclusions: "*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*"
  connection-error-retry-attempts: 3
  break-after-acquire-failure: false
  #检查连接正常的sql
  validation-query: select 1 from dual
  #配置多久检测一次空闲连接（可以选择是否尽早关闭连接，看压力在server还是数据库端）
  time-between-eviction-runs-millis: 60000
  #数据库连接最小生存时间
  min-evictable-idle-time-millis: 300000

mybatis配置

mybatis:
  mapper-locations: classpath:mapper/*.xml
  type-aliases-package: com.yarm.po