Java Statement

 Java Statement 

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

        {

            conc = DriverManager.getConnection(

                "jdbc:mysql://localhost:3306/College",

                "root",

                "JP@2026"

            );

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

                                               

                        String sq = "Select * from Department;";

 

                        Statement stat = conc.createStatement();

 

                        ResultSet rs = stat.executeQuery(sq);

                        while(rs.next())

                        {

                                int dc = rs.getInt("DeptCode");

                                String dn = rs.getString("DeptName");

                       

                                System.out.println("Code = "+dc);

                                System.out.println("Name = "+dn);

                        }

                        conc.close();

                       

                }

                catch(SQLException e)

                {

                        System.out.println(e);

                }

        catch(Exception e)

        {

            System.out.println(e);

        }

                finally

                {

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

        }

    }

}

 

 

Sample Output

 

 

>javac JDBC_Demo.java

 

>java JDBC_Demo

Database Connected

Code = 205

Name = IT

Code = 104

Name = CSE

Code = 105

Name = EEE

Code = 106

Name = ECE

Code = 111

Name = MECH

Code = 159

Name = CDS

End Of Program

 

>