title: Java Statement Object Reuse?
body: <p>I would like to know if we can reuse the same Statement object for executing more than one query. Or, should we create a new statement for different queries.</p>
  
  <p>For example,</p>
  
  <pre><code>Connection con = getDBConnection();
  Statement st1 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
  int i = st1.executeUpdate("update tbl_domu set domU_status=1 where domU_id=" + dom_U_id);
  Statement st2 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
  String date = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime());
  int j = st2.executeUpdate("insert into tbl_domU_action_history values('" + dom_U_name + "', 1, '" + date + "')");  
  </code></pre>
  
  <p>In the above case, is there any harm in using the same statement st1 for both the executeUpdate() queries? Can I use the same Statement object st1 for another executeQuery()?</p>