Spring Boot集成MyBatis

一、配置application.yml

mybatis:
  mapper-locations: classpath:mapper/*.xml  # 表示resources/mapper目录下的所有xml文件

二、创建Mapper.java和Mapper.xml

Mapper.java与Mapper.xml成对创建

// EmployeeMapper.java
// ...省略包名与导入

public interface EmployeeMapper {
    List<Employee> findAll();
}

<!-- EmployeeMapper.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.dao.EmployeeMapper">
    <resultMap id = "Employee" type = "com.example.pojo.Employee">
        <result property = "id" column = "id"/>
        <result property = "name" column = "name"/>
        <result property = "role" column = "role"/>
    </resultMap>
    <select id = "findAll" resultMap = "Employee">
        SELECT * FROM payroll
    </select>
</mapper>

三、添加MapperScan注解

@SpringBootApplication
@MapperScan("com.example.payroll.dao") // 括号内替换为*Mapper.java对应的包
public class PayrollApplication {
	public static void main(String[] args) {
		SpringApplication.run(PayrollApplication.class, args);
	}
}