spring boot 整合mybatis

• 依赖

        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>

• 配置文件

spring:
  datasource:
    username: root
    password: 1234
    url: jdbc:mysql://rm-2zera2uls08j7v07z:3306/springboot?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
    driver-class-name: com.mysql.jdbc.Driver

mybatis:
  mapper-locations: classpath:mapping/*Mapper.xml
#  type-aliases-package: org.example.model
  configuration:
    map-underscore-to-camel-case: true

• mapper

@Repository
public interface OrderMapper {
    Order findByOrderNo(String orderNo);
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.example.mapper.OrderMapper">

    <select id="findByOrderNo" resultType="org.example.model.Order">
        select * from order where order_no = #{orderNo};
    </select>
</mapper>

• 包扫描

@MapperScan("org.example.mapper")