新手尝试使用Java ArrayList存储从数据库获得的ResultSet

您可能想要首先定义一个HRPerson，如下所示：

public class HRPerson {    public String firstName;    public String lastName;    public String email;    public int salary;}

然后您的主要代码如下所示：

query = "SELECt first_name, last_name, email, salary FROM HR.Employees where rownum < 6";rset = stmt.executeQuery(query);List<HRPerson> returnHRdata = new ArrayList<HRPerson>();while (rset.next()) {   HRPerson person = new HRPerson();   person.firstName = rset.getString("first_name");   person.lastName  = rset.getString("last_name");   person.email     = rset.getString("email");   person.salary    = rset.getInt("salary");   returnHRdata.add(person);}