title: ResultSet to Array
body: <p>I have a Result set returned using a query: </p>
  
  <pre><code>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;
  }
  </code></pre>
  
  <p>I was just wondering is it possible to turn the Resultset into two seperate arrays: eg BookName[] and BookSubject[] so I can show them in a list view later on? Relatively new to resultset and this concept in android </p>