JDBC how to get all records in a single object?

Question

JDBC how to get all records in a single object?

JDBC how to get all records in a single object?
let's say I'm taking all I need from the database like this (query is a variable with the SQL query)
ResultSet rs = st.executeQuery(query);
but to build up every time here's a design I don't want

while (rs.next()) {
System.out.println(rs.getString("id"));
System.out.println(rs.getString("name"));
 }

because you never know how many times I need them.
you can pick them up for example in the form of the array of objects, or in any other more s-cook form ?
PS if not, please fikalii not to throw, because with java-oops just getting started

loren_Grimes asked July 9th 19 at 11:27

Related questions

More answers about "JDBC how to get all records in a single object?"

2 answers

bailee_Stant answered on July 9th 19 at 11:31

Well, apparently it is necessary to make array and record all the data cycle, then anywhere use.

good idea, but as far as I know, you first need to reserve it for the memory, and how to reserve memory for something whose size you don't know? - loren_Grimes commented on July 9th 19 at 11:34

Aglae_Wiso answered on · Accepted Answer · 2019-07-09T11:29:46.144Z

Made myself this way:

private ArrayList<hashmap<string, object>> resultSetToArrayList(ResultSet rs) throws SQLException {
 ResultSetMetaData md = rs.getMetaData();
 int columns = md.getColumnCount();
 ArrayList<hashmap<string, object>> list = new ArrayList<>();
 while (rs.next()) {
 HashMap<string, object> row = new HashMap<>(columns);
 for (int i = 1; i <= columns; ++i) {
 row.put(md.getColumnName(i), rs.getObject(i));
}
list.add(row);
}
 return list;
 }</string></hashmap<string,></hashmap<string,>

ArrayList<hashmap<string, object>> list = resultSetToArrayList(rs);
 for (HashMap<string, object> row : list) {
System.out.println(row.get("id"));
System.out.println(row.get("name"));
 }</string></hashmap<string,>