Stored Procedures can be called in java by using the prepareCall() method which returns a CallableStatement object.

CallableStatement cs = con.prepareCall("{call Procedure_name}");

ResultSet rs = cs.executeQuery();

CallableStatement cs=con.prepareCall (?{call SHOW_SUPPLIERS}?);
ResultSet rs = cs.executeQuery();

StoredProcedure are the group of the sql statements and perform as a logical unit .
using the StroedProcedure encapsulated the set of queries or operations
to call the StroedProcedure using the CallableStatement
CallableStatement cs=con.Preparecall{"sotredProcedure"}:
CallableStatements to take the inputparameters as well as the OutputParameters.
CallableStatement is the subclass of the PreparedStatement.
using the PreparedStatement you can submit the select statement repatitvely .
PreparedStatement ps=con.preparedStatement("select*form emplyoee(???)");
using the Statement object you can submit the any kind of the sql statements like DML statements.
Statement st=con.createStatement();

If you have the better answer, then send it to us. We will display your answer after the approval.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code:*
	Inform me about updated answers to this question