利用pagehelper进行分页查询

最近在做分页显示,利用pagehelper对后台数据进行分页,下面是代码块:

//XXX一览-分页查询所有XXX@Overridepublic EasyUIDataGridResult queryAdList(int page, int rows,Advertisement advertisement) {// 分页处理PageHelper.startPage(page, rows);// 执行查询List<Advertisement> list = iAdmanagementDao.selectAdvert(advertisement);//循环拼接高度*宽度,例如:1cm * 2cm for (Advertisement advertisement1 : list) {advertisement1.setMeasurement(advertisement1.getHeight() + "*" + advertisement1.getWidth());}// 取分页信息PageInfo<Advertisement> pageInfo = new PageInfo<Advertisement>(list);// 返回处理结果EasyUIDataGridResult result = new EasyUIDataGridResult();result.setTotal(pageInfo.getTotal());result.setRows(list);return result;}

package com.glmedia.advert.pojo;import java.util.List;/** * 分页查询 * @author zhou *  */public class EasyUIDataGridResult {    private long total;    private List<?> rows;    public long getTotal() {        return total;    }    public void setTotal(long total) {        this.total = total;    }    public List<?> getRows() {        return rows;    }    public void setRows(List<?> rows) {        this.rows = rows;    }}

其中,对于数据库的数据,采用普通查询传入相应的条件查询值,从后台查出来即可,在业务处理层,进行分页.easyuiDateGridResult为分页实体,利用pagehelper做相应的处理.