java吧 关注:1,304,540贴子:12,868,350
  • 1回复贴,共1

Invalid operation for the current cursor position. ?怎么解决?

只看楼主收藏回复

String strSel1="select newsid,newscontent,picpath from newsInfo where newskindid='"+newskindid+"'";
               out.println(strSel1);
               out.println("</br>");
               Statement stmt1=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
               ResultSet rs1=stmt1.executeQuery(strSel1);
               out.println(rs.next());
               for(int j=1;j<=1;j++)
               {            
                  newsid=rs1.getInt("newsid");
                  newscontent=rs1.getString("newscontent");
                  picpath=rs1.getString("picpath");
              }
这样写 不对吗? 


IP属地:北京1楼2010-12-20 19:13回复
    String strSel1="select newsid,newscontent,picpath from newsInfo where newskindid='"+newskindid+"'";
                   out.println(strSel1);
                   out.println("</br>");
                   Statement stmt1=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
                   ResultSet rs1=stmt1.executeQuery(strSel1);
                   while(rs1.next());
                   {            
                      newsid=rs1.getInt("newsid");
                      newscontent=rs1.getString("newscontent");
                      picpath=rs1.getString("picpath");
                  }


    2楼2010-12-21 07:51
    回复