PageBean代码，分页

package com.tcwl.vsmp.utils;

import java.util.ArrayList;
import java.util.List;

/**
 * 分页
 * @author ChenLei
 *
 * @param <T>
 */

public class PageBean<T>
{

    /**
     * 默认第一页
     */
    private Integer pageindex = 1;

    /**
     * 默认每页十条记录
     */
    private Integer pagesize = 10;

    /**
     * // 总记录数
     */
    private Integer count;

    /**
     * // 总页数  
     */
    private Integer total;

    /**
     * // 当前页码
     */
    private Integer currentPage;

    /**
     * // 对象集合 
     */
    private List<T> list = new ArrayList<T>();
    /**
     * 是否有前一页
     */
    private boolean pre;
    /**
     * 是否有下一页
     */
    private boolean next;
    /**
     * sql
     */
    private String whereSQL;
    /**
     * 结果
     */
    private Integer resultCode;
    /**
     * 是否成功
     */
    private boolean success;

    public Integer getResultCode()
    {
        return resultCode;
    }

    public void setResultCode(Integer resultCode)
    {
        this.resultCode = resultCode;
    }

    public boolean isSuccess()
    {
        return success;
    }

    public void setSuccess(boolean success)
    {
        this.success = success;
    }

    public String getWhereSQL()
    {
        return whereSQL;
    }

    public void setWhereSQL(String whereSQL)
    {
        this.whereSQL = whereSQL;
    }

    public Integer getCurrentPage()
    {
        return currentPage;
    }

    public void setCurrentPage(Integer currentPage)
    {
        this.currentPage = currentPage;
    }

    public List<T> getList()
    {
        return list;
    }

    public void setList(List<T> list)
    {
        this.list = list;
    }

    public Integer getPageindex()
    {
        return pageindex;
    }

    public void setPageindex(Integer pageindex)
    {
        this.pageindex = pageindex;
    }

    public Integer getPagesize()
    {
        return pagesize;
    }

    public void setPagesize(Integer pagesize)
    {
        this.pagesize = pagesize;
    }

    public Integer getCount()
    {
        return count;
    }

    public void setCount(Integer count)
    {
        this.count = count;
    }

    /**
     * 得到总页数
     * @return 结果
     */
    public Integer getTotal()
    {
        total = (count % pagesize == 0) ? (count / pagesize)
                : (count / pagesize + 1);
        return total;
    }

    public void setTotal(Integer total)
    {
        this.total = total;
    }

    /**
     * 返回是否有前一页
     * @return 结果
     */
    public boolean isPre()
    {
        pre = (pageindex > 1) ? true : false;
        return pre;
    }

    public void setPre(boolean pre)
    {
        this.pre = pre;
    }

    /**
     * 是否有下一页
     * @return 结果
     */
    public boolean isNext()
    {
        next = (pageindex < this.getTotal()) ? true : false;
        return next;
    }

    public void setNext(boolean next)
    {
        this.next = next;
    }

}

    @Override
    public PageBean<LoanMakeRecord> queryLoanMakeRecordByMapNew(Map<String, Object> map) {
        PageBean<LoanMakeRecord> pageBean = new PageBean<LoanMakeRecord>();

        Integer currentPage = Integer
                .valueOf(map.get("currentPage").toString());
        Integer currentPages = (currentPage - 1) * pageBean.getPagesize();

        map.put("count", currentPages);
        map.put("pagenumber", pageBean.getPagesize());

        pageBean.setList(dao.queryLoanMakeRecordByMapNew(map));
        pageBean.setCount(dao.queryLoanMakeRecordCountByMapNew(map));
        pageBean.setCurrentPage(currentPage);
        return pageBean;
    }

 <select id="queryLoanApplyByMap" parameterType="map" resultMap="ApplyResult">
    SELECT * FROM loan_apply_table
    <where>
      <if test="start_date!=null and start_date !=''">
        create_time between #{start_date} and #{end_date}
      </if>
      <if test="name!=null and name!=''">
        and name Like CONCAT('%',#{name},'%')
      </if>
      <if test="mobile!=null and mobile!=''">
        and mobile = #{mobile}
      </if>
      <if test="company!=null and company!=''">
        and company like CONCAT('%',#{company},'%')
      </if>
      <if test="operator!=null and operator!=''">
        and operator like CONCAT('%',#{operator},'%')
      </if>
      <if test="customer_account != null and customer_account != ''">
        and customer_account = #{customer_account}
      </if>
        <if test="customer_id!=null and customer_id !=''">
           AND customer_id = #{customer_id}
        </if>
      
      <if test="status!=null">
        and status = #{status}
      </if>
      <if test="status==null">
        and
        (status = '0'
        or status = '1'
        or status = '2'
        or status = '3'
          or status = '16')
      </if>
    </where>
    ORDER BY create_time DESC
    //count=currentPages起始条数
    //pagenumber = Pagesize 显示条数
    LIMIT #{count},#{pagenumber}
  </select>

=========================================再度封装================================================

package com.tcwl.vsmp.utils;

import java.util.ArrayList;
import java.util.List;

/**
 * 分页
 * @author ChenLei
 *
 * @param <T>
 */

public class PageBean<T>
{

    /**
     * 默认第一页
     */
    private Integer pageindex = 1;

    /**
     * 默认每页十条记录
     */
    private Integer pagesize = 10;

    /**
     * // 总记录数
     */
    private Integer count;

    /**
     * // 总页数  
     */
    private Integer total;

    /**
     * // 当前页码
     */
    private Integer currentPage;

    /**
     * // 当前第几条开始显示【查询的起始条数】
     *(currentPage[当前页码] - 1) * pageBean.getPagesize()
     * 后增加的 2018-9-25
     */
    private Integer currentPages;

    /**
     * // 对象集合 
     */
    private List<T> list = new ArrayList<T>();
    /**
     * 是否有前一页
     */
    private boolean pre;
    /**
     * 是否有下一页
     */
    private boolean next;
    /**
     * sql
     */
    private String whereSQL;
    /**
     * 结果
     */
    private Integer resultCode;
    /**
     * 是否成功
     */
    private boolean success;

    public Integer getResultCode()
    {
        return resultCode;
    }

    public void setResultCode(Integer resultCode)
    {
        this.resultCode = resultCode;
    }

    public boolean isSuccess()
    {
        return success;
    }

    public void setSuccess(boolean success)
    {
        this.success = success;
    }

    public String getWhereSQL()
    {
        return whereSQL;
    }

    public void setWhereSQL(String whereSQL)
    {
        this.whereSQL = whereSQL;
    }

    public Integer getCurrentPage()
    {
        return currentPage;
    }

    public void setCurrentPage(Integer currentPage)
    {
        this.currentPage = currentPage;
        //(currentPage[当前页码] - 1) * pageBean.getPagesize()
        this.currentPages = (getCurrentPage - 1) * getPagesize();
    }

    public Integer getCurrentPages()
    {
        return currentPages;
    }
    public List<T> getList()
    {
        return list;
    }

    public void setList(List<T> list)
    {
        this.list = list;
    }

    public Integer getPageindex()
    {
        return pageindex;
    }

    public void setPageindex(Integer pageindex)
    {
        this.pageindex = pageindex;
    }

    public Integer getPagesize()
    {
        return pagesize;
    }

    public void setPagesize(Integer pagesize)
    {
        this.pagesize = pagesize;
    }

    public Integer getCount()
    {
        return count;
    }

    public void setCount(Integer count)
    {
        this.count = count;
    }

    /**
     * 得到总页数
     * @return 结果
     */
    public Integer getTotal()
    {
        total = (count % pagesize == 0) ? (count / pagesize)
                : (count / pagesize + 1);
        return total;
    }

    public void setTotal(Integer total)
    {
        this.total = total;
    }

    /**
     * 返回是否有前一页
     * @return 结果
     */
    public boolean isPre()
    {
        pre = (pageindex > 1) ? true : false;
        return pre;
    }

    public void setPre(boolean pre)
    {
        this.pre = pre;
    }

    /**
     * 是否有下一页
     * @return 结果
     */
    public boolean isNext()
    {
        next = (pageindex < this.getTotal()) ? true : false;
        return next;
    }

    public void setNext(boolean next)
    {
        this.next = next;
    }

}