J2EE™ and Beyond: Design, Develop, and Deploy World-Class Java™ Software

The ResultSet Class

The ResultSet class encapsulates the rows or tuples resulting from the execution of a SQL select query. Originally, in the early releases of the JDBC API, the ResultSet class allowed only for the serial progression through a set of results, from the first to the last. Random movement through the results was not allowed. Additionally, data in the ResultSet could only be read; updates through the ResultSet were not allowed.

With the JDBC 2.0 optional extensions, additional capabilities were added to the ResultSet specification, which allow results to be reviewed in a random order. This is referred to as a scrollable ResultSet or scrollable cursor. Later JDBC releases also added the capability to perform updates through ResultSets ...