MyBatis+SpringMVC+Spring 实现分页功能

1.分页工具类

package com.dear.tmv.pojo;

public class Page {

    private int pageNow = 1; // 当前页数  
      
    private int pageSize = 4; // 每页显示记录的条数  
 
    private int totalCount; // 总的记录条数  
 
    private int totalPageCount; // 总的页数  
 
    @SuppressWarnings("unused")  
    private int startPos; // 开始位置，从0开始  
 
    @SuppressWarnings("unused")  
    private boolean hasFirst;// 是否有首页  
 
    @SuppressWarnings("unused")  
    private boolean hasPre;// 是否有前一页  
 
    @SuppressWarnings("unused")  
    private boolean hasNext;// 是否有下一页  
 
    @SuppressWarnings("unused")  
    private boolean hasLast;// 是否有最后一页  
      
    /**
     * 通过构造函数 传入  总记录数  和  当前页
     * @param totalCount
     * @param pageNow
     */  
    public Page(int totalCount, int pageNow) {  
        this.totalCount = totalCount;  
        this.pageNow = pageNow;  
    }  
      
    /**
     * 取得总页数，总页数=总记录数/总页数
     * @return
     */  
    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;  
    }  
    /**
     * 取得选择记录的初始位置
     * @return
     */  
    public int getStartPos() {  
        return (pageNow - 1) * pageSize;  
    }  
 
    public void setStartPos(int startPos) {  
        this.startPos = startPos;  
    }  
 
    /**
     * 是否是第一页
     * @return
     */  
    public boolean isHasFirst() {  
        return (pageNow == 1) ? false : true;  
    }  
 
    public void setHasFirst(boolean hasFirst) {  
        this.hasFirst = hasFirst;  
    }  
    /**
     * 是否有首页
     * @return
     */  
    public boolean isHasPre() {  
        // 如果有首页就有前一页，因为有首页就不是第一页  
        return isHasFirst() ? true : false;  
    }  
 
    public void setHasPre(boolean hasPre) {  
        this.hasPre = hasPre;  
    }  
    /**
     * 是否有下一页
     * @return
     */  
    public boolean isHasNext() {  
        // 如果有尾页就有下一页，因为有尾页表明不是最后一页  
        return isHasLast() ? true : false;  
    }  
 
    public void setHasNext(boolean hasNext) {  
        this.hasNext = hasNext;  
    }  
    /**
     * 是否有尾页
     * @return
     */  
    public boolean isHasLast() {  
        // 如果不是最后一页就有尾页  
        return (pageNow == getTotalCount()) ? false : true;  
    }  
 
    public void setHasLast(boolean hasLast) {  
        this.hasLast = hasLast;  
    }  
 
}  

2、有了这个工具类后，首先编写DeployMapper.xml配置文件中的SQL语句，如下：

<!-- 分页SQL语句 -->
<select id="selectProductsByPage" resultMap="返回值类型" >
select *
from 表名 limit #{pageSize,jdbcType=INTEGER} offset #{startPos,jdbcType=INTEGER};
</select>

<!-- 取得记录的总数 -->
<select id="getProductsCount" resultType="long">
SELECT COUNT(*) FROM 表名
</select>

此处我们可以看到，2个<select>需要分别传入2个和1个参数，此时在对应的DAO文件DeployDao中编写接口来编写对应的方法，方法名和DeployMapper.xml中的id属性值一致：

   // 取得产品数量信息
   public  long getProductsCount(); 
    // 必须使用注解方式传入多个参数
   public  List<Deploy> selectProductsByPage(@Param(value="pageSize") Integer   pageSize,@Param(value="startPos") Integer startPos); 

    接下来实现类中的方法就是要调用DAO层和接受Controller传入的参数，进行业务逻辑的处理，request用来获取前端传入的参数，model用来向JSP页面返回处理结果。(此处我省略了service层直接调用了dao层)

@RequestMapping(value = "/selectDeploy", method = RequestMethod.GET)
    public ModelAndView selectDeploy(HttpServletRequest request) {
        ModelAndView mv = new ModelAndView();
        Page page = null;
        String pageNow = request.getParameter("pageNow");  
        int totalCount = (int) deployMapper.getProductsCount();
        List<Deploy> allProducts = new ArrayList<Deploy>();  
        
        if (pageNow != null) {  
            page = new Page(totalCount, Integer.parseInt(pageNow));  
            allProducts = deployMapper.selectProductsByPage(page.getPageSize(), page.getStartPos());  
        } else {  
            page = new Page(totalCount, 1);  
            allProducts = deployMapper.selectProductsByPage(page.getPageSize(), page.getStartPos());  
        }  
        mv.addObject("products",allProducts);
        mv.addObject("page",page);
        mv.setViewName("sDeploy");
        return mv;
    }
JSP页面部分如下所示：

       <!-- 分页功能 start -->  
        <div align="center">  
            <font size="2">共 ${page.totalPageCount} 页</font> <font size="2">第  ${page.pageNow} 页</font>
            <a href="${pageContext.request.contextPath}/user/selectDeploy.do?pageNow=1">首页</a>  
            <c:choose>  
                <c:when test="${page.pageNow - 1 > 0}">  
                    <a href="${pageContext.request.contextPath}/user/selectDeploy.do?pageNow=${page.pageNow - 1}">上一页</a>  
                </c:when>  
                <c:when test="${page.pageNow - 1 <= 0}">  
                    <a href="${pageContext.request.contextPath}/user/selectDeploy.do?pageNow=1">上一页</a>  
                </c:when>  
            </c:choose>  
            <c:choose>  
                <c:when test="${page.totalPageCount==0}">  
                    <a href="${pageContext.request.contextPath}/user/selectDeploy.do?pageNow=${page.pageNow}">下一页</a>  
                </c:when>  
                <c:when test="${page.pageNow + 1 < page.totalPageCount}">  
                    <a href="${pageContext.request.contextPath}/user/selectDeploy.do?pageNow=${page.pageNow + 1}">下一页</a>  
                </c:when>  
                <c:when test="${page.pageNow + 1 >= page.totalPageCount}">  
                    <a href="${pageContext.request.contextPath}/user/selectDeploy.do?pageNow=${page.totalPageCount}">下一页</a>  
                </c:when>  
            </c:choose>  
            <c:choose>  
                <c:when test="${page.totalPageCount==0}">  
                    <a href="${pageContext.request.contextPath}/user/selectDeploy.do?pageNow=${page.pageNow}">尾页</a>  
                </c:when>  
                <c:otherwise>  
                    <a href="${pageContext.request.contextPath}/user/selectDeploy.do?pageNow=${page.totalPageCount}">尾页</a>  
                </c:otherwise>  
            </c:choose>  
        </div>  
        <!-- 分页功能 End -->