springboot使用druid连接池和mybatis

忘是亡心i 2022-12-02 00:43 175阅读 0赞

### 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