Natural Join of tables using DBCP

Home Tutorial Java Dbcp Natural Join of tables using DBCP

Natural Join of tables using DBCP
Posted on: April 5, 2010 at 12:00 AM

This tutorial demonstrate natural join of the tables using DBCP.

Code:


import java.sql.*;

	
import org.apache.commons.dbcp.BasicDataSource;

	

	
public class RenameColumn {

	
  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();

	
        int n = st

	
        .executeUpdate("ALTER TABLE emp CHANGE empname name varchar(30)");

	
        System.out.println("Column name changed !!!");

	
      } catch (SQLException s) {

	
        System.out.println("No field renamed");

	
      }

	
    } 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:

Related Tags for Natural Join of tables using DBCP:

«Previous Index Next»

Latest
Frameworks
Category