最近在项目中需要批量传部门ID参数做查询
接口一：
public Page<Document> selectByCondition(@Param("paramMap") Map<String, Object> paramMap, Pageable pageable);

mapper中sql
.... inner join (SELECT xxxxx FROM 表 as VR WHERE 

<if test="paramMap.dept != null">

    AND VR.ownDept in

   <foreach collection="paramMap.deptList" item="it" open="(" separator="," close=")">'${it}'</foreach>

</if>

...)....

此段代码，必须用'${it}' 要是用#{it}会报：

接口二：
int selectCountByCondition(Map<String, Object> paramMap);

.... inner join (SELECT xxxxx FROM 表 as VR WHERE 

<if test="dept != null">

 AND VR.ownDept in

 <foreach collection="deptList" item="it" open="(" separator="," close=")">'${it}'</foreach>

 </if>
...)....

用#{it} 和 '${it}'都可以