Java Training: - Mention different types of resultset?

Published on by javainterviewseries

“ResultSet” is an object that contains the results of SQL query. That means it contains the rows that satisfy the conditions of the query.

 

There are three basic types of resultsets:-

 

Forward-only results set


These types of resultset are non-scrollable and moves only forward.

 

Scroll-insensitive set


Resultset is scrollable so the cursor can move forward, backward, to a particular row etc.

While the resultset is open it does not show any changes done to the underlying database.

 

Scroll-sensitive set


Resultset is scrollable so the cursor can move forward, backward, to a particular row etc.

Resultset is sensitive to changes when it is open or used. That means if any values are modified in the database it’s propagated to the resultset.

 

See the following video on Factory Pattern in Java: -

 

 

Click to get Java Training

 

Regards,

 

Get more Java Training from author’s blog

To be informed of the latest articles, subscribe:
Comment on this post