What are types of ResultSet?

1.	What are types of ResultSet?
Answer» There are three constants which when defined in result set can move cursor in resultset backward, forward and also in a particular row. ResultSet.TYPE_FORWARD_ONLY − The cursor can only move forward in the result set. ResultSet.TYPE_SCROLL_INSENSITIVE − The cursor can scroll forwards and backwards, and the result set is not sensitive to changes made by others to the database that occur after the result set was created. ResultSet.TYPE_SCROLL_SENSITIVE − The cursor can scroll forwards and backwards, and the result set is sensitive to changes made by others to the database that occur after the result set was created.

Answer»

There are three constants which when defined in result set can move cursor in resultset backward, forward and also in a particular row.

ResultSet.TYPE_FORWARD_ONLY − The cursor can only move forward in the result set.
ResultSet.TYPE_SCROLL_INSENSITIVE − The cursor can scroll forwards and backwards, and the result set is not sensitive to changes made by others to the database that occur after the result set was created.
ResultSet.TYPE_SCROLL_SENSITIVE − The cursor can scroll forwards and backwards, and the result set is sensitive to changes made by others to the database that occur after the result set was created.

Discussion