「Spring Boot 系列」08. Spring Boot整合MyBatis

<!--引入相对应的starter-->
 <dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.2.2</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <scope>runtime</scope>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-test</artifactId>
    <scope>test</scope>
</dependency>

#配置相关信息
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver  #com.mysql.jdbc.Driver该驱动类过时
    url: jdbc:mysql://localhost:3306/test?serverTimezone=UTC
    username: root
    password: root

public class Person {
    private Integer id;
    private String name;
    private String city;
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getCity() {
        return city;
    }
    public void setCity(String city) {
        this.city = city;
    }
    @Override
    public String toString() {
        return "Person{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", city='" + city + '\'' +
                '}';
    }
}

@Mapper  //SQL映射添加@Mapper注解方便被容器识别
public interface PersonDao {
    @Select("select * from person where id = #{id}")
    public Person getById(Integer id);
}

@Mapper
public interface PersonMapper {
    public List<Person> findAll();
}

<?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.ityun.springbootstudy.mapper.PersonMapper">
    <select id="findAll" resultType="person">
        select * from person
    </select>
</mapper>

#MyBatis配置
mybatis:
  mapper-locations: classpath:mapper/*Mapper.xml  #mapper映射文件路径
  type-aliases-package: com.ityun.springbootstudy.domain #定义实体类的别名

@SpringBootTest
class SpringbootStudyApplicationTests {
    @Autowired
    private PersonDao personDao;
    @Autowired
    private PersonMapper personMapper;
    @Test
    public void findTest() {
        System.out.println(personDao.getById(1));
    }
    @Test
    public void findAllTest(){
        List<Person> list = personMapper.findAll();
        System.out.println(list);
    }
}