ResultSet
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.
next()
You must close a ResultSet by calling close() once you have finished using it.
close()
Once you make another query with the Statement used to create a ResultSet, the currently open ResultSet instance is closed automatically.
Statement