title: How to put a resultSet into an Array to use multiple times
body: <p>I have a resultSet that I am pulling from my database:</p>
  
  <pre><code>      String selStmt = "SELECT code_id, internal_code, representation, pos, decode(substr(internal_code, 5, 1), 'Q', 2, 1) as sorter, "
                   + "       to_char(term_start, 'MM-DD-YYYY') as sDate "
                   + "  FROM table1, terms WHERE code_id = 'SEARCH.TERMS' AND internal_code = terms.terms_id (+) ORDER BY 5, 4 ";
  
    stmt = conn.prepareStatement(selStmt);
    result = stmt.executeQuery();
  </code></pre>
  
  <p>What I want to do now is put these results into an array, I know that I can use a while loop to loop and get the results, but I can only use those once, I need to continue to use them throughout the rest of the page.  I figured this could be done using an array, but if there is an easier way, let me know, also if more information is needed, please let me know.</p>