- 方法一:当入参有一个定值和一个集合时
//批量删除 int delUserRoleList(@Param("roleid")Integer roleid,@Param("list4") List<UserRole> list4);
<delete id="delUserRoleList" > delete from nt_user_role where RoleId = #{roleid,jdbcType=INTEGER} and UserId in <foreach item="userRole" collection="list4" open="(" separator="," close=")"> #{userRole.userid} </foreach> </delete>
- 方法二:当入参只有集合
<delete id="delUserRoleList" > delete from nt_user_role where UserId in <foreach item="userRole" collection="list4" open="(" separator="," close=")"> #{userRole.userid} </foreach> and RoleId in <foreach item="userRole" collection="list4" open="(" separator="," close=")"> #{userRole.roleid} </foreach> </delete>
mybatis批量删除
最新推荐文章于 2023-10-11 17:10:11 发布