SQL Statements
createStatement makes an instance of Statement class
- used for simple SQL statements with no parameters
prepareStatement makes an instance of PreparedStatement class, a subclass of Statement
- used for SQL statements with one ore more IN parameters
- or simple SQL statements that are executed frequently
prepareCall makes an instance of CallableStatement
- used for calls to stored procedures in the database
- inherits methods for IN parameters from PreparedStatement
- also has methods for OUT and INOUT parameters
All the above statements are executed in “autocommit” mode for individual SQL statements. Transactions can be programmed with explicit methods commit and rollback.