mybatis parameterType=“map“ 使用方式

   Map<String, Object> params = new HashMap<>();
   params.put("flownums", Convert.toStrArray("123,567,AAA"));
   params.put("loginName", getLoginName());
   XXXMapper.updateXXXExs(params);

public void updateXXXExs(Map<String, Object> params);

<update id="updateXXXExs" parameterType="map" >
        update ql_XXX
        set XXXstate = '2',
        XXXcode = 'XXX',
        update_by = #{loginName}
        where flownum in
        <foreach item="flownum"   collection="flownums" open="(" separator="," close=")">
            #{qlflownum}
        </foreach>
    </update>

collection="flownums"  这个是关键点

foreach 的另外两种collection 相对好理解。

参考

https://blog.csdn.net/m0_51697147/article/details/126686680

https://www.jianshu.com/p/d3e307395c67