JDBC: ResultSet Interface


The object of ResultSet maintains a cursor pointing to a particular row of data. Initially, cursor points to before the first row.

By default, ResultSet object can be moved forward only and it is not updatable.
But we can make this object to move forward and backward direction by passing either TYPE_SCROLL_INSENSITIVE or TYPE_SCROLL_SENSITIVE in createStatement(int,int) method as well as we can make this object as updatable by:


Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);

Commonly used methods of ResultSet interface:

  1. public boolean next(): is used to move the cursor to the one row next from the current position.
  2. public boolean previous(): is used to move the cursor to the one row previous from the current position.
  3. public boolean first(): is used to move the cursor to the first row in result set object.
  4. public boolean last(): is used to move the cursor to the last row in result set object.
  5. public boolean absolute(int row): is used to move the cursor to the specified row number in the ResultSet object.
  6. public boolean relative(int row): is used to move the cursor to the relative row number in the ResultSet object, it may be positive or negative.
  7. public int getInt(int columnIndex): is used to return the data of specified column index of the current row as int.
  8. public int getInt(String columnName): is used to return the data of specified column name of the current row as int.
  9. public String getString(int columnIndex): is used to return the data of specified column index of the current row as String.
  10. public String getString(String columnName): is used to return the data of specified column name of the current row as String.

For example of ResultSet follow below links:

Learn More on JDBC

Follow below links to learn more on JDBC and solving JDBC related issues :

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s