Execute multiple queries using a single JDBC Statement object

Question

In JDBC, can I use single Statement object to call executeQuery("") multiple times? Is it safe? Or should I close the statement object after each query, and create new object for executing another query.

E.G:

Connection con; Statement s; ResultSet rs; ResultSet rs2; try {     con = getConnection();     s = con.prepareStatement();      try     {         rs = s.executeQuery(".......................");          // process the result set rs     }     finally     {         close(rs);     }      // I know what to do to rs here     // But I am asking, should I close the Statement s here? Or can I use it again for the next query?      try     {         rs2 = s.executeQuery(".......................");          // process the result set rs2     }     finally     {         close(rs2);     } } finally {     close(s);     close(con); } 

Answer 1

Yes you can re-use a Statement(specifically a PreparedStatement) and should do so in general with JDBC. It would be inefficient & bad style if you didn't re-use your statement and immediately created another identical Statement object. As far as closing it, it would be appropriate to close it in a finally block, just as you are in this snippet.

For an example of what you're asking check out this link: jOOq Docs