SpringBoot+MyBatis+thymeleaf框架实现增删改查分页显示

一、Mysql创建数据库（schema.sql创库脚本）

可在Mysql数据库直接创建数据库mybatis_test

数据库表创建及插入脚本：

CREATE TABLE user(

id int(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,

name  varchar(255) DEFAULT NULL,

age int(11) DEFAULT NULL

)ENGINE=InnoDB DEFAULT CHARSET=utf8  

-- ----------------------------

-- Records of user

-- ----------------------------

INSERT INTO user VALUES ('1', 'zhangsan', 25);

INSERT INTO user VALUES ('2', 'lisi', 28);

二、maven依赖【pom.xml完整依赖】

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">

<modelVersion>4.0.0</modelVersion>

<parent>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-parent</artifactId>

<version>2.6.1</version>

<relativePath/> <!-- lookup parent from repository -->

</parent>

<groupId>com</groupId>

<artifactId>MyBatisDemo</artifactId>

<version>1.0</version>

<name>MyBatisDemo</name>

<description>MyBatisDemo project for Spring Boot</description>

<properties>

<java.version>1.8</java.version>

</properties>

<dependencies>

    <dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-web</artifactId>

</dependency>

<!--<dependency>

<groupId>com.baomidou</groupId>

<artifactId>mybatis-plus-generator</artifactId>

<version>3.4.0</version>

</dependency>  -->

<dependency>

            <groupId>org.mybatis.spring.boot</groupId>

            <artifactId>mybatis-spring-boot-starter</artifactId>

            <version>2.1.1</version>

</dependency>

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<scope>runtime</scope>

</dependency>

<dependency>

<groupId>org.projectlombok</groupId>

<artifactId>lombok</artifactId>

<optional>true</optional>

</dependency>

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-devtools</artifactId>

<scope>runtime</scope>

<optional>true</optional>

</dependency>

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-test</artifactId>

<scope>test</scope>

</dependency>

<dependency>

           <groupId>javax.validation</groupId>

           <artifactId>validation-api</artifactId>

        </dependency>

<dependency>

        <groupId>org.springframework</groupId>

        <artifactId>spring-aspects</artifactId>

        </dependency>

        <dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-actuator</artifactId>

</dependency>

<!-- 增加对PageHelper的分页支持 -->

<dependency>

<groupId>com.github.pagehelper</groupId>

<artifactId>pagehelper</artifactId>

<version>4.1.6</version>

</dependency>

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-thymeleaf</artifactId>

</dependency>

<!--

<dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-data-jpa</artifactId>

        </dependency>

          -->

</dependencies>

<build>

<plugins>

<plugin>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-maven-plugin</artifactId>

</plugin>

</plugins>

</build>

</project>

三、实体类

3.1学生实体类(User.java)

package com.entity;

import java.io.Serializable;

//import javax.persistence.Column;

//import javax.persistence.GeneratedValue;

//import javax.persistence.GenerationType;

//import javax.persistence.Id;

public class User implements Serializable{

private static final long serialVersionUID = 1L;

// @GeneratedValue(strategy=GenerationType.IDENTITY)

// @Column(name = "id")

// @Id

private int id;

private String name;

private int age;

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;

}

public int getAge() {

return age;

}

public void setAge(int age) {

this.age = age;

}

public User(int id,String name,int age) {

super();

this.id=id;

this.name=name;

this.age=age;

}

@Override

public String toString() {

return "User [id=" + id + ", name=" + name + ", age=" + age

+ "]";

}

}

四、开始整合SpringBoot+MyBatis

4.1 配置文件

(1) application.yml配置文件

server:

  port: 9098

  compression:

    enabled: true

  tomcat:

    uri-encoding: utf-8

    connection-timeout: 30000

    maxHttpHeaderSize: 8999

    disableUploadTimeout: true

  servlet:

    context-path: /

  thymeleaf:

   prefix: /templates/

   suffix: .html

   mode: HTML