mybatis 注解方式动态sql

    /**
     * @param roleIdList, id
     * @return int
     * @Description 更具用户名删除角色
     */

    @Delete({
            "<script> " +
                    "delete from user_role  ur where ur.userid=#{id} " +
                    "<if test=\"roleIdList !=null and roleIdList.size() !=0 \"> and ur.id not in " +
                    "<foreach collection='roleIdList' item='item' open='(' separator=',' close=')'> ",
                    "#{item} ",
                "</foreach> ",
            "</if> ",
            "</script> "
    })
    int delUserRole(@Param("roleIdList") List roleIdList, @Param("id") String id);