springboot整合mybatis-starter

pom.xml增加

<!-- 数据库 -->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>1.3.2</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.19</version>
</dependency>

propreties :

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

mybatis.type-aliases-package=com.test.pojo.order
mybatis.mapperLocations=classpath:mappers/*.xml
mybatis.configuration.map-underscore-to-camel-case=true

启动类 application :

Application.java

@SpringBootApplication

dao层mapper :

OrderMapper.java

import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface OrderMapper {

    public OrderEntity getOne(String orderId);

}

resource/mappers文件夹 :

OrderMapper.xml

<?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="com.test.order.mapper.OrderMapper">

    <select id="getOne" resultType="com.test.pojo.order.OrderEntity">
        select * from t_order where order_id = #{orderId,jdbcType=INTEGER}
    </select>

</mapper>

架构截图 :