Join Query-JDBC

 

 

import java.sql.*; 

 

class SelectQuery1 {

    public static void main(String args[]) throws Exception {

       

          Class.forName("com.mysql.jdbc.Driver");

 

            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/MCA", "root", "");

      

        Statement stmt = con.createStatement();

             String query = "SELECT * FROM Employee INNER JOIN Department ON Employee.dno = Department.dno";

        ResultSet rs = stmt.executeQuery(query);

 

        while (rs.next()) {

            int cno = rs.getInt("dno");

            String cname = rs.getString("dname");

            System.out.println("dNo: " + cno + ", Department Name: " + cname);

        }

 

           rs.close();

        stmt.close();

        con.close();

    }

}