1 Action 文件:request.setAttribute("business", pManager.findByPage(comname,id,stationId,mainForm));
2 manager文件:
public List findByPage(String comnameSer,String id,String stationId,PForm form) {
List result = pDAO.findByPage(comnameSer,form.getPage(),stationId,id);
int count = pDAO.getRecordCount(stationId,id);
form.setRecordNum(count);
int totalPage = (count != 0 && count % form.getPageRowNum() == 0) ?
(count / form.getPageRowNum()) : (count / form.getPageRowNum() + 1);
form.setTotal(totalPage);
if (form.getPage() < 1) {
form.setPage(1);
}
if (form.getPage() > totalPage) {
form.setPage(totalPage);
}
return result;
}
3: Dao文件:
public List findByPage(String name,int pageNum,String stationId,String id) {
try {
DetachedCriteria detachedCriteria = DetachedCriteria.forClass(P.class);
Criteria criteriaQuery = detachedCriteria.getExecutableCriteria(this.getSession());
criteriaQuery.addOrder(Order.asc(NAME));
if(!"".equals(stationId) && "".equals(id)){
criteriaQuery.add(Expression.eq("stationId", stationId));
}
return this.getHibernateTemplate().findByCriteria(detachedCriteria, (pageNum-1) * 10, 10);
} catch (RuntimeException re) {
log.error("findByPage failed", re);
throw re;
}
}
public int getRecordCount(String stationId,String id) {
try {
DetachedCriteria detachedCriteria = DetachedCriteria.forClass(P.class);
Criteria criteriaQuery = detachedCriteria.getExecutableCriteria(this.getSession());
if(!"".equals(stationId) && "".equals(id)){
criteriaQuery.add(Expression.eq("stationId", stationId));
}
return this.getHibernateTemplate().findByCriteria(detachedCriteria).size();
} catch (RuntimeException re) {
log.error("findByPage failed", re);
throw re;
}
}