Executing SQL Statements

• You can reuse a Statement or PreparedStatement object
• For each statement, you should only have one active ResultSet
• If you need to look at multiple result sets at the same time, create multiple Statement objects
• Close the current ResultSet before issuing a new query on the same statement

  result.close();
  

• When you are done with a Statement object, close it

  stat.close();

  That will also close the ResultSet