xml中关于批量删除的sql语句

XML:

<delete id="deleteBatch">
		delete from sys_role_menu where role_id in
		<foreach item="roleId" collection="array" open="(" separator="," close=")">
			#{roleId}
		</foreach>
</delete>

传入的参数
Mapper:

	/**
	 * 根据角色ID数组,批量删除
	 */
	int deleteBatch(Long[] roleIds);
posted on 2021-10-26 17:07  汤姆猫8  阅读(1456)  评论(0)    收藏  举报