后台hibernate分页代码:
Page pages = new MyPage(5);
int pageNo;
if (request.getParameter("pageNo") == null) {
pageNo = 1;
} else {
pageNo = Integer.parseInt(request.getParameter("pageNo"));
}
pages.setPageNo(pageNo);
pages.setPageSize(5);
String key = request.getParameter("key");
model.addAttribute("key", key);
String type = request.getParameter("type");
model.addAttribute("type", type);
String sql = "select c.caseno,c.caseapplicant,c.servname,c.deptsimplename,c.casepromisedate,c.casestatus,"
- "case when c.casestatus not in ('办结','发证','不予许可','退件','已发证') then 1 "
- "when (select count(a.id) from t_appraise a where a.caseno=c.caseno) > 0 then 2 "
- "else 3 end from t_casebaseinfo c " + "where 1=1 "; if (StringUtils.isNotBlank(areacode)) { sql += "and c.area_code = '" + areacode + "'"; } if (StringUtils.isNotBlank(key)) { sql += " and (c.caseno = '" + key.trim() + "' or c.caseapplicant like '%"
- key.trim() + "%')"; }else { sql += " and c.caseno = '默认不显示办件数据'"; } sql += " order by c.caseid desc" ; System.out.println(sql); List ns = new ArrayList(); Query query = null; int totalItems = 0; query = CasebaseService.createSQLQuery(sql); totalItems = query.list().size(); ns = query .setFirstResult((pages.getPageNo() - 1) * pages.getPageSize()) .setMaxResults(pages.getPageSize()).list(); pages.setResult(ns); pages.setTotalItems(totalItems); model.addAttribute("totalItems", totalItems); model.addAttribute("pages", pages);
前台分页部分代码:
onclick="javascript:return false;">上一页
/c:if
class="page-prev">上一页
/c:if
var="num">
href="${ctx }/casebase/casebase.do?method=search&areacode=${areacode }&key=${key }&type=${type }&pageNo=${num}"
${pages.pageNo==num? 'class="current"':'' }>${num }
/c:forEach
href="${ctx }/casebase/casebase.do?method=search&areacode=${areacode }&key=${key }&type=${type }&pageNo=${pages.totalPages}"
class="page-next">下一页
/c:if
onclick="javascript:return false;">下一页
/c:if