Using the ResultSet Interface

The following must be considered when using the ResultSet interface:

  • Before reading any values, you must call next() . This returns true if there is a result, but more importantly, it prepares the row for processing.
  • You must close a ResultSet by calling close() once you have finished using it.
  • Once you make another query with the Statement used to create a ResultSet , the currently open ResultSet instance is closed automatically.