springboot使用mybatis分页器

springboot使用mybatis分页器

1.导包

pom.xml

<dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.3</version>
        </dependency>

 2.配置applcation.yml

server:
  port: 8083

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/vueblog?serverTimezone=UTC
    username: root
    password: 998

mybatis:
  mapper-locations: classpath:mapper/*Mapper.xml
  type-aliases-package: com.example.mybatis.entity

pagehelper:
  helper-dialect: mysql//这个是关键

3.构建实体类

package com.example.mybatis.utils;

public class Entity {
    private Integer page;
    private Integer limit = 5;

    public Integer getPage() {
        return page;
    }

    public void setPage(Integer page) {
        this.page = page;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setLimit(Integer limit) {
        this.limit = limit;
    }
}

4.user类继承于page分页实体类

package com.example.mybatis.entity;


import com.example.mybatis.utils.Entity;

/**
 * @Author:wjup
 * @Date: 2018/9/26 0026
 * @Time: 14:39
 */
public class User extends Entity {
    private Integer id;
    private String userName;
    private String passWord;
    private String realName;

    public User(Integer id, String userName, String passWord, String realName) {
        this.id = id;
        this.userName = userName;
        this.passWord = passWord;
        this.realName = realName;
    }

    public User() {

    }

    public Integer getId() {
        return id;
    }

    public String getUserName() {
        return userName;
    }

    public String getPassWord() {
        return passWord;
    }

    public String getRealName() {
        return realName;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public void setPassWord(String passWord) {
        this.passWord = passWord;
    }

    public void setRealName(String realName) {
        this.realName = realName;
    }





    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", userName='" + userName + '\'' +
                ", passWord='" + passWord + '\'' +
                ", realName='" + realName + '\'' +
                '}';
    }
}

5.开始写接口

5.1controller层

/**
     * 查询所有信息
     * @return
     */
    @RequestMapping("/findAll")
    public List<User> findAll(User user){
        return userService.findAll(user);
    };

5.2 service层

 /**
     * 查：查新所有信息
     * @return
     */
    public List<User> findAll(User user){

        if (user != null && user.getPage() != null) {
            PageHelper.startPage(user.getPage(), user.getLimit());

        }
        return userMapper.findAll(user);
    }

5.3userMapper.JAVA
 

/**
 * 查询所有用户
 * @return all user
 */
List<User> findAll(User user);

5.4mapper.xml

<!--    查所有-->
    <select id="findAll" resultType="com.example.mybatis.entity.User">
        SELECT * FROM user//这里不能有符号
    </select>