• September 28, 2014
  • JDBC
  • Comments Off on JDBC CallableStatement interface

JDBC CallableStatement interface

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.

 


Comments are closed.