The JDBC CallableStatement is used to execute the store procedure and functions. CallableStatement interface provides the methods to execute the store procedure and functions. We can get a statement object by invoking the prepareCall() method of Connection interface.
Syntax: CallableStatement callableStatement = conn.prepareCall(“{call procedurename(?,?…?)}”);
Note: A store procedure is used to perform business logic and may return zero or more values. A function used to perform calculation and it can return only one value.
Note: PreparedStatement can only use IN parameters. CallableStatement can use both IN and OUT parameters.
JDBC CallableStatement examples:
1. JDBC CallableStatement Stored procedure IN parameter example.
2. JDBC CallableStatement Stored procedure OUT parameter example.
3. JDBC CallableStatement Stored procedure batch update example.
Next Topic: JDBC CallableStatement Stored procedure IN parameter example.
Previous Topic: JDBC PreparedStatement batch update example.
Related Topics:
JDBC CallableStatement Stored procedure IN parameter example. |
JDBC CallableStatement Stored procedure OUT parameter example. |
JDBC CallableStatement Stored procedure batch update example. |