springboot整合mybatisstarter

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&＃61;com.mysql.cj.jdbc.Driver
spring.datasource.url&＃61;jdbc:mysql://localhost:3306/mydb?characterEncoding&＃61;utf8&useSSL&＃61;false&serverTimezone&＃61;UTC&rewriteBatchedStatements&＃61;true
spring.datasource.username&＃61;root
spring.datasource.password&＃61;adminmybatis.type-aliases-package&＃61;com.test.pojo.order
mybatis.mapperLocations&＃61;classpath:mappers/*.xml
mybatis.configuration.map-underscore-to-camel-case&＃61;true


启动类 application :

Application.java

&＃64;SpringBootApplication


dao层mapper :

OrderMapper.java

import org.apache.ibatis.annotations.Mapper;&＃64;Mapper
public interface OrderMapper {public OrderEntity getOne(String orderId);}


resource/mappers文件夹 :

OrderMapper.xml

<?xml version&＃61;"1.0" encoding&＃61;"UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace&＃61;"com.test.order.mapper.OrderMapper"><select id&＃61;"getOne" resultType&＃61;"com.test.pojo.order.OrderEntity">select * from t_order where order_id &＃61; #{orderId,jdbcType&＃61;INTEGER}</select></mapper>


架构截图 :