springboot实现分页

本节以获取团队信息为例
springboot（后端）+thymeleaf（前端）

1.编写Controller类

@Controller
@RequestMapping("/t_park_team")
public class T_park_teamController {
	@RequestMapping("/page")
	    public String findPage(String pageNumber,Model model){
	        String spPage=pageNumber;
	        int pageSize = 5;//每页大小
	        int pageNo=0;//页数
	        if(spPage==null){
	            pageNo=1;
	        }else {
	            pageNo = Integer.valueOf(spPage);
	            if (pageNo < 1) {
	                pageNo = 1;
	            }
	        }
	        //获取总数
	        int totalCount=0;
	        int count=t_park_teamMapper.getCount();
	        if(count>0){
	            totalCount=count;
	        }
	        //最大页数maxPage = 总数/每页大小，有余数就+1
	        int maxPage=totalCount%pageSize==0?totalCount/pageSize:totalCount/pageSize+1;
	        if(pageNo>maxPage){//上届
	            pageNo=maxPage;
	        }
	        List<T_park_team> t_park_teams = t_park_teamMapper.findPage(pageNo,pageSize);
	        model.addAttribute("pageNo",pageNo);
	        model.addAttribute("pageSize",pageSize);
	        model.addAttribute("maxPage",maxPage);
	        model.addAttribute("teams",t_park_teams);
	        return "t_park_team1";
	    }
}

2.编写Mapper

//获取数据总数
    @Select("select count(*) from t_park_team")
    public int getCount();
    //分页查询
    @Select("select * from t_park_team limit #{pageNo},#{pageSize}")
    public List<T_park_team> findPage(int pageNo,int pageSize);

3.前端HTML

${teams}//循环遍历teams,此处略写

			<a th:href="@{/t_park_team/page?pageNumber=1}">首页</a>
            <a th:href="@{'/t_park_team/page?pageNumber='+${pageNo-1}}">上一页</a>
            <a th:href="@{'/t_park_team/page?pageNumber='+${pageNo+1}}">下一页</a>
            <a th:href="@{'/t_park_team/page?pageNumber='+${maxPage}}">尾页</a>

实现截图