前些天正在美工JSP页面,这就涉及到分页问题,我写了一段代码,怎么看都没错,结果运行后却报错,说“只进结果集不支持请求的操作”,如下:
javax.servlet.ServletException: 只进结果集不支持请求的操作。 org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758) org.apache.jsp.ssgl.student.s_005fapply_jsp._jspService(s_005fapply_jsp.java:178) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236) javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
不知各位能否为我想个对策,很急啊!!!!!
下面是我的JSP原代码:
<body bgcolor="#FFFFCC">
<p>
<p>
<center><h2 >已申请的报修清单</h2></center>
<table class=t1 border="1" width="500" align="center" bgcolor="#FFFFCC">
<tr align=center bgcolor="#a3cf62"><td>申请报修时间按</td><td>报修内容
</td><td>记录处理</td>
</tr>
<jsp:useBean id="connDbBean" scope="page" class="db.dbConn"/>
<%
int PageSize=8;
int Page=1;
int totalPage=1;
int totalRecord=0;
request.setCharacterEncoding("gb2312");
String id=(String)session.getAttribute("id");
String dept=(String)session.getAttribute("dept");
ResultSet rs=connDbBean.executeQuery("select * from apply where
id="+id+"");
if(rs==null)
{
out.print("<p>");
out.print("<center><font size='4' color='red'>对不起,您还未添加任
何报修信息!</font></center>");
}
else
if(rs.next())
{
rs.last();
totalRecord=rs.getRow();
rs.first();
}
if(totalRecord%PageSize==0)
{
totalPage=totalRecord/PageSize;
}
else
{
totalPage=(int)Math.floor(totalRecord/PageSize)+1;
}
if(totalPage==0)
{
totalPage=1;
}
if(request.getParameter("Page")==null || request.getParameter
("Page").equals(""))
{
Page=1;
}
else
try{
Page=Integer.parseInt(request.getParameter("Page"));
}
catch(java.lang.NumberFormatException e)
{
Page=1;
}
if(Page<1) Page=1;
if(Page>totalPage) Page=totalPage;
rs.absolute((Page-1) * PageSize+ 1);
for(int iPage=1;iPage<=PageSize;iPage++)
{
out.print("<tr align=center><td
width=200>"+rs.getString("time")+"</td><td width=100><a href=/"#/"
onClick=/"window.open('s_applydetail.jsp?detail="+rs.getString("detail")
+"','','width=700,height=400 top=180 left=240')/">"+rs.getString("detail")
+"</a></td><td width=110 align=/"center/"><a href=/"s_delapply.jsp?
detail="+rs.getString("detail")+"/">删 除</a></td></tr>");
}
%>
<p>
</table>
<center>
<p>
<FORM action="s_apply.jsp" Method="post">
<%
if(Page!=1)
{
out.print(" <a href=s_apply.jsp?Page=1>首 页</a>");
out.print(" <a href=s_apply.jsp?Page="+(Page-1)+">上一页</a>");
}
if(Page!=totalPage)
{
out.print(" <a href=s_apply.jsp?Page="+(Page+1)+">下一页</a>");
out.print(" <a href=s_apply.jsp?Page="+totalPage+">末 页</a>");
}
%>
<br>
跳转到:<input type="text" name="Page" size=3>页数:<font color="red"><%
=Page%>/<%=totalPage%></font>
<p>
<a href="#" οnclick="window.open('s_addapply.jsp','','width=700,height=400 top=180
left=240')">添加新的报修申请</a></center>
</body>
</html>