SE452: JDBC: ResultSets [9/12]

The ResultSet class

• A table of data representing a database result set.
• Maintains a cursor pointing to its current row of data.
• boolean next()
• Moves the cursor down one row from its current position. Initially the cursor is positioned before the first row. The first call to the method next makes the first row the current row. Returns false if there are no more rows.

When processing ResultSets, you will often see code like this:

    while (rs.next()) {
            // do something with row
    }
    

For the current row, can get data by using

    Type getType(int index)
    Type getType(String name)