初学Springmvc+mybatis实现分页

转自：https://blog.csdn.net/qq_34059693/article/details/78491513
首先建一个分页的实体类：

public class Page implements Serializable{
                private static final long serialVersionUID=1L;

                private int pageNow=1;      //当前也是

                private int pageSize=8;     //每页显示的数量

                private int totalCount;     //总记录数

                private int totalPageCount;      //总页数

                private int startPos;        //开始位置，从0开始

                private boolean hasFrist;      //是否有首页

                private boolean hasPre;     //是否有前一页

                private boolean hasNext;     //是否有后一页

                private boolean hasLast;     //是否有尾页

                /**
                 * 通过构造函数，传入总记录数和当前页
                 * @param pageNow
                 * @param totalCount
                 */
                public Page(int pageNow, int totalCount) {
                    super();
                    this.pageNow = pageNow;
                    this.totalCount = totalCount;
                }
                //获取总页数
                public int getTotalPageCount() {
                    totalPageCount=getTotalCount()/getPageSize();
                    return (totalCount/pageSize==0) ? totalPageCount:totalPageCount+1;
                }

                public void setTotalPageCount(int totalPageCount) {
                    this.totalPageCount = totalPageCount;
                }

                public int getPageNow() {
                    return pageNow;
                }

                public void setPageNow(int pageNow) {
                    this.pageNow = pageNow;
                }

                public int getPageSize() {
                    return pageSize;
                }

                public void setPageSize(int pageSize) {
                    this.pageSize = pageSize;
                }

                public int getTotalCount() {
                    return totalCount;
                }

                public void setTotalCount(int totalCount) {
                    this.totalCount = totalCount;
                }
                //取得选择记录的初始位置
                public int getStartPos() {
                    return (pageNow-1)*pageSize;
                }

                public void setStartPos(int startPos) {
                    this.startPos = startPos;
                }
                //判断是否有第一页
                public boolean isHasFrist() {
                    return (pageNow==1) ? false:true;
                }

                public void setHasFrist(boolean hasFrist) {
                    this.hasFrist = hasFrist;
                }
                //如果有首页就有前一页
                public boolean isHasPre() {
                    return isHasFrist() ? true:false;
                }

                public void setHasPre(boolean hasPre) {
                    this.hasPre = hasPre;
                }
                //如果有尾页就有下一页
                public boolean isHasNext() {
                    return isHasNext() ? true:false;
                }

                public void setHasNext(boolean hasNext) {
                    this.hasNext = hasNext;
                }
                //判断是否有尾页
                public boolean isHasLast() {
                    return (pageNow==getTotalCount()) ? false:true;
                }

                public void setHasLast(boolean hasLast) {
                    this.hasLast = hasLast;
                }

实体类每个属性的意思都加了注释
再到mapper层写分页sql

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.sdl.mapper.NewsMapper">
            <select id="findNewsPage" resultType="News">
                    select * from news limit #{0},#{1}
            </select>
            <select id="findNewCont" resultType="int">
                    select COUNT(*) from news
            </select>
</mapper>

第二条sql语句是记录总数量
control层的代码

private NewsService newsService;

                        @RequestMapping("/findNewsPage.service")
                        public String showNewsInfo(Model model,HttpServletRequest request){
                            //获取当前页数
                            String pageNow=request.getParameter("pageNow");
                            //获取总页数
                            int totalCount=(int)newsService.findNewCont();
                            Page page=null;
                            List<News> list=new ArrayList<News>();
                            if (pageNow!=null) {
                                page=new Page(Integer.parseInt(pageNow), totalCount);
                                list=this.newsService.findNewsPage(page.getStartPos(),page.getPageSize());
                            }else {
                                page=new Page(1, totalCount);
                                list=this.newsService.findNewsPage(page.getStartPos(),page.getPageSize());
                            }
                            model.addAttribute("list", list);
                            model.addAttribute("page", page);
                            return "news.jsp";
                        }

页面的代码

div class="pager">
          <font size="2">共 ${page.totalPageCount} 页</font> <font size="2">第  
            ${page.pageNow} 页</font> <a href="findNewsPage.service?pageNow=1">首页</a>  
        <c:choose>  
            <c:when test="${page.pageNow - 1 > 0}">  
                <a href="findNewsPage.service?pageNow=${page.pageNow - 1}">上一页</a>  
            </c:when>  
            <c:when test="${page.pageNow - 1 <= 0}">  
                <a href="findNewsPage.service?pageNow=1">上一页</a>  
            </c:when>  
        </c:choose>  
        <c:choose>  
            <c:when test="${page.totalPageCount==0}">  
                <a href="findNewsPage.service?pageNow=${page.pageNow}">下一页</a>  
            </c:when>  
            <c:when test="${page.pageNow + 1 < page.totalPageCount}">  
                <a href="findNewsPage.service?pageNow=${page.pageNow + 1}">下一页</a>  
            </c:when>  
            <c:when test="${page.pageNow + 1 >= page.totalPageCount}">  
                <a href="findNewsPage.service?pageNow=${page.totalPageCount}">下一页</a>  
            </c:when>  
        </c:choose>  
        <c:choose>  
            <c:when test="${page.totalPageCount==0}">  
                <a href="findNewsPage.service?pageNow=${page.pageNow}">尾页</a>  
            </c:when>  
            <c:otherwise>  
                <a href="findNewsPage.service?pageNow=${page.totalPageCount}">尾页</a>  
            </c:otherwise>  
        </c:choose> 
       </div>