Field Detail

• protected final String sql

• protected Statement statement

Constructor Detail

• protected Sql.AbstractQueryCommand(String sql)

Method Detail

• protected final void closeResources()

  Perform the query. Must set statement field so that the main (execute()) method can clean up. This is the method that encloses the variant part of the code.

  throws:

  SQLException if a database error occurs

  Parameters:

  connection - the connection to use

  Returns:

  ResultSet from an executeQuery method.

• protected final void closeResources(ResultSet rs)

• protected final ResultSet execute()

  After performing the execute operation and making use of its return, it's necessary to free the resources allocated for the statement.

  Parameters:

  rs - allows the caller to conveniently close its resource as well

• protected ResultSet runQuery(Connection connection)