看了很多人寫的博客措伐，要么太復(fù)雜，要么沒(méi)有添加xml的方式担映，自己親自配置了一下废士，供各位參考
項(xiàng)目截圖
image
添加pom文件
<!-- 設(shè)置mybatis -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>6.0.4</version>
</dependency>
添加Mapper類
@Mapper
public interface UserMapper {
User findUserById(Integer id);
}
添加mapper.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.example.mapper.UserMapper">
<resultMap id = "result" type = "com.example.domain.User">
<result property = "id" column = "id"/>
<result property = "name" column = "name"/>
</resultMap>
<select id = "findUserById" resultMap = "result">
SELECT * FROM act_user where id = #{id};
</select>
</mapper>
在application.properties添加數(shù)據(jù)庫(kù)和mybatis配置
# mysql
spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
# mybatis
# 對(duì)應(yīng)實(shí)體類的包名
mybatis.typeAliasesPackage=com.example.domain
# mapper.xml文件所在位置，我放到了resources下面
mybatis.mapperLocations=classpath:**/mapper/*.xml
配置啟動(dòng)類蝇完，添加MapperScan注解
@SpringBootApplication
@MapperScan("com.example.mapper")
public class SpringBootDemoApplication {
public static void main(String[] args) {
SpringApplication.run(SpringBootDemoApplication.class, args);
}
}
添加日志輸出官硝，在logback-spring.xml中添加這一行即可
<logger name="com.example.mapper" level="DEBUG"></logger>
運(yùn)行效果
image
歡迎訪問(wèn)我的博客，一起進(jìn)步
