JDBC CallableStatement

 

JDBC CallableStatement 

Database     : College

Table name : Department

Fields : DeptCode INT & DeptName VARCHAR(20)

         

---

                Stored Procedure 

            DELIMITER //

 

            CREATE PROCEDURE getAll()

            BEGIN

                SELECT *

                FROM Department;

            END //

 

            DELIMITER ;

---

 // JDBC

import java.sql.*;

class JDBC_Demo

{

    public static void main(String as[])

    {  

        try

        {

            Connection conc = DriverManager.getConnection("jdbc:mysql://localhost:3306/College","root", "JP@2026");

System.out.println("Database Connected");

CallableStatement cs = conc.prepareCall("{call getAll()}");

ResultSet rs = cs.executeQuery();

while(rs.next())

{

System.out.println("Department Code = "+rs.getInt("DeptCode"));

System.out.println("Department Name = "+rs.getString(2));

}

conc.close();

}

catch(SQLException e)

{

System.out.println(e);

}

        catch(Exception e)

        {

            System.out.println(e);

        }

finally

{

System.out.println("End of Program.");

        }

    }

}

C>java JDBC_Demo

Database Connected

Department Code = 205

Department Name = IT

Department Code = 104

Department Name = CSE

Department Code = 105

Department Name = EEE

Department Code = 106

Department Name = ECE

Department Code = 111

Department Name = MECH

Department Code = 159

Department Name = CDS

End of Program.

>