JSP数据分页报After end of result set错误

Java code

<%                ResultSet rs = null;                Connection con=null;                java.sql.Statement state =null;                request.setCharacterEncoding("utf-8");                String list = request.getParameter("list");                String value = request.getParameter("value");                String sql = "";                if (list.equals("all")) {                    sql = "select * from product";                }else if(list==null){                    response.sendRedirect("index.jsp");                }                else {                    sql = "select * from product where " + list + "= '" + value + "'";                }                 String Db_user="root";    String user_password="hythzx";    String port="3307";    String Datebase="ebook";                  try {            Class.forName("com.mysql.jdbc.Driver");        } catch (ClassNotFoundException ex) {        }        try {            con=DriverManager.getConnection("jdbc:mysql://localhost:"+port+"/"+Datebase+"??useUnicode=true&characterEncoding=UTF-8", Db_user, user_password);            state = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);             rs = state.executeQuery(sql);                     } catch (SQLException ex) {        }                                               //在这里判断结果集的个数                rs.last();                int row=rs.getRow();                int maxpage=(row%10==0)?(row/10):(row/10+1);                String nowpage=(String)request.getParameter("nowpage");                int nowpage_int=1;                 if(nowpage==null){                                    }                               else{                    nowpage_int=Integer.valueOf(nowpage)+1;                               }                rs.absolute((nowpage_int-1)*10+1);                out.println("nowpage_int="+nowpage_int);                for(int i=0;i<10;i++){                    out.print("<tr>");                    out.print("<td>" + rs.getString(list_name[0]) + "</td>");                    out.print("<td>" + rs.getString(list_name[1]) + "</td>");                    out.print("<td>" + rs.getString(list_name[2]) + "</td>");                    out.print("<td>" + rs.getFloat(list_name[3]) + "</td>");                    out.print("<td>" + rs.getInt(list_name[4]) + "</td>");                    out.print("<td>" + rs.getString(list_name[5]) + "</td>");                    out.print("<td>" + rs.getString(list_name[6]) + "</td>");            %><td><input type="button" value="加入购物车" onclick="do_cart('cart.jsp','<%=rs.getInt("Id")%>')"></td>            <td><input type="button" value="查看详情" onclick="do_cart('show.jsp','<%=rs.getInt("Id")%>')"></td>                <%                try{                    if(!rs.next())                        break;                }                catch(Exception e){                                    }                        out.print("</tr>");                    }                rs.close();                state.close();                con.close();                %>        </table><br><br>        <table width="249" border="1" align="center">          <tr>              <td width="90">当前页：<%=nowpage_int%>/<%=maxpage%></td>              <td width="61"><a href="put_result.jsp?nowpage=<%=nowpage_int-1%>&value=<%=value%>&list=<%=list%>" class="mydiv">上一页</a></td>            <td width="60"><a href="put_result.jsp?nowpage=<%=nowpage_int+1%>&value=<%=value%>&list=<%=list%>">下一页</a></td>          </tr>        </table> 
 

[解决办法]
大量的代码不妨放到Servlet中去，这样你就能知道到底是哪行报错的。
是rs.last还是rs.absolute，
前者可能是查回来没记录。后者可能是算出来的记录编号算错了超出表大小了。