Spring Boot使用插件PageHelper分页查询

分页查询详细记录

1. 在pom.xml引入maven依赖

可到仓库https://mvnrepository.com/查看最新依赖

2. 在application.properties添加配置

pagehelper.helper-dialect=mysql
pagehelper.reasonable=true
pagehelper.support-methods-arguments=true
pagehelper.params=count=countSql

3. 在service以及impl也写上相关方法：

	public interface EmployeeService {
    	PageInfo<Employee> findAllEmployeeByPage(int pageNum, int pageSize);
	}
	
	@Override
    public PageInfo<Employee> findAllEmployeeByPage(int pageNum, int pageSize) {
        PageHelper.startPage(pageNum, pageSize);
        List<Employee> lists = employeeDao.selectPage();
        PageInfo<Employee> pageInfo = new PageInfo<Employee>(lists);
        return pageInfo;
    }

4.在dao添加与数据库映射的方法

	List<Employee> selectPage();

5.在EmploeeDaoMapper.xml添加查询语句，直接查询所有即可，插件会自动处理

6.然后就可以去controller里写接口了

@RequestMapping("/member-list/{pageNum}")
    public String selectPage(@PathVariable("pageNum") Integer pageNum,
                             Model model){
        PageInfo<Employee> pageInfo = employeeService.findAllEmployeeByPage(pageNum, 10);
        model.addAttribute("employees",pageInfo.getList());
        model.addAttribute("pageInfo", pageInfo);
        model.addAttribute("pre", pageInfo.getPageNum()-1);
        model.addAttribute("next", pageInfo.getPageNum()+1);
        return "admin/member-list";
    }

最后，去浏览器查看分页效果