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.

 



Industrial Training

We offers Placement Oriented Training on Java, Spring, JSF, Hibernate, PHP, AngularJS, Angular 4, PLSQL, Oracle BI Publisher etc. We also provides Online training, please mail us at hr@codesjava.com.

Development

We also provides the Development services for Website Development , Java Development, PHP Development, Android App Development etc. You can contact us on hr@codesjava.com.

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