PreparedStatement: addBatch() : PreparedStatement « java.sql « Java by API

1. Java by API
2. java.sql
3. PreparedStatement

PreparedStatement: addBatch()

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

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

      String sql = "UPDATE employees SET email = ? WHERE employee_id = ?";
      statement = connection.prepareStatement(sql);

      statement.setString(1, "a@a.com");
      statement.setLong(2, 1);
      statement.addBatch();

      statement.setString(1, "b@b.com");
      statement.setLong(2, 2);
      statement.addBatch();

      statement.setString(1, "c@c.com");
      statement.setLong(2, 3);
      statement.addBatch();

      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