springboot整合mybatis

整合包

org.mybatis.spring.boot mybatis-spring-boot-starter 2.1.1 创建一个新的springboot项目 选中web，jdbc，mysql驱动依赖  在pom.xml中导入依赖 org.mybatis.spring.boot mybatis-spring-boot-starter 2.1.1

配置数据源 连接数据库 建立对应的实体类

public class Student { private Integer id; private String name; private int age; public Student(){ } public Student(Integer id, String name, int age) { this.id = id; this.name = name; this.age = age; } 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 int getAge() { return age; } public void setAge(int age) { this.age = age; } @Override public String toString() { return "Student{" + "id=" + id + ", name='" + name + '\'' + ", age=" + age + '}'; } }

写一个mapper接口

//这个注解表示这是一个mybatis的mapper类 @Mapper @Repository //交给spring托管 public interface StudentMapper { public int addStudent(Student student); public int delStudent(Integer id); public int updStudent(Student student); public List<Student> selStudent(); public Student selStudentById(Integer id); }

在resources下对应的xml文件

在application.yaml中配置属性 classpath代表resources文件夹

#整合mybatis mybatis: type-aliases-package: com.briup.pojo mapper-locations: classpath:mybatis/mapper/*.xml

写Student.xml文件，写sql

<?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.briup.mapper.StudentMapper"> <insert id="addStudent" parameterType="Student" > insert into student(id,name,age) values (#{id},#{name},#{age}); </insert> <delete id="delStudent" parameterType="int"> delete from student where id =#{id}; </delete> <update id="updStudent" parameterType="Student"> update student set name=#{name},age=#{age} where id=#{id}; </update> <select id="selStudent" resultType="Student"> select * from student; </select> <select id="selStudentById" resultType="Student"> select * from student where id =#{id}; </select> </mapper>

写一个controller测试一下

@RestController public class StudentController { @Autowired private StudentMapper studentMapper; @GetMapping("/selStudent") public List<Student> selStudent(){ return studentMapper.selStudent(); } }

成功