how to retrieve each row by make each columns as objects ?

[Nakata kokuyo]

hi, good day, say for example if the resultSet return 2 rows of records

row 1 : name1, age1
row 2 : name2, age2

is it possible we can make it save to object for each columns ?
for example , name1 in one object, age1 as another object also for other as well and each row columns then save into List

can we do that ? thank you for your guidance

[Maximilian Xavier Stocker]

Yes.

ArrayList rows = new ArrayList();
while(rs.next()){
  ArrayList cols = new ArrayList();
  // get each column and add it to cols example below
  cols.add(rs.getObject(1));
  //add each row (made up of columns) to rows
  rows.add(cols);  
}