mybatis批量删除Map＜String,List＜String＞＞数据

社会你xu哥

于 2025-02-09 13:40:07 发布

阅读量94

点赞数 3

文章标签： mybatis list 服务器

本文链接：https://blog.youkuaiyun.com/2201_75853118/article/details/145531444

版权

void bathchDeleteByEquipmentSystemIdsAndDate(@Param("equipmentSystemIdMonthSelectMap") Map<String, List<String>> equipmentSystemIdMonthSelectMap);

<delete id="bathchDeleteByEquipmentSystemIdsAndDate">
    DELETE FROM interval_check
    WHERE
    <foreach item="item" index="key" collection="equipmentSystemIdMonthSelectMap.entrySet()" separator="or" >
        (equipment_system_id = #{key} AND verification_time IN
        <foreach item="date" index="dateIndex" collection="item" open="(" separator="," close=")">
             #{date}
        </foreach>
        )
    </foreach>

</delete>