Executing a Batch of SQL Statements in a Database (Java Developers Almanac Example)

Executing a Batch of SQL Statements in a Database
With batch updating, a set of SQL statements is assembled and then sent altogether to the database for execution. Batch updating can improve performance.

This example creates a batch of insert statements. Auto-commit is disabled so that you have the choice of committing or not in the event of an exception.