what are the types of resultsets

TYPE_FORWARD_ONLY
The result set is nonscrollable; its cursor moves forward only, from top to bottom.
The view of the data in the result set depends on whether the DBMS materializes results incrementally.

TYPE_SCROLL_INSENSITIVE
The result set is scrollable: Its cursor can move forward or backward and can be moved to a particular row or to a row whose position is relative to its current position.
The result set generally does not show changes to the underlying database that are made while it is open. The membership, order, and column values of rows are typically fixed when the result set is created.

TYPE_SCROLL_SENSITIVE
The result set is scrollable; its cursor can move forward or backward and can be moved to a particular row or to a row whose position is relative to its current position.
The result set is sensitive to changes made while it is open. If the underlying column values are modified, the new values are visible, thus providing a dynamic view of the underlying data. The membership and ordering of rows in the result set may be fixed or not, depending on the implementation

SOURCE : www.referjava.com