i need to store the following values in an array as i loop through a mysql table retrieving them. how would i enter them in an array if there was more than one person in the table?
ResultSet rs = stmt.executeQuery("SELECT fName,lName FROM register");
String name = "";
String surname = "";
name = rs.getString(1);
surname = rs.getString(2);