Why does the data from the ResultSet disappear after the JDBC connection is closed?

Question

Java

There are connections - connection.
var statement=connection.createStatement();
var resultSet=statement.executeQuery(query);
resultSet.next()// will be true here;
statement.close();
resultSet.next()// here it will be false
I need to pass the data in the ResultSet format further, but connections can already be closed, why keep it open.

Answer 1

Because it will also be closed.
https://docs.oracle.com/javase/8/docs/api/java/sql...

Answer 2

As you wrote in the comment to map on the object. If you don't understand the structure of the . map to an array map ( row, column \ value) array = number of selected rows.