Spring JdbcTemplate传参数为集合 NOT IN （：param）传参

最近使用spring jdbc时，使用not in 需要传递一个集合，网上查阅相关后，找到答案

代码如下：


String sql = "Select * From om_organization Where Pk_Organization NOT IN (:param)";
Map<String, Object> paramMap = new HashMap<String, Object>();
paramMap.put("param", orgIds);
NamedParameterJdbcTemplate jdbc = new NamedParameterJdbcTemplate(jdbcTemplate);
List<Organization> organizationList = jdbc.query(sql, paramMap, new RowMapper<Organization>() {

    @Override
    public Organization mapRow(ResultSet rs, int rowNum) throws SQLException {
        return getResultSet(new Organization(), rs);
    }

});