日期:2014-05-17  浏览次数:20665 次

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();