Home Tutorial Java Jdbc Jdbcbatch Alter Database Table Using JDBC Batch Process

 
 

Share on Google+Share on Google+
Alter Database Table Using JDBC Batch Process
Posted on: October 14, 2010 at 12:00 AM
Advertisement
In this example, we are discuss about alter database table using JDBC Batch process.

Alter Database Table Using JDBC Batch Process:

In this example, we are discuss about alter database table using JDBC Batch process.

First of all, we will create a java class BatchAlterTable.java.

 In this class we will create database connection as:

Connection connection = null;

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

connection = DriverManager.getConnection

("jdbc:mysql://localhost:3306/databasename","username","passsword");

Now we will used sequence of the step for Batch processing for alter database table.

1. Create Statement object using createStatement() method on the created Connection object as:

Statement stmt = connection.createStatement();

2. set auto commit is false using setAutoCommit() as:

connection.setAutoCommit(false);

3. Create SQL alter table statement for modify the database user table

 and add these statement in batch using addBatch() method as:

String query = "ALTER TABLE user ADD address varchar(50)";

stmt.addBatch(query); 

4. Execute the SQL statements using executeBatch() method on created statement object as:

stmt.executeBatch();

5. Last commit the connection using commit() method as:

connection.commit();

The code of the BatchAlterTable.java class is:

import java.sql.*;
public class BatchAlterTable {
  
  public static void main(String[] args) {
    try{
        Connection connection = null;
          Class.forName("com.mysql.jdbc.Driver");    
          connection = DriverManager.getConnection(
           
"jdbc:mysql://localhost:3306/roseindia_jdbc_tutorial","root","root");
          try{            
              // Create statement object  
              Statement stmt = connection.createStatement();            
               
              // Set auto-commit to false
              connection.setAutoCommit(false);
              
              // Alter table query
              String query1 = "ALTER TABLE user ADD address varchar(50)";            
           
              stmt.addBatch(query1);
              
              stmt.executeBatch();
              
              System.out.println("Alter table by Batch processing" );

             // connection committed
              connection.commit()
          }
          catch (SQLException s){
            System.out.println("SQL Exception " + s);
          }
        }
        catch (Exception e){
          e.printStackTrace();
        }
  }

}

Program output:

The database table output before alter is:

The eclipse console output is:

The database table output after alter is:

Download source code

Advertisement

Related Tags for Alter Database Table Using JDBC Batch Process:


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: October 14, 2010

Recommend the tutorial

Advertisements Advertisements
 

 

 

DMCA.com