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.
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 updateable 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:
getXXX
methods are case insensitive.
When a getXXX
method is called with a column name and several columns have the same name, the value of the first matching column will be returned.
The column name option is designed to be used when column names are used in the SQL query that generated the result set.
“Prince, what you are you are by accident of birth; what I am I am through myself. There have been and still will be thousands of princes; there is only one Beethoven.” – Ludwig van Beethoven |