A JDBC statement object is used to execute an SQL statement. JDBC API supports three types of JDBC statement object to work with the SQL statements.
In JDBC we get three types of statements:
i Statement Interface
ii PreparedStatement Interface
iii CallableStatement Interface
There is a relationship between above three statements:
The above three Statement Interfaces are given in java.sql package. PreparedStatement Interface extends Statement. It means PreparedStatement interface has more features than that statement interface, Callablestatement (interface) extends Prepared Statement.
Statement
It executes normal SQL statements with no IN and OUT parameters.
PreparedStatement
It executes parameterized SQL statement that supports IN parameter.
CallableStatement
It executes parameterized SQL statement that invokes database procedure or function or supports IN and OUT parameter.
