<%
String table="t_sys_sector";//设置所要查询的表名
String pages=request.getParameter("pages"); //接收当前是第几页
String httpFile="sector.jsp";//设置处理请求的JSP文件
String cif=request.getParameter("cif");//保存查询字段
userPage.setCif(cif);if(pages==null||pages.equals("null")){
pages="0";
}
userPage.setQuerySql(httpFile,pages,table);
//int Page=userPage.getCurPage(),pagesize=userPage.getPageSize();
String str_parameter="&cif="+userPage.getCif();
userPage.setStr_parameter(str_parameter);
%><%while(rs.next()){
//定义整型变量i用来将记录指针定位到待显示页的第一条记录上
if(i>(Page-1)*pagesize-1){
……//循环体
}
i++;
}
%>
<!--读取分页拦-->
<%=qu.pageFooter()%>
public String pageFooter(){
String str = "<form action=" + httpFile + " name=formBean methord=post>";
int prev = curPage- 1;//向前翻页,即当前页减1
int next = curPage +1;//向后翻页,即当前页加1
if(curPage > 1)
str = str + " <A href=" + httpFile + "?pages=1" + str_parameter + ">首页</A> ";
else
str = str + " 首页 ";
if(curPage > 1)
str = str + " <A href=" + httpFile + "?pages=" + prev + str_parameter + ">上一页</A> ";
else
str = str + " 上一页 ";
if(curPage < maxPage)
str = str + " <A href=" + httpFile + "?pages=" + next + str_parameter + ">下一页</A> ";
else
str = str + " 下一页 ";
if(maxPage > 1 && curPage!= maxPage)
str = str + " <A href=" + httpFile + "?pages=" + maxPage + str_parameter + ">尾页</A>";
else
str = str + " 尾页 </font> ";
//在页面跳转间设置隐藏表单,来保存不同的请求
str = str + "</form>";
return str;
}现在的问题是想改成标签来显示,也将rs放在list里存在session 【infolist中】了。不知道这个循环体怎样改才好 .主要还是 按 下一页 时候,在标签里怎样 将记录指针定位到待显示页的第一条记录上!
String table="t_sys_sector";//设置所要查询的表名
String pages=request.getParameter("pages"); //接收当前是第几页
String httpFile="sector.jsp";//设置处理请求的JSP文件
String cif=request.getParameter("cif");//保存查询字段
userPage.setCif(cif);if(pages==null||pages.equals("null")){
pages="0";
}
userPage.setQuerySql(httpFile,pages,table);
//int Page=userPage.getCurPage(),pagesize=userPage.getPageSize();
String str_parameter="&cif="+userPage.getCif();
userPage.setStr_parameter(str_parameter);
%><%while(rs.next()){
//定义整型变量i用来将记录指针定位到待显示页的第一条记录上
if(i>(Page-1)*pagesize-1){
……//循环体
}
i++;
}
%>
<!--读取分页拦-->
<%=qu.pageFooter()%>
public String pageFooter(){
String str = "<form action=" + httpFile + " name=formBean methord=post>";
int prev = curPage- 1;//向前翻页,即当前页减1
int next = curPage +1;//向后翻页,即当前页加1
if(curPage > 1)
str = str + " <A href=" + httpFile + "?pages=1" + str_parameter + ">首页</A> ";
else
str = str + " 首页 ";
if(curPage > 1)
str = str + " <A href=" + httpFile + "?pages=" + prev + str_parameter + ">上一页</A> ";
else
str = str + " 上一页 ";
if(curPage < maxPage)
str = str + " <A href=" + httpFile + "?pages=" + next + str_parameter + ">下一页</A> ";
else
str = str + " 下一页 ";
if(maxPage > 1 && curPage!= maxPage)
str = str + " <A href=" + httpFile + "?pages=" + maxPage + str_parameter + ">尾页</A>";
else
str = str + " 尾页 </font> ";
//在页面跳转间设置隐藏表单,来保存不同的请求
str = str + "</form>";
return str;
}现在的问题是想改成标签来显示,也将rs放在list里存在session 【infolist中】了。不知道这个循环体怎样改才好 .主要还是 按 下一页 时候,在标签里怎样 将记录指针定位到待显示页的第一条记录上!
<c:forEach items="${sessionScope.sectorInfo}" var="sector" varStatus="varStatus">
<html:form method='post' action='/updateSector?ToUpdateId=${sector.sectorId}'>
<c:if test="${varStatus.count}"></c:if>
<tr class=titletdbg><td align='center'><c:out value="${sector['sectorId']}"/></td>
<td align='center'>
<input type='text' name='Name' size='18' value="<c:out value="${sector['sectorName']}"/>"></td>
<td align='center'>
<input type='text' name='Tel' size='15' value="<c:out value="${sector['sectorTel']}"/>"></td>
<td align='center'>
<input type='text' name='Fax' size='15' value="<c:out value="${sector['sectorFax']}"/>"></td>
<td align='center'>
<input type='text' name='Sort' size='4' value="<c:out value="${sector['sectorSort']}"/>"></td><td align='center'>
<html:submit>修改</html:submit>
</td>
</tr></html:form></c:forEach>
<!--读取分页拦-->
<%=userPage.pageFooter()%>
</table>