A Statement object is used to send SQL statements to a database. It will act as containers for executing SQL statements on a given connection.
There are three kinds of Statement objects.
1. Statement
2. PreparedStatement
It inherits from Statement.
3. CallableStatement
It inherits from PreparedStatement.
Statement :
A Statement object is used to execute a simple SQL statement with no parameters The Statement interface provides basic methods for executing statements and retrieving results.
Prepared Statement :
A PreparedStatement object is used to execute a pre-compiled SQL statement with or without IN parameters. The PreparedStatement interface adds methods for dealing with IN parameters.
Callable Statement :
A CallableStatement object is used to execute a call to a database stored procedure. CallableStatement adds methods for dealing with OUT parameters.
Check this link for the implementation of Calling procedures with Callable Statement
http://www.visualbuilder.com/java/jdbc/tutorial/pageorder/10/
Useful Link.