❮ Previous Next ❯

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(?,?)}");
❮ Previous Next ❯

Follow Us


Popular Links

Contact Us

address Plot No-741,2ND Floor
Opp. Bhagabati Temple,Jayadev Vihar
      Email: info@silantechnology.com
      Phone: 0674-2361252
39877, sundale dr, apt#101, Fremont, California 94538, USA
       Phone: +1(262)388-7619

facebook twitter google linked in

© 2018 Silan Technology. All Rights Reserved