How To Execute Parameterized Insert Queries In Batch Using JDBC

The easiest solution to execute parameterized insert queries in batch is using PreparedStatement object.

import java.sql.PreparedStatement;

//...

connection.setAutoCommit(false);

PreparedStatement preparedStatement = connection
.prepareStatement("INSERT INTO phonebook (name, number) VALUES(?,?);");

for (PhoneBookEntry entry: entries) {…

--

--