先记录一下,有时间整理
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" style="font-size:12px; line-height:25px">
<tr bgcolor="#8CC864" >
<td width="61" align="center" bgcolor="#8CC864" class="td-right" >序号</td>
<td width="270" align="center" class="td-right" >排污单位名称</td>
<td width="228" align="center" class="td-right" >存在问题及分析</td>
<td width="196" align="center" class="td-right" >处理及落实情况</td>
</tr>
<c:choose>
<c:when test="${not empty list}">
<c:forEach var="bean" items="${list}" varStatus="status">
<tr bgcolor="#cccccc">
<td align="center" bgcolor="#cccccc" class="td-left">${status.count}</td>
<td align="left" class="td-left" >${bean.dwmc }</td>
<td align="left" bgcolor="#cccccc" class="td-left" >${bean.czwtjfx }</td>
<td align="center" bgcolor="#cccccc" class="td-left" >${bean.cljlsqk }</td>
</tr>
</c:forEach>
</c:when>
<c:otherwise>
<tr bgcolor="#cccccc">
<td colspan="4" align="center" bgcolor="#cccccc" class="td-left">暂无数据</td>
</tr>
</c:otherwise>
</c:choose>
<tr bgcolor="#cccccc">
<td bgcolor="#8CC864" colspan="4" align="center">第${pageNo }页 共${pageCount }页
<a href="<%=path %>/jkqk.do?method=queryAll&pageNo=1">首页</a>
<a href="<%=path %>/jkqk.do?method=queryAll&pageNo=${pageNo-1 }">上一页</a>
<a href="<%=path %>/jkqk.do?method=queryAll&pageNo=${pageNo+1 }">下一页</a>
<a href="<%=path %>/jkqk.do?method=queryAll&pageNo=${pageCount }">尾页</a>
</td>
</tr>
</table>
应该单写一个分页类里
//默认每页显示10条记录
public static final int pageSize = 10;
public ActionForward queryAll(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response){
String dwmc = Common.nullToString(request.getParameter("dwmc"));
String whrq = Common.nullToString(request.getParameter("whrq"));
//总记录数
int dataCount = dao.getDataCount();
//总页数
int pageCount = dao.getPageCount(dataCount, pageSize);
//第一次登陆,显示第一页
int pageNo = 1;
String pageNoStr = request.getParameter("pageNo");
if(pageNoStr == null || "".equals(pageNoStr.trim())){
pageNo = 1;
}
try {
pageNo = Integer.parseInt(pageNoStr);
} catch (NumberFormatException e) {
pageNo = 1;
}
if(pageNo > pageCount){
pageNo = pageCount;
}else if(pageNo < 1){
pageNo = 1;
}
request.setAttribute("pageCount", pageCount);
request.setAttribute("pageNo", pageNo);
request.setAttribute("list", dao.queryAll(dwmc, whrq, pageNo, pageSize));
return mapping.findForward("queryAll");
}
HQL需整理一下
public List<MonitorOperationrecord> queryAll(String dwmc, String whrq,
int pageNo, int pageSize) {
String hql = "";
List list = new ArrayList();
if(whrq != null && !"".equals(whrq)){
hql = "From MonitorOperationrecord m where 1=1 and m.dwmc like ? and m.whrq = to_date('"+whrq+"','yyyy-MM-dd') order by m.id desc";
list = c.getSession().createQuery(hql)
.setParameter(0, "%"+dwmc+"%")
.setFirstResult(pageNo)
.setMaxResults(pageSize)
.list();
}else{
hql = "From MonitorOperationrecord m where 1=1 and m.dwmc like ? order by m.id desc";
list = c.getSession().createQuery(hql)
.setParameter(0, "%"+dwmc+"%")
.setFirstResult(pageNo)
.setMaxResults(pageSize)
.list();
}
return list;
}
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" style="font-size:12px; line-height:25px">
<tr bgcolor="#8CC864" >
<td width="61" align="center" bgcolor="#8CC864" class="td-right" >序号</td>
<td width="270" align="center" class="td-right" >排污单位名称</td>
<td width="228" align="center" class="td-right" >存在问题及分析</td>
<td width="196" align="center" class="td-right" >处理及落实情况</td>
</tr>
<c:choose>
<c:when test="${not empty list}">
<c:forEach var="bean" items="${list}" varStatus="status">
<tr bgcolor="#cccccc">
<td align="center" bgcolor="#cccccc" class="td-left">${status.count}</td>
<td align="left" class="td-left" >${bean.dwmc }</td>
<td align="left" bgcolor="#cccccc" class="td-left" >${bean.czwtjfx }</td>
<td align="center" bgcolor="#cccccc" class="td-left" >${bean.cljlsqk }</td>
</tr>
</c:forEach>
</c:when>
<c:otherwise>
<tr bgcolor="#cccccc">
<td colspan="4" align="center" bgcolor="#cccccc" class="td-left">暂无数据</td>
</tr>
</c:otherwise>
</c:choose>
<tr bgcolor="#cccccc">
<td bgcolor="#8CC864" colspan="4" align="center">第${pageNo }页 共${pageCount }页
<a href="<%=path %>/jkqk.do?method=queryAll&pageNo=1">首页</a>
<a href="<%=path %>/jkqk.do?method=queryAll&pageNo=${pageNo-1 }">上一页</a>
<a href="<%=path %>/jkqk.do?method=queryAll&pageNo=${pageNo+1 }">下一页</a>
<a href="<%=path %>/jkqk.do?method=queryAll&pageNo=${pageCount }">尾页</a>
</td>
</tr>
</table>
应该单写一个分页类里
//默认每页显示10条记录
public static final int pageSize = 10;
public ActionForward queryAll(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response){
String dwmc = Common.nullToString(request.getParameter("dwmc"));
String whrq = Common.nullToString(request.getParameter("whrq"));
//总记录数
int dataCount = dao.getDataCount();
//总页数
int pageCount = dao.getPageCount(dataCount, pageSize);
//第一次登陆,显示第一页
int pageNo = 1;
String pageNoStr = request.getParameter("pageNo");
if(pageNoStr == null || "".equals(pageNoStr.trim())){
pageNo = 1;
}
try {
pageNo = Integer.parseInt(pageNoStr);
} catch (NumberFormatException e) {
pageNo = 1;
}
if(pageNo > pageCount){
pageNo = pageCount;
}else if(pageNo < 1){
pageNo = 1;
}
request.setAttribute("pageCount", pageCount);
request.setAttribute("pageNo", pageNo);
request.setAttribute("list", dao.queryAll(dwmc, whrq, pageNo, pageSize));
return mapping.findForward("queryAll");
}
HQL需整理一下
public List<MonitorOperationrecord> queryAll(String dwmc, String whrq,
int pageNo, int pageSize) {
String hql = "";
List list = new ArrayList();
if(whrq != null && !"".equals(whrq)){
hql = "From MonitorOperationrecord m where 1=1 and m.dwmc like ? and m.whrq = to_date('"+whrq+"','yyyy-MM-dd') order by m.id desc";
list = c.getSession().createQuery(hql)
.setParameter(0, "%"+dwmc+"%")
.setFirstResult(pageNo)
.setMaxResults(pageSize)
.list();
}else{
hql = "From MonitorOperationrecord m where 1=1 and m.dwmc like ? order by m.id desc";
list = c.getSession().createQuery(hql)
.setParameter(0, "%"+dwmc+"%")
.setFirstResult(pageNo)
.setMaxResults(pageSize)
.list();
}
return list;
}