mybatis-PageHelper实现分页增删改查

先上效果图

1. 工程搭建

技术选型：springboot+通用mapper+thymeleaf+amazeUI（还需要lombok插件）
平台工具：idea2019.3+maven+MySQL5.5+Navicat

1.1数据库设计

包括三个属性：id,username,password，其中id设置为主键并自增

1.2依赖坐标

在pom.xml中添加

<dependencies>
        <!-- 分页插件 -->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.10</version>
        </dependency>
        <!--mysql-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.46</version>
        </dependency>
        <!--mybatis 通用mapper-->
        <dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper-spring-boot-starter</artifactId>
            <version>2.1.5</version>
        </dependency>
         <!--jdbc 包含hikariCP-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <!--thymeleaf-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
          <!--web-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
  		<!--热部署-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>
        <!--属性注入bean-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-configuration-processor</artifactId>
            <optional>true</optional>
        </dependency>
        <!--lombok-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <!--test-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>
    </dependencies>

利用maven项目管理工具自动导入相关依赖

1.3yml相关配置

# 使用springboot自带的数据源hikariCP
spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    # 其中/eshop对应数据库
    url: mysql://localhost:3306/eshop?characterEncoding=utf8
    username: root
    # yml的bug，对于纯数字类型的密码需要加引号，如果是包含字母的就不需要
    password: '052398'
  thymeleaf: #关闭缓存
    cache: false

# mybatis配置 showSql
mybatis:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
# pagehelper配置    
pagehelper:
  helperDialect: mysql
  reasonable: true # 合理化查询，例如在第一页点击上一页时不会报错
  supportMethodsArguments: true
  params: count=countSql # 需要查出总记录数

2. 测试先行

2.1实体类UserTK

package com.hp.day5pagesearchdemo.domain;

import lombok.Data;
import tk.mybatis.mapper.annotation.KeySql;

import javax.persistence.Id;
import javax.persistence.Table;

@Data//提供getter\setter\tostring方法的注解
@Table(name = "users")// 声明此对象映射到数据库的数据表'users'
public class UserTK {
   
    @Id//自增
    @KeySql(useGeneratedKeys = true)
    private Integer id;//int改为Integer
    private String username;
    private String password;
	//有参、无参构造可利用注解实现
    public