SpringBoot之整合Mybatis

Springboot整合mybatis

第一步、导包

<!-- https://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter -->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.1.3</version>
</dependency>

第二步、编写实体类

package com.saxon.springbootdate.Pojo;

public class Teacher {
    private int id;
    private String name;

    public int getId () {
        return id;
    }

    public void setId (int id) {
        this.id = id;
    }

    public String getName () {
        return name;
    }

    public void setName (String name) {
        this.name = name;
    }

    @Override
    public String toString () {
        return "Teacher{" +
                "id=" + id +
                ", name='" + name + '\'' +
                '}';
    }
}

第三步、编写Dao

package com.saxon.springbootdate.Dao;

import com.saxon.springbootdate.Pojo.Teacher;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface TeacherMapper {
    List<Teacher> getTeacher ();
}

这了有一个比较重要的注解就是**@Mapper**

标志着这个类是mybatis的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.saxon.springbootdate.Dao.TeacherMapper">
    <select id="getTeacher" resultType="com.saxon.springbootdate.Pojo.Teacher">
    select * from mybatis.teacher
  </select>
</mapper>

第五步、使用

@RestController
public class DemoController {
    @Autowired
    TeacherMapper teacherMapper;

    @RequestMapping ("/getTeacher")
    public List<Teacher> getTeacher () {
        return teacherMapper.getTeacher ();
    }
}