Efficient JDBC Multiple Queries using PreparedStatement Batch

EfficientJDBCPreparedStatementBatch.java

connection.setAutoCommit(false);
PreparedStatement preparedStatement = connection.prepareStatement(someQuery);
for (Record record : records) {
    // do your stuff (e.g. preparedStatement.setString(1, name);
    preparedStatement.addBatch();
}
preparedStatement.executeBatch();
connection.commit();