Slide 14.29: Executing a query
  Slide 14.31: Closing the result set and statement objects
  Home


Processing the Result Set


A table of data representing a database result set, which is usually generated by executing a statement that queries the database. A ResultSet object maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The next method moves the cursor to the next row, and because it returns false when there are no more rows in the ResultSet object, it can be used in a while loop to iterate through the result set.

For example, the following code will iterate through the ResultSet object rset and will retrieve and print each entry of the first column, which is a string:
  while ( rset.next( ) )
    System.out.println( rset.getString( 1 ) );
A default ResultSet object is not updatable and has a cursor that moves forward only. The ResultSet interface provides getXXX methods for retrieving column values from the current row. Values can be retrieved using either one of the following two methods: