Can I reuse a Statement or must I create a new one for each query?

Joe Sam Shirah

When using a JDBC compliant driver, you can use the same Statement for any number of queries. However, some older drivers did not always "respect the spec." Also note that a Statement SHOULD automatically close the current ResultSet before executing a new query, so be sure you are done with it before re-querying using the same Statement. For more information, see: Executing Statements Using Statement Objects.