jsp列表页面from表单引入分页页面后,点击分页属性,触发请求例如
<s:form action="store_list" method="post" name="from1">
在storeAction中定义属性:
public Integer pageNum = 1;//当前页
public Integer pageCount = 10;//每页显示数
public Integer count ;//总记录数
public Integer maxPageNum;//最大页数
//门店列表
public String list(){
count = storeEbi.getCount(sqm);//获取总记录数
maxPageNum = (count + pageCount-1)/pageCount;
List<StoreModel> storeList = storeEbi.getAll(sqm,pageNum,pageCount);
ActionContext.getContext().put("storeList", storeList);
return "storeSuccess";
}
//获取总记录数
public Integer getCount(StoreQueryModel sqm) {
DetachedCriteria criteria = DetachedCriteria.forClass(StoreModel.class);
criteria.setProjection(Projections.rowCount());
if(sqm.getStoreName()!=null && sqm.getStoreName().trim().length()>0){
criteria.add(Restrictions.like("storeName", "%"+sqm.getStoreName()+"%"));//模糊查询条件
}
if(sqm.getStoreNo()!=null && sqm.getStoreNo().trim().length()>0){//其它查询条件
criteria.add(Restrictions.eq("storeNo", sqm.getStoreNo()));
}
List<Long> list = this.getHibernateTemplate().findByCriteria(criteria);
return list.get(0).intValue();//根据条件查询总记录数
}
//根据当前页,每页显示数查询数据放入集合,可通过session传前端页面即可用<s:iterator value="storeList">遍历出数据
public List<StoreModel> getAll(StoreQueryModel sqm, Integer pageNum,
Integer pageCount) {
DetachedCriteria criteria = DetachedCriteria.forClass(StoreModel.class);
if(sqm.getStoreName()!=null && sqm.getStoreName().trim().length()>0){
criteria.add(Restrictions.like("storeName", "%"+sqm.getStoreName()+"%"));
}
if(sqm.getStoreNo()!=null && sqm.getStoreNo().trim().length()>0){
criteria.add(Restrictions.eq("storeNo", sqm.getStoreNo()));
}
List<StoreModel> list = this.getHibernateTemplate().findByCriteria(criteria, (pageNum-1)*pageCount,pageCount);
return list;
}