Submitting SQL

For databases that support statement precompilation, good drivers will precompile prepared statements on the server prior to statement execution. This allows greater performance for repeated statement executions. Prepared statements also support input parameters which are usually supplied repetitively for multiple statement executions. The jdbc specification does not require that prepared statements be precompiled in order not to exclude compliant drivers for databases which do not supported prepared statements.

Callable statements are statements which are used exclusively for stored procedure statement executions, and support OUT parameters in addition to a result set.