Home Tutorial Java Dbcp Natural Left Join of tables using DBCP

 
 

Share on Google+Share on Google+
Natural Left Join of tables using DBCP
Posted on: April 5, 2010 at 12:00 AM
Advertisement
This tutorial demonstrate natural left join of the tables using DBCP.

Code:

import java.sql.*;
import org.apache.commons.dbcp.BasicDataSource;

public class NaturalLeftJoin {
  public static void main(String[] args) {
    BasicDataSource bds = new BasicDataSource();
    bds.setDriverClassName("com.mysql.jdbc.Driver");
    bds.setUrl("jdbc:mysql://localhost:3306/mydb");
    bds.setUsername("root");
    bds.setPassword("");
    try {
      Connection con = bds.getConnection();
      try {
        Statement st = con.createStatement();
        ResultSet res = st.executeQuery("SELECT *FROM " "employee"
        " NATURAL LEFT JOIN " "salary");
        System.out.println("Emp_name" "\t" "Emp_sal");
        while (res.next()) {
          String name = res.getString("emp_name");
          int sal1 = res.getInt("sal");
          System.out.println(name + "\t\t" + sal1);
        }
      catch (SQLException s) {
        System.out.println("SQL statement is not executed!");
      }
    catch (Exception e) {
      e.printStackTrace();
    }
  }
}

Before running this program you need to make two tables. Below shown two tables and record stored in it.

Salary

Employee

Directory structure of files:

In the lib folder place all required jar files ie. commons-collections.jar, commons-dbcp.jar, commons-pool.jar, j2ee.jar and mysql-connector-java-5.1.7-bin.jar

In the pathset.bat write following statement

set classpath=.;lib/commons-collections.jar;lib/commons-dbcp.jar;lib/commons-pool.jar;lib/j2ee.jar;lib/mysql-connector-java-5.1.7-bin.jar

Output:

Advertisement

Related Tags for Natural Left Join of tables using DBCP:


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: April 5, 2010

Recommend the tutorial

Advertisements Advertisements
 

 

 

DMCA.com