mapper 文件:
/**
* 根据主键 逻辑删除
*/
int logicDeleteById(@Param("params") Map<String ,Object> map);
xml:
<update id = "logicDeleteById" parameterType="Map">
update student set
is_deleted = 1 ,
modifiedguid = #{params.modifiedguid} ,
modifiedname = #{params.modifiedname} ,
modifiedtime = #{params.modifiedtime}
where is_deleted = 0
and id in
<foreach item="item" index="index" collection="params.list" open="(" separator="," close=")">
#{item}
</foreach>
</update>