Question - What are the types of ResultSet?
Answer -
There are 3 types in ResultSet. These are:
- TYPE_FORWARD_ONLY: It is the default option. The cursor will move from start to end.
- TYPE_SCROLL_INSENSITIVE: In this type, the cursor will move in both forward and backward directions. Dataset has the data when the SQL query returns the data.
- TYPE_SCROLL_SENSITIVE: It is the same as TYPE_SCROLL_INSENSITIVE, the difference is that it will have the updated data while iterating the resultset object.