Calling a stored procedure in a Java program
		      
Example stored Procedure in MySQL
******************************
DELIMITER //
create PROCEDURE addinterest(IN ano INT,  OUT bal FLOAT(9,2))
  BEGIN
   select balance into bal from account where accno=ano;
   SET bal=bal+bal*0.05;
   update account set balance=bal where accno=ano;
  END //
DELIMITER;

Q)How to call a stored procedure in a Java program?
=>by using java.sql.CallableStatement
Q)How to make use of a CallableStatement in a Java program?
DIAGRAM
Q)Write a Java program to call a stored procedure
import java.sql.*;
class StoredProcedureApplication 
{
	public static void main(String[] args)  throws Exception
	{
		Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/bankdb","root","ashokit");
		CallableStatement cst=con.prepareCall("{call addinterest(?,?)}");
		cst.registerOutParameter(2,Types.FLOAT);
                cst.setInt(1,100001);
		cst.execute();//stored procedure is called
		float newbal=cst.getFloat(2);
		System.out.println("After adding interest, new balance is Rs."+newbal);
		cst.close();
		con.close();
	}
}