springboot整合mybatis（使用druid线程池）

pom引入

        <mybatis.version>2.3.2</mybatis.version>
		<druid.version>1.1.23</druid.version>

   <!--数据库-->

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

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>


     <!--   数据库连接池     -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>${druid.version}</version>
        </dependency>

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>${druid.version}</version>
        </dependency>

设置 DruidConfig 配置

spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource #引入druid数据源
    #数据源基本信息，也可放在druid下
    url: jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
    username: root
    password: 123456
    driver-class-name: com.mysql.cj.jdbc.Driver

    druid:
      #SpringBoot因为默认是hikari数据源所以对于其他数据源默认是不注入这些属性的，需要手动配置
      #druid数据源专有配置
      initialSize: 5
      minIdle: 5
      maxActive: 20
      maxWait: 600000
      # 主要配置以上几个即可
      timeBetweenEvictionRunsMillis: 600000
      minEvictableIdleTimeMillis: 300000
      validationQuery: SELECT 1 FROM DUAL
      testWhileIdle: true
      testOnBorrow: false
      testOnReturn: false
      poolPreparedStatements: true

配置 mybatis信息 和日志信息打印

# 方法一：只有一个路径
mybatis:
  # 搜索指定包别名
  typeAliasesPackage: com.liu.activiti.pojo.*
  mapper-locations: classpath:mapper/*.xml
  configuration:
    log-impl: org.apache.ibatis.logging.slf4j.Slf4jImpl
# 方法二：有多个路径
# mybatis:
#  mapper-locations: classpath:mapper/*.xml,classpath:mapper/user/*.xml

logging:
  level:
    com.liu.activiti.mapper: DEBUG
    org.apache.ibatis: DEBUG
    java.sql: DEBUG
    javax.sql: DEBUG

springboot配置 扫描器

@MapperScan("com.liu.activiti.mapper")