In this recipe, we will add a DAO method to save a list of objects to the database efficiently.
Use the batchUpdate()
method that takes an SQL insert
query and a list of values as parameters:
public void add(List<User> userList) { String sql = "insert into user (first_name, age) values (?, ?)"; List<Object[]> userRows = new ArrayList<Object[]>(); for (User user : userList) { userRows.add(new Object[] {user.getFirstName(), user.getAge()}); } jdbcTemplate.batchUpdate(sql, userRows); }