java - 结果集到数组

Question

我有一个使用查询返回的结果集:

String query = "select Bookname, SubjectName from books join Subjects on Subjects.SubjectID = Books.subjectID where classID = '1a'";
ResultSet temp = null;
try
{
   Statement st = conn.createStatement();
   ResultSet rs = st.executeQuery(query);

   temp = rs;
}

我只是想知道是否可以将 Resultset 变成两个单独的数组:例如 BookName[] 和 BookSubject[] 以便稍后在 ListView 中显示它们？结果集和这个概念在 android 中相对较新

Answer 1

您应该能够轻松地遍历结果集的结果，并在您进行交互时用结果填充每个数组。

是这样的:

...
ResultSet rs = st.executeQuery(query);

ArrayList<String> names = new ArrayList<String>();
ArrayList<String> subjects = new ArrayList<String>();

while (rs.next()) { 
    names.add(rs.getString(1));
    subjects.add(rs.getString(2));
}

// finally turn the array lists into arrays - if really needed
String[] nameArr = new String[names.size()];
nameArr = names.toArray(nameArr);

String[] subjectArr = new String[subjects.size()];
subjectArr = subjects.toArray(subjectArr);

希望对您有所帮助!