springboot快速搭建mybatis环境

springboot搭建mybatis环境

1、使用durid数据源（可选）

引入durid坐标

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

2、配置数据源

spring:
  datasource:
    username: root
    password: root
    url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
    driver-class-name: com.mysql.cj.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource

3、配mybatis配置信息位置

配文件

mybatis:
  config-location: classpath:mybatis/mybatis-config.xml
  mapper-locations: classpath:mybatis/mapper/*.xml

加注解

@MapperScan("com.aust.sjh.springboot_mybatis_redis.mapper")

4、写mapper、mpper.xml文件