最近在做分页显示,利用pagehelper对后台数据进行分页,下面是代码块:
//XXX一览-分页查询所有XXX
@Override
public 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做相应的处理.