Batch Update Demo : Batch Update « Database SQL JDBC « Java

1. Java
2. Database SQL JDBC
3. Batch Update

Batch Update Demo

 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class MainClass {
  public static void main(String[] args) {
    Connection connection = null;
    Statement statement = null;
    try {
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      String url = "jdbc:mysql://localhost/chapter04_jdbc21";
      connection = DriverManager.getConnection(url, "username", "password");

      statement = connection.createStatement();
      String update1 = "UPDATE employees SET email = 'a@a.com' WHERE email = 'a@b.com'";
      statement.addBatch(update1);
      String update2 = "UPDATE employees SET email = 'b@b.com' WHERE email = 'b@c.com'";
      statement.addBatch(update2);
      String update3 = "UPDATE employees SET email = 'c@c.com' WHERE email = 'c@d.com'";
      statement.addBatch(update3);

      statement.executeBatch();
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      if (statement != null) {
        try {
          statement.close();
        } catch (SQLException e) {
        } // nothing we can do
      }
      if (connection != null) {
        try {
          connection.close();
        } catch (SQLException e) {
        } // nothing we can do
      }
    }
  }
}

           
         
  

Related examples in the same category

1.	Create a batch update in JDBC
2.	Batch Update Insert
3.	Batch update: add Batch commands
4.	Check Batch Update Result
5.	Batch update for MySQL
6.	Deal with batch update exception and results
7.	Demo Prepared Statement Add Batch MySQL
8.	Statement Batch Update
9.	Determining If a Database Supports Batching
10.	Prepared Statement With Batch Update