JDBC CallableStatement Interface

The CallableStatement interface is used to execute the SQL statement to invoke the stored procedure or function.

The java.sql.CallableStatement interface is a part of JDBC API that describes a standard abstraction for the CallableStatement object.

The java.sql.CallableStatement extends the java.sql.PreparedStatement interface.

The CallableStatement object provides support for both input and output parameters.

We can have business logic on the database by the use of stored procedures and functions that will make the performance better because these are precompiled.

 

The prepareCall() method of Connection interface returns the instance of CallableStatement. The general form is:

CallableStatement prepareCall("{ call procedurename(?,?...?)}");
CallableStatement stmt=con.prepareCall("{call proceduredemo(?,?)}");

Our Services:

Java Training | Python Training | Machine Learning with Python Training | Deep Learning with Python Training | Data Science with Python Training | Projects

Silansoftware Pvt.Ltd, BBSR
Call to: 0674-2361252

Comment