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.


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(?,?...?)}");  


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


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


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

Prev Tutorial Next Tutorial

Google Advertisements
Download Projects

Google Adsense Advertisements

Buy 3 Year Old Domain, Tutorialday.com, SeosmoTools.com @$200

Buy This Ad Space @$50 per Month, Ad Size 300X250 Contact on: hitesh.xc@gmail.com WhatsApp no. 8882538826

Yahoo Advertisements