The CallableStatement extends the PreparedStatement interface.
The CallableStatement provides an interface for calling database stored procedures.
the simplest form of this syntax would be:
{call procedure-name}
which represents a call to a stored procedure with no parameters.
A call to a stored procedure accepting two input parameters:
{call procedure-name (?, ?)}
CallableStatement callproc = connection.prepareCall("{call updateLast (?, ?)}");
callproc.setInt (1, 5); // 1 specifies the first parameter
callproc.setString (2, "J"); // 2 specifies the second parameter
To now execute the stored procedure, we use the following statement:
callproc.executeUpdate();