Java Statements - Example

 

Java Statements

(Statement, PreparedStatement, CallableStatement)
 

 

Database     : College

Table name : Department

Fields : DeptCode INT & DeptName VARCHAR(20)

         

 

 

// JDBC

 

import java.sql.*;

 

class JDBC_Demo

{

    public static void main(String as[])

    {

                  Connection conc;

                 

        try

        {

                           String url = "jdbc:mysql://localhost:3306/College";

                           String usrname = "root";

                           String pwd = "JP@2026";

            conc = DriverManager.getConnection(

                url, usrname, pwd);

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

 

 

 

                           Statement stat = conc.createStatement();

                          

                           ResultSet rs1 = stat.executeQuery("Select * from Department where DeptCode=205");

                           if(rs1.next()) {

                                    System.out.println("Statement");

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

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

                           }

                          

                          

                           PreparedStatement ps = conc.prepareStatement("SELECT * FROM Department WHERE DeptCode = ?");

 

                           ps.setInt(1, 205);

 

                           ResultSet rs2 = ps.executeQuery();

                          

                           if(rs2.next()) {

                                    System.out.println("Prepared statement");

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

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

                           }

                          

                          

 

                           CallableStatement cs =

                           conc.prepareCall("{call getDepartment(205)}");

 

                           ResultSet rs3 = cs.executeQuery();

 

                           if(rs3.next()) {

                                    System.out.println("Callable statement");

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

                                    System.out.println("Department Name = "+rs3.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");

        }

    }

}

 

 

 

/*

 

Procedure in Database

Procedure:

 

DELIMITER //

 

CREATE PROCEDURE getDepartment(IN val INT)

BEGIN

    SELECT *

    FROM Department

    WHERE DeptCode = val;

END //

 

DELIMITER ;

*/

 

 

Sample Output

 

>javac JDBC_Demo.java

>java JDBC_Demo

 

Database Connected

 

Statement

Department Code = 205

Department Name = IT

 

Prepared statement

Department Code = 205

Department Name = IT

 

Callable statement

Department Code = 205

Department Name = IT

 

End Of Program

 

>