MyBatis传入多个参数 批量更新

MyBatis传入多个参数 批量更新

Service调用

Map<String, Object> params = new HashMap<>();
List<Long> ids = new ArrayList<>();
Long donwCnt = 20L;
params.put("ids", ids);
params.put("downCnt", donwCnt);
boolean result = userMapper.batchUpdateByIds(params);

Mapper 方法

boolean batchUpdateByIds(Map<String, Object> params) throws Exception;

Xml内容

<update id="batchUpdateByIds"  parameterType="java.util.Map" >
    update user
    <set>
        down_cnt = #{downCnt}
        where id in
        <foreach collection="ids" index="index" item="item" open="(" separator="," close=")" >
            #{item}
        </foreach>
    </set>
</update>

参考：MyBatis传入多个参数，实现批量更新