MyBatis使用分页插件PageHelper

GitHub完整代码地址：https://github.com/a6678696/MyBatisPageHelperTest

	com.github.pagehelper
	pagehelper-spring-boot-starter
	1.3.0

pagehelper:
  helperDialect: mysql
  reasonable: true
  supportMethodsArguments: true
  params: count=countSql

package com.ledao.entity;

import lombok.Data;


@Data
public class User {

    private Integer id;

    private String userName;

    private String password;

    private String nickName;
}

package com.ledao.mapper;

import com.ledao.entity.User;

import java.util.List;


public interface UserMapper {

    
    List findAll();
}

    
        
        
        
        
    

    
        select * from t_user
    

package com.ledao.service;

import com.github.pagehelper.PageInfo;


public interface UserService {
    
    
    PageInfo findAll(int page, int size);
}

package com.ledao.service.impl;

import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.ledao.entity.User;
import com.ledao.mapper.UserMapper;
import com.ledao.service.UserService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;


@Service("userService")
public class UserServiceImpl implements UserService {

    @Resource
    private UserMapper userMapper;

    @Override
    public PageInfo findAll(int page, int size) {
        PageHelper.startPage(page, size);
        List userList = userMapper.findAll();
        PageInfo result = new PageInfo<>(userList);
        return result;
    }
}

package com.ledao.controller;

import com.github.pagehelper.PageInfo;
import com.ledao.service.UserService;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;


@RestController
@RequestMapping("/user")
public class UserController {

    @Resource
    private UserService userService;

    @RequestMapping("/findAll")
    public PageInfo findAll(int page, int size) {
        return userService.findAll(page, size);
    }
}

浏览器地址栏输入http://localhost/user/findAll?page=3&size=4