Jdbc Callablestatement


Prev Tutorial Next Tutorial

Callablestatement in Jdbc

To call the procedures and functions of a database, CallableStatement interface is used.

CallableStatement is a derived Interface of preparedStatement. It has one additional feature over PreparedStatement that is calling procedures and function of a database.

Because of CallableStatement is inherited from PreparedStatement all the features of PreparedStatement are also available with CallableStatement.

callablestatement

Create object of CallableStatement

The prepareCall() method of Connection interface returns the instance of CallableStatement. To create a reference of CallableStatement we have two syntaxes one with command and the other is wih calling procedure or function.

Syntax of prepareCall() method

public CallableStatement prepareCall("{ call procedurename(?,?...?)}");  

Syntax

CallableStatement cstmt=con.prepareCall("sql command");

Syntax

CallableStatement cstmt=con.prepareCall("{call procedure name or function name}");

Syntax

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

Prev Tutorial Next Tutorial

Advertisements




Facebook Likes

Advertisements