private static final String BATCH_INSERT = "INSERT INTO player_subscription (`player_id`,`channel_id`,`type_id`) VALUES (?,?,?)";

public void create(Collection<PlayerSubscription> playerSubscriptions, final Integer playerId)
    String query = "INSERT INTO player_subscription (`player_id`,`channel_id`,`type_id`) VALUES (?,?,?)";
    final JdbcOperations jdbcOperations = getJdbcTemplate().getJdbcOperations();
    final ArrayList<PlayerSubscription> subscriptions = new ArrayList<>(playerSubscriptions);
    jdbcOperations.batchUpdate(query, new BatchPreparedStatementSetter() {
        @Override
        public void setValues(PreparedStatement preparedStatement, int i) throws SQLException {
            final PlayerSubscription playerSubscription = subscriptions.get(i);
            preparedStatement.setInt(1, playerId);
            preparedStatement.setInt(2, playerSubscription.getChannleId());
            preparedStatement.setInt(3, playerSubscription.getTypeId());
        }

        @Override
        public int getBatchSize() {
            return subscriptions.size();
        }
    });
}

// deletes users with ID 1, 2
List<Object[]> ids = new ArrayList<>();
ids.add(new Object[]{1L}); // user ID 1
ids.add(new Object[]{2L}); // user ID 2
jdbcOperations.batchUpdate("delete from user where id = ?", ids);

// deletes users 'Paul Muller' and 'Jack Jones'
List<Object[]> users = new ArrayList<>();
users.add(new Object[]{"Paul", "Muller"});
users.add(new Object[]{"Jack", "Jones"});
jdbcOperations.batchUpdate("delete from user where firstname = ? and lastname = ?", users);