Result Sets can be Scrollable

New in JDBC 2.0 is that the statement can be given one of the scrollable constants:Statement stmt = conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);

Scrolling can also be insensitive depending on whether you plan to make changes to the Result Set. You can update, insert and delete rows into the result set and it will take place back in the database.

A scrollable Result Set, in addition to the method “rs.next”, also has a method “rs.previous” to go back rows. You can set the cursor at the end with “rs.afterLast”, and you can move the cursor to particular row numbers with “rs.absolute(int)”.

New in JDBC 2.0 is that the statement can be given one of the scrollable constants: Statement stmt = conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);