Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement