mybatis批量删除

1. 方法一：当入参有一个定值和一个集合时

   //批量删除
   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>

2. 方法二：当入参只有集合

   <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>