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





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

1.PreparedStatement: executeUpdate()
2.PreparedStatement: getParameterMetaData()
3.PreparedStatement: getWarnings()
4.PreparedStatement: setAsciiStream(int parameterIndex, InputStream x, int length)
5.PreparedStatement: setBigDecimal(int parameterIndex, BigDecimal x)
6.PreparedStatement: setBinaryStream(int parameterIndex, InputStream x, int length)
7.PreparedStatement: setBoolean(int parameterIndex, boolean x)
8.PreparedStatement: setByte(int parameterIndex, byte x)
9.PreparedStatement: setCharacterStream(int parameterIndex, Reader reader, int length)
10.PreparedStatement: setClob(int parameterIndex, Clob x)
11.PreparedStatement: setDate(int parameterIndex, Date x)
12.PreparedStatement: setDouble(int parameterIndex, double x)
13.PreparedStatement: setInt(int parameterIndex, int x)
14.PreparedStatement: setFetchSize(int rows)
15.PreparedStatement: setFloat(int parameterIndex, float x)
16.PreparedStatement: setLong(int parameterIndex, long x)
17.PreparedStatement: setNull(int parameterIndex, int sqlType)
18.PreparedStatement: setObject(int parameterIndex, Object x)
19.PreparedStatement: setRef(int parameterIndex, Ref x)
20.PreparedStatement: setShort(int parameterIndex, short x)
21.PreparedStatement: setString(int parameterIndex, String x)
22.PreparedStatement: setTime(int parameterIndex, Time x)
23.PreparedStatement: setTimestamp(int parameterIndex, Timestamp x)
24.PreparedStatement: setURL(int parameterIndex, URL x)