by Dinesh Thakur

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:

                  Jdbc Statement

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.