本文介绍了一种使用MyBatis实现批量删除用户的SQL映射方法。通过<delete>标签配合<foreach>循环来构建动态SQL语句，有效地提高了处理大量数据时的效率。
<delete id="deleteByPks" >
delete from user where user_id in
<!-- 参数为List，collection="list", 参数为[]数组时，collection="array" -->
<foreach collection="array" open="(" separator="," close=")" item="pk">
#{pk}
</foreach>
</delete>
delete from user where user_id in
<!-- 参数为List，collection="list", 参数为[]数组时，collection="array" -->
<foreach collection="array" open="(" separator="," close=")" item="pk">
#{pk}
</foreach>
</delete>
扫一扫
587
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
