Jdbc Callablestatement


PreParedStatement in JDBC ResultStament Interface in JDBC

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

PreParedStatement in JDBC ResultStament Interface in JDBC


Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 9999595223

wifi cctv camera

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet

For Projects 9999595223

Google Advertisements

Buy Websites 9999595223
wifi cctv camera

Wifi CCTV Camera RS:1200 to 2499.

Buy College Projects with Documentation Contact on whatsapp 9999595223. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs