mybatis加mysql分页

1.page类的书写

import java.util.List;

public class Page<T> {
    //显示的记录
    private List<T> listRecords;
    //总页数
    private int totalPage;
    //总记录数
    private int totalRecords;
    //当前页码
    private int currentPageNum;
    //每页开始的记录
    private int startIndex;
    //每页显示多少条数据
    private int pageSize=5;
    // 判断上一页
    private int upPage;
    // 判断下一页
    private int downPage;
    //判断是否有首页
    private boolean isFistPage;
    //判断是否有尾页
    private boolean isLastPage;
    //计算显示的页码
    private int startPage;
    private int endPage;

    public Page(int currentPageNum,int totalRecords){
        //当前页码，页面传过来
        this.currentPageNum=currentPageNum;
        //总记录，数据库查出来的
        this.totalRecords=totalRecords;
        //总页数
        this.totalPage=totalRecords%pageSize==0?totalRecords/pageSize:(totalRecords/pageSize)+1;
        //每页开始记录的索引
        this.startIndex=(currentPageNum-1)*pageSize;
        //计算上一页
        this.upPage = currentPageNum<=1?1:currentPageNum-1;
        //计算下一页
        this.downPage = currentPageNum>=totalPage?totalPage:currentPageNum+1;
        //判断是否有首页
        this.isFistPage = (currentPageNum>1)?true:false;
        //判断是否有尾页
        this.isLastPage = (currentPageNum<totalPage)?true:false;

        if(totalPage<5){
            startPage=1;
            endPage=totalPage;
        }else{
            startPage=currentPageNum-2;
            endPage=currentPageNum+2;
            if(startPage<1){
                startPage=1;
                endPage=startPage+4;
            }
            if(endPage>totalPage){
                endPage=totalPage;
                startPage=endPage-4;
            }
        }

    }

    public int getStartPage() {
        return startPage;
    }

    public void setStartPage(int startPage) {
        this.startPage = startPage;
    }

    public int getEndPage() {
        return endPage;
    }

    public void setEndPage(int endPage) {
        this.endPage = endPage;
    }

    public List<T> getListRecords() {
        return listRecords;
    }
    public void setListRecords(List<T> listRecords) {
        this.listRecords = listRecords;
    }
    public int getTotalPage() {
        return totalPage;
    }
    public void setTotalPage(int totalPage) {
        this.totalPage = totalPage;
    }
    public int getTotalRecords() {
        return totalRecords;
    }

    public void setTotalRecords(int totalRecords) {
        this.totalRecords = totalRecords;
    }

    public int getCurrentPageNum() {
        return currentPageNum;
    }
    public void setCurrentPageNum(int currentPageNum) {
        this.currentPageNum = currentPageNum;
    }
    public int getStartIndex() {
        return startIndex;
    }
    public void setStartIndex(int startIndex) {
        this.startIndex = startIndex;
    }
    public int getPageSize() {
        return pageSize;
    }
    public void setPageSize(int pageSize) {
        this.pageSize = pageSize;
    }

    public int getUpPage() {
        return upPage;
    }
    public void setUpPage(int upPage) {
        this.upPage = upPage;
    }

    public int getDownPage() {
        return downPage;
    }
    public void setDownPage(int downPage) {
        this.downPage = downPage;
    }

    public boolean getIsFistPage() {
        return isFistPage;
    }

    public void setIsFistPage(boolean isFistPage) {
        this.isFistPage = isFistPage;
    }

    public boolean getIsLastPage() {
        return isLastPage;
    }

    public void setIsLastPage(boolean isLastPage) {
        this.isLastPage = isLastPage;
    }

    public Page() {
        super();
    }

}

只需要用具体的实体类继承page类就行了

2.mapper.xml的书写

代码如下：

 <!-- 查询分页总数 -->
  <select id="selectCount" resultType="java.lang.Integer" parameterType="CaseDetial">
    SELECT COUNT(*) FROM casedetial 
    <where>
        <if test="cCarid!=null and cCarid!=''" >
            and c_carId like '%' #{cCarid} '%'
        </if>
        <if test="cgdwnum!=null and cgdwnum!=''">
            and cgdwnum like '%' #{cgdwnum} '%'
        </if>
    </where>
  </select>
  <!-- 查询分页数据 -->
  <select id="selectCaseDetial" resultMap="BaseResultMap" parameterType="CaseDetial">
    SELECT * FROM casedetial 
    <where>
        <if test="cCarid!=null and cCarid!=''" >
            and c_carId like '%' #{cCarid} '%'
        </if>
        <if test="cgdwnum!=null and cgdwnum!=''">
            and cgdwnum like '%' #{cgdwnum} '%'
        </if>
    </where>
    limit #{startIndex},#{pageSize}
  </select>

3.service的书写

public CaseDetial selectCaseDetial(CaseDetial caseDetial,HttpServletRequest request) {
        // TODO Auto-generated method stub
        String cgdwnum = caseDetial.getCgdwnum();
        // 处理乱码
        String carid = caseDetial.getcCarid();
        String cCarid = null;
        if (carid != null && carid != "") {
            try {
                cCarid = new String(carid.getBytes("iso-8859-1"), "utf-8");
            } catch (UnsupportedEncodingException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        caseDetial.setcCarid(cCarid);
        //处理当前页码
        int pageNum = 1;
        if (caseDetial.getCurrentPageNum() != 0) {
            pageNum = caseDetial.getCurrentPageNum();
        }
        CaseDetial cd = new CaseDetial(pageNum,caseMapper.selectCount(caseDetial));
        cd.setcCarid(cCarid);
        cd.setCgdwnum(cgdwnum);
        //查询分页数据
        List<CaseDetial> listCaseDetial = caseMapper.selectCaseDetial(cd);

        if(listCaseDetial!=null){
            cd.setListRecords(listCaseDetial);
            request.setAttribute("cgdwnum", cgdwnum);
            request.setAttribute("cCarid", cCarid);
            request.setAttribute("cd", cd);
        }
        return cd;
    }

4.jsp页面代码
①.查询时提交方法

<div class="ssanbox"> 
            <span>
             车牌号码：
             </span>
             <span>
           <input class="tablesrk" id="cCarid" type="text" value="${cCarid}" placeholder="请输入">
        </span> 
        <span>
        &nbsp;抄告单位编号：
        </span>
        <span>
           <input class="tablesrk" id="cgdwnum" type="text" value="${cgdwnum}" placeholder="请输入">&nbsp;&nbsp;
        </span>
        <span>
            <input class="btn_blue w90" type="submit"  value="搜索" onclick="sub()">
            </span>
         <script type="text/javascript">
            function sub(){
                var c=$("#cCarid").val();
                var cg=$("#cgdwnum").val();
                window.location.href="${pageContext.request.contextPath}/listCaseDetial.action?cCarid="+c+"&cgdwnum="+cg;
            }
         </script>
          </div>

②.点击页码时的提交

<script type="text/javascript">
function submitPage(obj){
var c=$("#cCarid").val();
var cg=$("#cgdwnum").val();
window.location.href="${pageContext.request.contextPath}/listCaseDetial.action?currentPageNum="+obj+"&cCarid="+c+"&cgdwnum="+cg;
}
</script>