PostgreSQL里没有在从句使用批量更新(postgresql Not In clause us

我需要的是删除除我指定所有ID查询。因此，我已在弹簧这样的查询：

private final String SQL_Clear_Deleted_Options = "DELETE FROM vote_votes WHERE poll_id=? AND option_id <> ?";

我使用的JdbcTemplate和BATCHUPDATE这样做。我还用<>操作者不表示子句。这是我的代码：

public void clearDeletedOptions(int id) {
        int[] argTypes = { Types.INTEGER, Types.INTEGER };

        List<Object[]> batchArgs = new ArrayList<>();
        for (int i:ids) {
            batchArgs.add(new Object[]{id, i});
        }
        jdbcTemplate.batchUpdate(SQL_Clear_Deleted_Options, batchArgs, argTypes);
}

在上面的代码中的ID是指示在查询option_id小号整数列表。我不知道为什么它的工作原理相反，并删除所有IDS给出！每一件事情看起来很好，batchArges包含对（poll_id，option_id）表示特定poll_id和option_ids不应被删除。

问题是什么？

这是因为，每个不平等将删除的记录休息。其中一个解决方案是使用jdbcTemplate.execute通过动态创建SQL。

import java.util.Arrays;
import java.util.List;
import java.util.stream.Collectors;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.CommandLineRunner;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.jdbc.core.JdbcTemplate;

@SpringBootApplication
public class Application implements CommandLineRunner {

    private static final Logger log = LoggerFactory.getLogger(Application.class);

    public static void main(final String args[]) {
        SpringApplication.run(Application.class, args);
    }

    @Autowired
    JdbcTemplate jdbcTemplate;

    @Override
    public void run(final String... strings) throws Exception {

        log.info("Creating tables");

        jdbcTemplate.execute("DROP TABLE votes IF EXISTS");
        jdbcTemplate.execute("CREATE TABLE votes(id SERIAL, poll_id integer, option_id integer)");

        final List<Object[]> splitUpValues = Arrays.asList("1 0", "1 1", "2 2", "1 3", "1 4").stream()
                .map(name -> name.split(" ")).collect(Collectors.toList());

        splitUpValues.forEach(name -> log.info(String.format("Inserting votes record for %d %d",
                Integer.valueOf((String) name[0]), Integer.valueOf((String) name[1]))));

        jdbcTemplate.batchUpdate("INSERT INTO votes(poll_id, option_id) VALUES (?,?)", splitUpValues);

        log.info("Querying for all votes");
        jdbcTemplate
                .query("SELECT id, poll_id, option_id FROM votes",
                        (rs, rowNum) -> new Votes(rs.getLong("id"), rs.getInt("poll_id"), rs.getInt("option_id")))
                .forEach(vote -> log.info(vote.toString()));

        jdbcTemplate.execute("DELETE FROM votes WHERE poll_id = 1 AND option_id not in (1, 3)");

        log.info("Querying for all votes after batch delete");
        jdbcTemplate
                .query("SELECT id, poll_id, option_id FROM votes",
                        (rs, rowNum) -> new Votes(rs.getLong("id"), rs.getInt("poll_id"), rs.getInt("option_id")))
                .forEach(vote -> log.info(vote.toString()));

    }
}