关于用尽的ResultSet 的问题

Question

Connection conn = getConncetion();//获取oracle连接的方法
         ResultSet rs = null;
         PreparedStatement ps = null;
         String sql = "";
         try
         {
         sql = "select * from tablename";
    ps = conn.prepareStatement(sql);
             rs.excuteQuery(sql);
             while(rs != null && rs.next() )
             {
         String strNo = (String) rs.getObject(1);
String strName = (String) rs.getObject(2);
             }
             catch(Exception ex)
             {
                  System.out.print(ex.getMessage());
              }
              finally
              {
                      try
                      {
                           conn.close();
                           ps.close();
                           rs.close();
                       }
                       catch(Exception ex)
                       {}
               }

Answer 1

查询回来的结果集数目不对，我的表中一共有11条数据，但是在循环中只执行了两次循环就跳出了，抛出:用尽的ResultSet 的异常

Answer 2

while(rs.next() )
             {
         String strNo = rs.getString(1);
String strName = rs.getString(2);
             }
试试看