ResultSet interface

The object of ResultSet keeps up a cursor indicating a specific column of information. At first, cursor focuses to before the first column. As a matter of course, ResultSet item can be advanced just and it is not updatable.

Be that as it may, we can make this article to push ahead and in reverse passing so as to bear either TYPE_SCROLL_INSENSITIVE or TYPE_SCROLL_SENSITIVE in createStatement(int,int) strategy and in addition we can make this item as updatable by: duplicate to clipboard


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

Generally utilized routines for ResultSet interface

  • public boolean next(); is used to move the cursor to the one column next from the present position.
  • public boolean next(); is used to move the cursor to the one column next from the present position.
  • public boolean first(); is used to move the cursor to the first column in result set item.
  • public boolean last(); is used to move the cursor to the last column in result set item.
  • public boolean absolute(int row);is used to move the cursor to the predetermined line number in the ResultSet object.
  • public boolean relative(int row); is used to move the cursor to the relative column number in the ResultSet object, it might be certain or negative.
  • public int getInt(int columnIndex); is used to give back the information of determined section record of the present line as int.
  • public int getInt(String columnName); is used to give back the information of indicated segment name of the present line as int.
  • public String getString(int columnIndex); is used to give back the information of determined section list of the present line as String.
  • public String getString(String columnName): is used to give back the information of indicated section name of the present line as String.