Core Java| JSP| Servlets| XML| EJB| JEE5| Web Services| J2ME| Glossary| Questions?

Software Solutions and Services

  JDO Tutorials
  EAI Articles
  Struts Tutorials
  Java Tutorials
  Java Certification
  Java Applet

Questions

java
program concept behind inheritance in java
Java File
Hi Friend, Thank you for the support I got previously... Anyone please send me the Java Code for scanning a direct
password protected zip file creation exmpale coded neaded
am able to create a zip file and able to read the file but password protection need please help
java
any programs on combination generation pls...
deteminant
wap to find the determinant of any order matrix
java
i want to know the program for transversal sort. thanks
java
pl. let me know few progrograms on encapsulation. thanks
j2me jdbc connection
hello, whn i m importing sql package in mine midlet(tried for both javax.sql.* and java.sql.*;)..itz nt accepting it...
jvm
what is java virtual machine?
sort java
1. A statistics company wants to keep information of families. The information of a family is the family name, the numbe
All Questions...

Comments

Join tables with the NATURAL LEFT JOIN operation
This section describes the NATURAL LEFT JOIN operation and how to retrieve data through it.

Join tables with the NATURAL LEFT JOIN operation

This section describes the NATURAL LEFT JOIN operation and how to retrieve data through it. In this operation we are going to retrieve data according to match the field name of another tables.

NATURAL LEFT JOIN: In this operation both tables are merged to each other according to common fields but the priority is given to the first table in database.

Description of program:

In this program we are going to establish the connection with MySQL database by using the JDBC driver, after that we will join two tables through the help of NATURAL LEFT JOIN operation. It retrieves data on the specific field name that matches in both tables.

Description of code:

SELECT *FROM employee NATURAL LEFT JOIN Emp_sal:
Above code retrieves all data that matches in both tables on the basis of Emp_name field.

Here is the code of program:


import java.sql.*;



public class NatLeftJoinTable{

  public static void main(String[] args) {

    System.out.println("Natural Left Join Tables Example!");

    Connection con = null;

    try{

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

      con = DriverManager.getConnection

("jdbc:mysql://localhost:3306/jdbctutorial","root","root");

      try{

        Statement st = con.createStatement();

        ResultSet res = st.executeQuery

("SELECT *FROM "+"employee"+" NATURAL LEFT JOIN "+"Emp_sal");


  //Natural Left Join two tables

        System.out.println("Emp_name" + "\t" + "Emp_ed" + "\t" + "Emp_sal");

        while(res.next()){

          String name = res.getString("Emp_name");

          int ed = res.getInt("Emp_ed");

          int sal = res.getInt("Emp_sal");

          System.out.println(name + "\t\t" + ed + "\t" + sal);

        }

      }

      catch (SQLException s){

        System.out.println("SQL statement is not executed!");

      }

    }

    catch (Exception e){

      e.printStackTrace();

    }

  }

}

Download this example.

Table:- employee:

Emp_ed

Emp_name

santosh

deepak

Aman

Table:- Emp_sal:

Emp_name	Emp_sal
Aman santosh	8000 4500

Output of program:

C:\vinod\jdbc\jdbc\jdbc-mysql>javac NatLeftJoinTable.java

C:\vinod\jdbc\jdbc\jdbc-mysql>java NatLeftJoinTable
Natural Left Join Tables Example!
Emp_name      Emp_ed      Emp_sal
santosh           2                 4500
deepak          10                0
Aman            13                8000

� View all related tutorials

Related Tags: c database orm table data form io sed column remove unique key field columns this tab move row for rows

Leave your comment:
Name:
Email:
URL:
Title:
Comments:
Enter Code:
	Note: Emails will not be visible or used in any way, and are not required. Please keep comments relevant. Any content deemed inappropriate or offensive may be edited and/or deleted. No HTML code is allowed. Line breaks will be converted automatically. URLs will be auto-linked. Please use BBCode to format your text.