Springboot+Mybatis实现简单分页

    4.0.0
    com.example
    test
    0.0.1-SNAPSHOT
    test
    Demo project for Spring Boot

    
        1.8
        UTF-8
        UTF-8
        2.3.7.RELEASE
    

    
        
            com.github.pagehelper
            pagehelper
            5.2.0
        

        
            org.springframework.boot
            spring-boot-starter-web
        

        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            2.2.2
        

        
            mysql
            mysql-connector-java
        
        
        
            org.projectlombok
            lombok
            true
        
    

# 应用名称
spring:
  application:
    name: test
  datasource:
    username: pcb
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/test1?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&serverTimezone=UTC


# 应用服务 WEB 访问端口
server:
  port: 8123

mybatis:
  mapper-locations: classpath:mapper/*.xml

package com.example.test.controller;

import com.example.test.entity.User;
import com.example.test.service.interf.UserService;
import com.github.pagehelper.PageInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RestController;


@RestController
public class UserController {

    @Autowired
    private UserService userService;

    @PostMapping("/queryUser")
    public PageInfo queryUser(int pageNumber, int pageSize){

        PageInfo userPage = userService.queryUserPage(pageNumber, pageSize);
        return userPage;
    }

}

package com.example.test.service.impl;

import com.example.test.entity.User;
import com.example.test.mapper.UserMapper;
import com.example.test.service.interf.UserService;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserServiceImpl implements UserService {

    @Autowired
    private UserMapper userMapper;


    @Override
    public PageInfo queryUserPage(int pageNumber, int pageSize) {

        PageHelper.startPage(pageNumber,pageSize);
        List users = userMapper.findByPage();

        return new PageInfo<>(users);
    }
}

package com.example.test.mapper;

import com.example.test.entity.User;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface UserMapper {

    List findByPage();
}

    
        select * from user