怎么解决“只进结果集不支持请求的操作”问题

来源：互联网发布：远程导出oracle数据库编辑：程序博客网时间：2024/05/21 10:30

前些天正在美工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="#" onclick="window.open('s_addapply.jsp','','width=700,height=400 top=180

left=240')">添加新的报修申请</a></center>
</body>
</html>