CodesJava

Easy learning with example program codes

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.

 

Sign Up/ Sign In
Ask a Question


Copyright © 2018 CodesJava DMCA.com Protection Status SiteMap Reference: Java Wiki