SpringBoot十：整合Mybatis

pom文件引入以下依赖

<dependencies>
	<!--mybatis起步依赖 -->
	<dependency>
		<groupId>org.mybatis.spring.boot</groupId>
		<artifactId>mybatis-spring-boot-starter</artifactId>
		<version>1.1.1</version>
	</dependency>
</dependencies>

创建实体Bean

public class User {
    // 主键
    private Long id;
    // 用户名
    private String username;
    // 密码
    private String password;
    // 姓名
    private String name;
  
    //此处省略getter和setter方法 .. ..
    
}

编写Mapper

public interface UserMapper {

	List<User> getUserList();

}

注意：@Mapper标记该类是一个mybatis的mapper接口，可以被spring boot自动扫描到spring上下文中

配置Mapper映射文件

在src\main\resources\mapper路径下加入UserMapper.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="cn.com.javakf.mybatis.mapper.UserMapper">

	<select id="getUserList"
		resultType="cn.com.javakf.mybatis.pojo.User">
		select * from user
	</select>

</mapper>

在application.properties中添加mybatis的信息

#spring集成Mybatis环境
#pojo别名扫描包
mybatis.type-aliases-package=cn.com.javakf.pojo
#加载Mybatis映射文件
mybatis.mapper-locations=classpath:mapper/*Mapper.xml

编写测试Controller

@RestController
public class UserController {

	@Autowired
	private UserMapper userMapper;

	// 整合mybatis
	// http://localhost:8080/queryUser
	@RequestMapping("/queryUser")
	public List<User> queryUser() {
		List<User> users = userMapper.getUserList();
		return users;
	}

}

Mapper接口和映射文件在同一目录下

此种情况下需要在maven的配置文件中添加如下信息：

<build>
	<resources>
		<resource>
			<directory>src/main/java</directory>
			<includes>
				<include>**/*.properties</include>
				<include>**/*.xml</include>
			</includes>
			<filtering>false</filtering>
		</resource>
		<resource>
			<directory>src/main/resources</directory>
			<includes>
				<include>**/*.*</include>
			</includes>
			<filtering>false</filtering>
		</resource>
	</resources>
</build>

并且无需在application.properties中配置mapper路径，只需要在引导类上添加@MapperScan注解即可

@SpringBootApplication
//包扫描器
@MapperScan("cn.com.javakf.mybatis.mapper")
public class Application {
	public static void main(String[] args) {
		SpringApplication.run(Application.class, args);
	}
}

https://blog.csdn.net/u012702547/article/details/88643598

代码托管：springboot_mybatis