1.环境信息

使用SpringBoot集成Mybatis有两种方式，本文使用IDEA搭建：

  • 1.Spring Initializr
  • 2.使用IDEA插件

环境信息： OS：Win10 Jdk：JavaSE 8 Ide：Idea Ultimate MySQL：8.0.16 MyBatis：3.5.2 Spring Boot：2.1.7.RELEASE

2.创建Web项目

Idea集成了Spring Initializr，新建项目：

  • 1.选择Spring Initializr，新建项目并填写基本信息
    SpringBoot 2.x 集成 Mybatis - 图1
  • 3.选择需要的工具
    选择Web、MySQL Driver和MyBatis Framework等必要依赖：

SpringBoot 2.x 集成 Mybatis - 图2

  • 4.确认完成，build.gradle如下：
  1. plugins {
  2.     id 'org.springframework.boot' version '2.1.7.RELEASE'
  3.     id 'java'
  4. }
  6. apply plugin: 'io.spring.dependency-management'
  8. group = 'com.wxx'
  9. version = '0.0.1-SNAPSHOT'
  10. sourceCompatibility = '1.8'
  12. configurations {
  13.     developmentOnly
  14.     runtimeClasspath {
  15.         extendsFrom developmentOnly
  16.     }
  17.     compileOnly {
  18.         extendsFrom annotationProcessor
  19.     }
  20. }
  22. repositories {
  23.     mavenCentral()
  24. }
  26. dependencies {
  27.     implementation 'org.springframework.boot:spring-boot-starter-web'
  28.     implementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter:2.1.0'
  29.     compileOnly 'org.projectlombok:lombok'
  30.     developmentOnly 'org.springframework.boot:spring-boot-devtools'
  31.     runtimeOnly 'mysql:mysql-connector-java'
  32.     annotationProcessor 'org.springframework.boot:spring-boot-configuration-processor'
  33.     annotationProcessor 'org.projectlombok:lombok'
  34.     testImplementation 'org.springframework.boot:spring-boot-starter-test'
  35. }

4.集成Mybatis

4.1 创建Domain

实体类有：Student、Score，与数据库表相对应；
Student:

  1. @Data
  2. @AllArgsConstructor
  3. @NoArgsConstructor
  4. @Builder
  5. public class Student {
  6.     private Integer id;
  7.     private String name;
  8.     private Integer age;
  9.     private String sex;
  10.     private String hobbies;
  11.     private String address;
  12. }

Score:

  1. @Data
  2. @Builder
  3. @AllArgsConstructor
  4. @NoArgsConstructor
  5. public class Score {
  6.     private Integer id;
  7.     private Integer studentId;
  8.     private String studentName;
  9.     private String subject;
  10.     private Integer subjectScore;
  11. }

StudentScore、StudentScores，是关联查询时使用的，并没有相对应的表；

StudentScore:

  1. @Data
  2. @AllArgsConstructor
  3. @NoArgsConstructor
  4. @Builder
  5. public class StudentScore {
  6.     private String name;
  7.     private Integer age;
  8.     private String sex;
  9.     private Score score;
  10. }

StudentScores:

  1. @Data
  2. @AllArgsConstructor
  3. @NoArgsConstructor
  4. @Builder
  5. public class StudentScores {
  6.     private String name;
  7.     private Integer age;
  8.     private String sex;
  9.     private List<Score> scoreList;
  10. }

注：@Data，@Builder，@AllArgsConstructor，@NoArgsConstructor为lombok的注解

4.2 配置文件

application.properties：

  1. spring.application.name=student-service
  2. spring.boot.admin.client.enabled=true
  3. spring.profiles.active=dev

配置日志、MySQL连接、MyBatis扫描包路径等信息；
application-dev.yml：

  1. server:
  2.   connection-timeout: 30000ms
  3.   port: 8081
  4.   servlet.context-path: /
  6. logging:
  7.   path: ./
  8.   file: st.log
  9.   #max-size: 10M
  10.   #max-history: 1
  11.   level:
  12.     root: INFO
  13.     org:
  14.       springframework:
  15.         web: INFO
  16.     com:
  17.       wxx:
  18.         sbmm:
  19.           mapper: DEBUG
  21. spring:
  22.   data:
  23.     mongodb:
  24.       database: studentService
  25.       host: localhost
  26.       port: 27017
  27.   datasource:
  28.     # 遇到时区问题用这个
  29.     # jdbc:mysql://localhost:3306?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
  30.     url: jdbc:mysql://localhost:3306/studentService?useSSL=false&useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
  31.     driver-class-name: com.mysql.cj.jdbc.Driver
  32.     username: root
  33.     password: 12345678
  34.     # schema.sql中一般存放的是DDL脚本，即通常为创建或更新库表的脚本
  35.     # data.sql中一般是DML脚本，即通常为数据插入脚本
  36.     schema: classpath:schema.sql
  37.     data: classpath:data.sql
  38.     platform: mysql
  39.     initialization-mode: always
  40.     continue-on-error: false
  41.     #data-password:
  42.     #data-username:
  43.     #schema-password:
  44.     #schema-username:
  45.     sql-script-encoding: utf-8
  46.     separator: ;
  47.     # type: com.alibaba.druid.pool.DruidDataSource
  49. mybatis:
  50.   mapper-locations: classpath:mapper/*.xml
  51.   type-aliases-package: com.wxx.sbmm.domain
  52.   # config-location:
  53.   configuration:
  54.     cache-enabled: true

MyBatis配置信息，参考[Configuration部分]：http://www.mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/index.html

这里使用springboot默认的数据库连接池；
配置中使用schema.sql存放创建库表的脚本，data.sql数据插入脚本，这是springboot的默认配置；
SpringBoot 2.x 集成 Mybatis - 图3

更多SpringBoot配置信息，参考：https://docs.spring.io/spring-boot/docs/current/reference/html/common-application-properties.html

4.3 配置数据库初始化脚本

数据库为：studentService
手动创建数据库：CREATE SCHEMA studentService DEFAULT CHARACTER SET utf8 ;
包含两个表，针对它们进行单表查询和关联查询：
学生表：t_student
成绩表：t_score
ER图：
SpringBoot 2.x 集成 Mybatis - 图4

schema.sql：初始化库表SQL

  1. CREATE DATABASE IF NOT EXISTS `studentService`;
  3. CREATE TABLE IF NOT EXISTS `t_student` (
  4. `id` INT NOT NULL AUTO_INCREMENT COMMENT 'ID',
  5. `name` VARCHAR(255)  DEFAULT "" COMMENT '姓名',
  6. `age` INT DEFAULT 10 COMMENT '年龄',
  7. `sex` VARCHAR(255)DEFAULT "Male" COMMENT '性别',
  8. `hobbies` VARCHAR(255) DEFAULT "" COMMENT '爱好',
  9. `address` VARCHAR(255) DEFAULT "" COMMENT '住址',
  10. PRIMARY KEY(`id`),
  11. UNIQUE INDEX  `idx_student_name_address` (`name`,`address`) USING BTREE
  12. )ENGINE = INNODB DEFAULT CHARSET=utf8 AUTO_INCREMENT = 1  COMMENT '学生表';
  14. CREATE TABLE IF NOT EXISTS `t_score` (
  15.   `id` INT NOT NULL AUTO_INCREMENT COMMENT 'ID',
  16. `student_id` INT DEFAULT 0 COMMENT '学生ID',
  17. `student_name` VARCHAR(255) DEFAULT "" COMMENT '学生姓名',
  18. `subject` VARCHAR(255) DEFAULT "" COMMENT '学科',
  19. `subject_score` INT COMMENT '学科成绩',
  20. PRIMARY KEY(`id`),
  21. UNIQUE INDEX  `idx_score_studentname_subject` (`student_name`,`subject`) USING BTREE ,
  22. FOREIGN KEY (student_id) REFERENCES t_student (id)
  23. )ENGINE = INNODB DEFAULT CHARSET=utf8 AUTO_INCREMENT = 1  COMMENT '学生成绩表';

data.sql：初始化数据SQL

  1. INSERT INTO t_student (name,age, sex, hobbies,  address)
  2.   SELECT "Even",9,"Male","ShuXue,English","XiAn" FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM t_student WHERE name = "Even");
  3. INSERT INTO t_student (name,age, sex, hobbies,  address)
  4.   SELECT "Weison",11,"Male","XuWen,WuLi","HeNan" FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM t_student WHERE name = "Weison");
  5. INSERT INTO t_student (name,age, sex, hobbies,  address)
  6.   SELECT "Angule",13,"Female","XuWen,English","Chengdu" FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM t_student WHERE name = "Angule");
  9. INSERT INTO t_score (student_id,student_name, subject,  subject_score)
  10.   SELECT 1,"Even","YuWen",90 FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM t_score WHERE student_name = "Even" and subject ="YuWen");
  12. INSERT INTO t_score (student_id,student_name, subject,  subject_score)
  13.   SELECT 1,"Even","ShuXue",89 FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM t_score WHERE student_name = "Even" and subject ="ShuXue");
  15. INSERT INTO t_score (student_id,student_name, subject,  subject_score)
  16.   SELECT 1,"Even","English",67 FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM t_score WHERE student_name = "Even" and subject ="English");
  18. INSERT INTO t_score (student_id,student_name, subject,  subject_score)
  19.   SELECT 2,"Weison","YuWen",69 FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM t_score WHERE student_name = "Weison" and subject ="YuWen");
  20. INSERT INTO t_score (student_id,student_name, subject,  subject_score)
  21.   SELECT 2,"Weison","ShuXue",94 FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM t_score WHERE student_name = "Weison" and subject ="ShuXue");
  22. INSERT INTO t_score (student_id,student_name, subject,  subject_score)
  23.   SELECT 2,"Weison","English",82 FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM t_score WHERE student_name = "Weison" and subject ="English");
  26. INSERT INTO t_score (student_id,student_name, subject,  subject_score)
  27.   SELECT 3,"Angule","YuWen",58 FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM t_score WHERE student_name = "Angule" and subject ="YuWen");
  28. INSERT INTO t_score (student_id,student_name, subject,  subject_score)
  29.   SELECT 3,"Angule","ShuXue",73 FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM t_score WHERE student_name = "Angule" and subject ="ShuXue");
  30. INSERT INTO t_score (student_id,student_name, subject,  subject_score)
  31.   SELECT 3,"Angule","English",91 FROM DUAL WHERE NOT EXISTS(SELECT 1 FROM t_score WHERE student_name = "Angule" and subject ="English");
  33. commit;

4.4 配置SQL XML

写sql的地方：StudentMapper.xml；

XML中sql标签id与Mapper接口中的方法名要一致，MyBatis会对他们进行关联去实现Mapper接口；

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  3.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
  4. <mapper namespace="com.wxx.sbmm.mapper.StudentMapper">
  6.     <!--
  7.     执行增加操作的SQL语句
  8.     1.id和parameterType 分别与StudentMapper接口中的addStudent方法的名字和 参数类型一致
  9.     2.以#{studentName}的形式引用Student参数 的studentName属性，MyBatis将使用反射读取Student参数的此属性
  10.     3.#{studentName}中studentName大小写敏感。引用其他的属性与此一致
  11.     4.seGeneratedKeys设置为"true"表明要MyBatis获取由数据库自动生成的主键
  12.     5.keyProperty="id"指定把获取到的主键值注入到Student的id属性
  13.     -->
  16.     <!-- 当表中字段名跟实体类字段名不一致 或 为了返回list类型 可以定义returnMap -->
  17.     <resultMap id="studentMap" type="Student">
  18.         <id column="id" property="id"/>
  19.         <result column="name" property="name"/>
  20.         <result column="age" property="age"/>
  21.         <result column="sex" property="sex"/>
  22.         <result column="hobbies" property="hobbies"/>
  23.         <result column="address" property="address"/>
  24.     </resultMap>
  26.     <resultMap id="scoreResultMap" type="Score">
  27.         <id column="id" property="id"/>
  28.         <result column="student_id" property="studentId"/>
  29.         <result column="student_name" property="studentName"/>
  30.         <result column="subject" property="subject"/>
  31.         <result column="subject_score" property="subjectScore"/>
  32.     </resultMap>
  35.     <!--增删改查 开始-->
  36.     <!--新增 1-->
  37.     <insert id="saveStudent" parameterType="Student" useGeneratedKeys="true" keyProperty="id">
  38.         insert into t_student(name,age,sex,hobbies,address)
  39.         values(#{name},#{age},#{sex},#{hobbies},#{address})
  40.     </insert>
  42.     <!--删除 1-->
  43.     <delete id="deleteStudentByName" parameterType="String">
  44.         delete from t_student where name=#{name}
  45.     </delete>
  46.     <!--删除 2-->
  47.     <delete id="deleteByStudent" parameterType="Student">
  48.         delete from t_student
  49.         <where>
  50.             1=1
  51.             <if test="name != null and name != ''">
  52.                 and name = #{name}
  53.             </if>
  54.             <if test="age != null and age != ''">
  55.                 and age = #{age}
  56.             </if>
  57.             <if test="sex != null and sex != ''">
  58.                 and sex=#{sex}
  59.             </if>
  60.             <if test="hobbies != null and hobbies != ''">
  61.                 and hobbies=#{hobbies}
  62.             </if>
  63.             <if test="address != null and address != ''">
  64.                 and address=#{address}
  65.             </if>
  66.         </where>
  67.     </delete>
  69.     <!--修改 1-->
  70.     <update id="updateStudent" parameterType="Student">
  71.         update t_student set
  72.         <if test="age != null and age != ''">
  73.             age = #{age},
  74.         </if>
  75.         <if test="sex != null and sex != ''">
  76.             sex = #{sex},
  77.         </if>
  78.         <if test="hobbies != null and hobbies != ''">
  79.             hobbies = #{hobbies},
  80.         </if>
  81.         <if test="address != null and address != ''">
  82.             address = #{address}
  83.         </if>
  84.         where name=#{name}
  85.     </update>
  87.     <!--查询 1  -->
  88.     <select id="findStudentByName" parameterType="String" resultMap="studentMap">
  89.         SELECT * FROM t_student where name = #{name};
  90.     </select>
  92.     <!--查询 2 返回list的select语句，注意resultMap的值是指向前面定义好的 -->
  93.     <select id="findStudents" resultMap="studentMap">
  94.         select * from t_student
  95.     </select>
  97.     <!--查询 2 返回list的select语句，注意resultMap的值是指向前面定义好的 -->
  98.     <select id="findScores" resultMap="scoreResultMap">
  99.         select * from t_score
  100.     </select>
  102.     <!--查询 3 利用 hashMap 传递多个参数 -->
  103.     <select id="findStudentByMap" parameterType="Map" resultType="Student">
  104.         select * from t_student
  105.         <where>
  106.             1=1
  107.             <if test="name != null and name != ''">
  108.                 and name = #{name}
  109.             </if>
  110.             <if test="age != null and age != ''">
  111.                 and age = #{age}
  112.             </if>
  113.             <if test="sex != null and sex != ''">
  114.                 and sex=#{sex}
  115.             </if>
  116.             <if test="hobbies != null and hobbies != ''">
  117.                 and hobbies=#{hobbies}
  118.             </if>
  119.             <if test="address != null and address != ''">
  120.                 and address=#{address}
  121.             </if>
  122.         </where>
  123.     </select>
  125.     <!--查询 4 利用 hashMap 传递多个参数 -->
  126.     <select id="findStudentByStudent" parameterType="Student" resultType="Student">
  127.         select * from t_student
  128.         <where>
  129.             1=1
  130.             <if test="name != null and name != ''">
  131.                 and name = #{name}
  132.             </if>
  133.             <if test="age != null and age != ''">
  134.                 and age = #{age}
  135.             </if>
  136.             <if test="sex != null and sex != ''">
  137.                 and sex=#{sex}
  138.             </if>
  139.             <if test="hobbies != null and hobbies != ''">
  140.                 and hobbies=#{hobbies}
  141.             </if>
  142.             <if test="address != null and address != ''">
  143.                 and address=#{address}
  144.             </if>
  145.         </where>
  146.     </select>
  148.     <!--查询 5 Mybatis 自带的多个参数传递方法 这个时候没有 parameterType, 但用到了类似 #{param1} 类似的参数 -->
  149.     <select id="findStudentByAgeAndSex" resultType="com.wxx.sbmm.domain.Student">
  150.         select * from t_student where age = #{param1} and sex=#{param2}
  151.     </select>
  154.     <!--增删改查 结束-->
  156.     <!--联合查询 开始-->
  159.     <!--联合查询:studentScoreListResultMap-->
  160.     <resultMap id="studentScoreListResultMap" type="com.wxx.sbmm.domain.StudentScores">
  161.         <id column="aid" jdbcType="INTEGER" property="id"/>
  162.         <result column="name" jdbcType="VARCHAR" javaType="String" property="name"/>
  163.         <result column="age" javaType="Integer" property="age"/>
  164.         <result column="sex" javaType="String" property="sex"/>
  165.         <collection property="scoreList" javaType="List" ofType="Score">
  166.             <id column="bid" jdbcType="INTEGER" property="id"/>
  167.             <result property="studentId" column="student_id"/>
  168.             <result property="studentName" column="student_name"/>
  169.             <result property="subject" column="subject"/>
  170.             <result property="subjectScore" column="subject_score"/>
  171.         </collection>
  172.     </resultMap>
  174.     <!--联合查询:studentScoreResultMap-->
  175.     <resultMap id="studentScoreResultMap" type="com.wxx.sbmm.domain.StudentScore">
  176.         <id column="aid" jdbcType="BIGINT" javaType="Integer" property="id"/>
  177.         <result property="name" jdbcType="VARCHAR" javaType="String" column="name"/>
  178.         <result property="age" column="age" jdbcType="VARCHAR" javaType="Integer"/>
  179.         <result property="sex" column="sex" jdbcType="VARCHAR" javaType="String"/>
  180.         <association property="score" javaType="com.wxx.sbmm.domain.Score">
  181.             <id property="id" column="bid"/>
  182.             <result property="studentId" column="student_id"/>
  183.             <result property="studentName" column="student_name"/>
  184.             <result property="subject" column="subject"/>
  185.             <result property="subjectScore" column="subject_score"/>
  186.         </association>
  187.     </resultMap>
  189.     <!-- 联合查询 1 findStudentScoreList-->
  190.     <select id="findStudentScores" parameterType="Integer" resultMap="studentScoreListResultMap">
  191.         select
  192.         a.id aid,
  193.         a.name name,
  194.         a.age age,
  195.         a.sex sex,
  196.         b.id bid,
  197.         b.student_id student_id,
  198.         b.student_name student_name,
  199.         b.subject subject,
  200.         b.subject_score subject_score
  201.         from t_student a
  202.         left join t_score b
  203.         on a.id=b.student_id
  204.     </select>
  205.     <!-- 联合查询 2 findStudentScore-->
  206.     <select id="findStudentScore" resultMap="studentScoreResultMap">
  207.         select
  208.         a.id aid,
  209.         a.name name,
  210.         a.age age,
  211.         a.sex sex,
  212.         b.id bid,
  213.         b.student_id student_id,
  214.         b.student_name student_name,
  215.         b.subject subject,
  216.         b.subject_score subject_score
  217.         from t_student a
  218.         left join t_score b
  219.         on a.id=b.student_id
  220.         where b.subject = 'English'
  221.         and a.name = b.student_name
  222.     </select>
  223.     <!-- 联合查询 结束 -->
  225. </mapper>

Mapper XML 官方说明：http://www.mybatis.org/mybatis-3/sqlmap-xml.html#

5.代码

5.1 创建StudentMapper

使用@Mapper 注解标明 Mapper接口，MyBatis会帮我们去实现这个接口，该接口中方法与4.4xml中sql标签ID相对应：

  1. package com.wxx.sbmm.mapper;
  4. import com.wxx.sbmm.domain.Score;
  5. import com.wxx.sbmm.domain.Student;
  6. import com.wxx.sbmm.domain.StudentScore;
  7. import com.wxx.sbmm.domain.StudentScores;
  8. import org.apache.ibatis.annotations.Mapper;
  9. import org.apache.ibatis.annotations.Param;
  11. import java.util.List;
  12. import java.util.Map;
  14. @Mapper
  15. public interface StudentMapper {
  17.     // 增删改查
  18.     Integer saveStudent(Student student);
  20.     Integer deleteStudentByName(@Param("name") String name);
  22.     Integer deleteByStudent(Student student);
  24.     Integer updateStudent(Student student);
  26.     // 5种查询
  27.     Student findStudentByName(@Param("name") String name);
  29.     List<Student> findStudents();
  31.     List<Student> findStudentByMap(Map<String, String> map);
  33.     List<Student> findStudentByStudent(Student student);
  35.     List<Student> findStudentByAgeAndSex(Integer age, String sex);
  37.     // 关联查询
  38.     List<StudentScores> findStudentScores();
  39.     List<StudentScore> findStudentScore();
  41. }

Mapper更多信息，参考：http://www.mybatis.org/spring/mappers.html#

5.2 创建Service

  1. package com.wxx.sbmm.service;
  3. import com.wxx.sbmm.domain.Student;
  4. import com.wxx.sbmm.domain.StudentScore;
  5. import com.wxx.sbmm.domain.StudentScores;
  6. import com.wxx.sbmm.mapper.StudentMapper;
  7. import org.springframework.stereotype.Service;
  9. import javax.annotation.Resource;
  10. import java.util.List;
  11. import java.util.Map;
  13. @Service
  14. public class StudentService {
  16.     @Resource
  17.     private StudentMapper studentMapper;
  20.     public Integer addStudent(Student student) {
  21.         return studentMapper.saveStudent(student);
  22.     }
  24.     public Integer deleteStudentByName(String name) {
  25.         return studentMapper.deleteStudentByName(name);
  26.     }
  28.     public Integer deleteByStudent(Student student) {
  29.         return studentMapper.deleteByStudent(student);
  30.     }
  32.     public Integer updateStudent(Student student) {
  33.         return studentMapper.updateStudent(student);
  34.     }
  37.     public Student findStudentByName(String name) {
  38.         return studentMapper.findStudentByName(name);
  39.     }
  41.     public List<Student> findStudents() {
  42.         return studentMapper.findStudents();
  43.     }
  45.     public List<Student> findStudentByMap(Map<String, String> map) {
  46.         return studentMapper.findStudentByMap(map);
  47.     }
  49.     public List<Student> findStudentByStudent(Student student) {
  50.         return studentMapper.findStudentByStudent(student);
  51.     }
  54.     public List<Student> findStudentByAgeAndSex(Integer age, String sex) {
  55.         return studentMapper.findStudentByAgeAndSex(age, sex);
  56.     }
  58.     public List<StudentScores> findStudentScores() {
  59.         return studentMapper.findStudentScores();
  60.     }
  62.     public List<StudentScore> findStudentScore() {
  63.         return studentMapper.findStudentScore();
  64.     }
  66. }

5.3 创建Controller

  1. package com.wxx.sbmm.controller;
  3. import com.wxx.sbmm.domain.Student;
  4. import com.wxx.sbmm.domain.StudentScore;
  5. import com.wxx.sbmm.domain.StudentScores;
  6. import com.wxx.sbmm.service.StudentService;
  7. import org.springframework.beans.factory.annotation.Autowired;
  8. import org.springframework.web.bind.annotation.*;
  10. import java.util.HashMap;
  11. import java.util.List;
  12. import java.util.Map;
  14. @RestController
  15. public class StudentController {
  16.     @Autowired
  17.     private StudentService studentService;
  19.     @PostMapping("/students")
  20.     public Integer saveStudent(@RequestBody Student student) {
  21.         Integer addNum = studentService.addStudent(student);
  22.         return addNum;
  23.     }
  25.     @DeleteMapping("/students/{name}")
  26.     public Integer deleteStudentByName(@PathVariable String name) {
  27.         Integer deleteNum = studentService.deleteStudentByName(name);
  28.         return deleteNum;
  29.     }
  31.     @DeleteMapping("/students")
  32.     public Integer deleteStudentByStudent(@RequestBody Student student) {
  33.         Integer deleteNum = studentService.deleteByStudent(student);
  34.         return deleteNum;
  35.     }
  37.     @PutMapping("/students")
  38.     public Integer updateStudent(@RequestBody Student student) {
  39.         Integer updateNum = studentService.updateStudent(student);
  40.         return updateNum;
  41.     }
  43.     @GetMapping("/students/{name}")
  44.     public Student findStudentByName(@PathVariable String name) {
  45.         Student student = studentService.findStudentByName(name);
  46.         return student;
  47.     }
  49.     @GetMapping("/students")
  50.     public List<Student> getStudentListByAgeAndSexAndHobbies() {
  51.         List<Student> studentList = studentService.findStudents();
  52.         return studentList;
  53.     }
  55.     @GetMapping("/students/map")
  56.     public List<Student> findStudentByMap() {
  57.         Map<String, String> map = new HashMap<>();
  58.         map.put("name", "Even");
  59.         List<Student> studentList = studentService.findStudentByMap(map);
  60.         return studentList;
  61.     }
  63.     @GetMapping("/students/st")
  64.     public List<Student> findStudentByStudent() {
  65.         List<Student> studentList = studentService.findStudentByStudent(Student.builder().name("Even").build());
  66.         return studentList;
  67.     }
  69.     @GetMapping("/students/{age}/{sex}")
  70.     public List<Student> findStudentByAgeAndSex(@PathVariable Integer age, @PathVariable String sex) {
  71.         List<Student> studentList = studentService.findStudentByAgeAndSex(age, sex);
  72.         return studentList;
  73.     }
  75.     @GetMapping("/students/scores")
  76.     public List<StudentScores> findStudentScores() {
  77.         List<StudentScores> studentList = studentService.findStudentScores();
  78.         return studentList;
  79.     }
  81.     @GetMapping("/students/score")
  82.     public List<StudentScore> findStudentScore() {
  83.         List<StudentScore> studentScores = studentService.findStudentScore();
  84.         return studentScores;
  85.     }
  87. }

5.4 最终项目

应该是这个样子：
SpringBoot 2.x 集成 Mybatis - 图5启动项目后，刷新数据库，看到数据库、表和数据都有了：
SpringBoot 2.x 集成 Mybatis - 图6

6. 测试

两个比较复杂的接口返回：
/students/scores：
SpringBoot 2.x 集成 Mybatis - 图7

/students/score：
SpringBoot 2.x 集成 Mybatis - 图8

代码 —> https://github.com/WeisonWei/springboot-aggregation/tree/master/springboot-mvc-mybatis