Question 46 :
How can I insert multiple rows into a database in a single transaction?
//turn off the implicit commit
//..your insert/update/delete goes here
a new transaction is implicitly started.
JDBC 2.0 provides a set of methods for executing a batch of database commands. Specifically, the java.sql.Statement interface provides three methods: addBatch(), clearBatch() and executeBatch(). Their documentation is pretty straight forward.
The implementation of these methods is optional, so be sure that your driver supports these.