mybatis sql与参数同时传入mapper报错

将 sql字符串 “select name,password from sys_user where id in ${parms.id}”和id同时放入map中传入mapper报错

将下面这个map传入mapper

报错如下

select name,password from sys_user where id in ('xx', 'xxxx', 'xxxxxx')

用foreach遍历id