Скачать или смотреть Java Tutorial 90 - JDBC 7/7 Batch Processing

In this tutorial, I will show you how to use batch updates. When you want to group a set of statements (INSERT, UPDATE or DELETE) and execute them at once this mechanism is known as a batch update. After adding the required SQL statements using the addBatch() method, you can execute a batch using the executeBatch() method of the Statement interface. You may process batch updates inside transactions. In this way, you can execute the batch of SQL statements then commit or rollback the transactions.

// Set auto-commit mode
conn.setAutoCommit(false);

// Add the SQL statements to be executed in the batch
preparedStmt.addBatch();
preparedStmt.addBatch();
preparedStmt.addBatch();

// Execute the SQL statements
preparedStmt.executeBatch();

// rollback the transaction.
conn.rollback();

// commit the transaction.
conn.commit();