mybatis在in里面传入#{}，里面包含多个值该怎么写才不会报错？

Question

如题，以下是具体代码片

    <update id="editupthat" parameterType="java.util.Map">
        update t_sys_pos_policy_info
        set module1_end_date=#{map.isdate}
        where policy_id=#{map.isid}
        and module1_pickup_date &lt; #{map.isdate}
        and id in (#{map.issn})
    </update>

前端传值

每次执行都会报错

### Error updating database.  Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: '18948,18949'
### The error may involve com.ruoyi.project.deveagent.syspospolicy.mapper.SysPosPolicyMapper.editupthat-Inline
### The error occurred while setting parameters
### SQL: update t_sys_pos_policy_info         set module1_end_date=?         where policy_id=?      and module1_pickup_date < ?         and id in (?)
### Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: '18948,18949'
; Data truncation: Truncated incorrect DOUBLE value: '18948,18949'

/**
     * @param params
     * @return
     */
    @Transactional
    public R editupthat(Map<String,Object> params) {
        try {
            int k = 0;
            k = sysPosPolicyMapper.editupthat(params);
            if(k == 0){
                return R.error("修改失败！");
            }
        }catch (Exception e){
            return R.error("修改异常！");
        }
            return R.ok("修改成功！");
    }

Answer 1

可以传一下list集合，在mybatis里面用foreach循环

你的字段里面不是多个值是用逗号分割的， 可以用这个方法Arrays.asList(s.split(",")，转接转成list集合，在把集合传进去，循环这个集合。(pd是我们自己封装的，其它就是一个map对象)

java代码

mapper