Using the ResultSet Interface
The following must be considered when using the
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
close()once you have finished using it.
Once you make another query with the
Statementused to create a
ResultSet, the currently open
ResultSetinstance is closed automatically.