title: Does reusing a Statement and Resultset release resources from its previous usage? Or do I have to explicitly close them before reuse?
body: <p>Sample code:</p>
  
  <pre><code>        aStmt = aConn.prepareStatement(aQuery);
          aRset = aStmt.executeQuery(cQuery);
  
          while (cRset.next()) {
              //stuff to determine value of parm1
  
              aStmt.setString(1, parm1);                
              aRset = aStmt.executeQuery(); 
  
              //more stuff
          }
  </code></pre>
  
  <p>Do I have to close aStmt and aRset after every loop inside the while statement? Or will reusing them in the succeeding loops release the memory/resources used from the previous loops?</p>