<!-- 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>1.3.2</version>
 </dependency>
 <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
 <dependency>
 <groupId>mysql</groupId>
 <artifactId>mysql-connector-java</artifactId>
 <version>8.0.11</version>
 </dependency>

CREATE TABLE `user` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(20) DEFAULT NULL,
 `age` int(11) DEFAULT NULL,
 `sex` varchar(20) DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

package com.example.model;

import java.io.Serializable;

public class User implements Serializable{
 @Override
 public String toString() {
 // TODO Auto-generated method stub
 return "User [id=" + Id + ", name=" + Name + ", age=" + Age + "]";

 }

 public int getId() {
 return Id;
 }
 public void setId(int id) {
 Id = id;
 }
 public String getName() {
 return Name;
 }
 public void setName(String name) {
 Name = name;
 }
 public int getAge() {
 return Age;
 }
 public void setAge(int age) {
 Age = age;
 }
 private int Id;
 private String Name;
 private int Age; 
 
 private UserSexEnum Sex;

 public UserSexEnum getSex() {
 return Sex;
 }
 public void setSex(UserSexEnum sex) {
 Sex = sex;
 }
}

package com.example.model;

public enum UserSexEnum {
 MAN, WOMAN
}

package com.example.mapper;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.example.model.*;;
public interface UserMapper {
 @Select("SELECT * FROM user")
 @Results({
 @Result(property = "Sex", column = "sex", javaType = UserSexEnum.class),
 @Result(property = "Name", column = "name")

 })

 List<User> getAll();
 @Select("SELECT * FROM user WHERE id = #{id}")

 @Results({
 @Result(property = "Sex", column = "sex", javaType = UserSexEnum.class),
 @Result(property = "Name", column = "name")
 })

 User getOne(int id);
 @Insert("INSERT INTO user(name,age,sex) VALUES(#{name}, #{age}, #{sex})")
 void insert(User user);
 @Update("UPDATE user SET name=#{userName},age=#{age} WHERE id =#{id}")
 void update(User user);
 @Delete("DELETE FROM user WHERE id =#{id}")
 void delete(int id);
}

package com.example.demo;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.example.mapper")
public class DemoApplication {

 public static void main(String[] args) {
 SpringApplication.run(DemoApplication.class, args);
 }
}

package com.example.demo;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import com.example.mapper.UserMapper;
import com.example.model.User;
import com.example.model.UserSexEnum;

@Controller
@RequestMapping("/user")
public class UserController {
 
 @Autowired
 private UserMapper userMapper;
 
 @RequestMapping(value = "/alluser.do",method = RequestMethod.GET)
 public String getallusers(Model model) {
 List<User> users=userMapper.getAll();
 model.addAttribute("users", users);
 return "userlist";
 }
 @RequestMapping(value = "/insert.do",method = RequestMethod.GET)
 public String adduser(Model model) {
 User user=new User();
 user.setName("cuiyw");
 user.setAge(27);
 user.setSex(UserSexEnum.MAN);
  
 userMapper.insert(user);
 List<User> users=userMapper.getAll();
 model.addAttribute("users", users);
 return "userlist";
 }
}

spring.mvc.view.prefix=/view/

spring.mvc.view.suffix=.jsp
mybatis.type-aliases-package=com.example.model

spring.datasource.driverClassName = com.mysql.cj.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/mybatis
spring.datasource.username = root
spring.datasource.password = 123456

<%@ page language="java" contentType="text/html; charset=utf-8"
 pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Insert title here</title>
</head>
<body>
 <table>
 <tr><th>名字</th><th>年齡</th><th>性別</th></tr>
 <c:forEach items="${users}" var="item">
  <tr><td>${item.name}</td><td>${item.age}</td><td>${item.sex}</td></tr>
 </c:forEach>
 </table>
</body>
</html>