springBoot连表删除？？？一个操作，删掉俩张表-CSDN博客

本文链接：https://blog.csdn.net/qq_63943929/article/details/134113040

当当当~ happy~~

实现功能

点击删除，将该条数据的用户角色，角色权限之间的关系删除

后端

删除主要通过t_u_r,t_r_p俩张表的主键id删除

    @RequestMapping("delUrRp.do")
    public String delUrRp(Integer urId,Integer rpId){
        if (urId != null || rpId != null){
            roleService.delByUR(urId);
            permissionService.delRP(rpId);
            return "删除成功";
        }else if(urId != null || rpId == null){
            roleService.delByUR(urId);
            return "删除用户角色";
        }else if(urId == null || rpId != null){
            permissionService.delRP(rpId);
            return "删除角色权限";
        }
        return "删除失败";
    }

删除后的展示页面也需要进行变动

    <select id="findAll" resultType="cn.chengshi.entity.User">
        select a.name as name ,r.r_name as roleName,p.p_name as permissionName,ur.id as urId,rp.id as rpId
        from t_user a
                 left join t_u_r ur on a.id = ur.uid
                 left join t_role r on ur.rid = r.r_id
                 left join t_r_p rp on r.r_id = rp.rid
                 left join t_permission p  on rp.pid = p.p_id
        where ur.id is not null  or rp.id is not null

    </select>

前端

从展示页面获取id

       <a onclick="del(${obj[i].urId},${obj[i].rpId})">删除</a>

function del(urId,rpId) {
    var flag = confirm("您确定要删除当前评论吗？");
    console.log("rpid"+rpId+'urId'+urId);
    if (flag>0){
        $.ajax({
            url:"http://localhost/user/delUrRp.do",
            type: "post",
            data:{"urId":urId,"rpId":rpId},
            dataType:"text",
            success:function(obj){
                if (obj == "删除成功"){
                    alert("删除成功")
                    window.location.href="http://localhost/page/user/findAll.html";
                }else if(obj == "删除用户角色"){
                    alert("成功删除用户角色,该用户的角色权限没有,无法删除")
                    window.location.href="http://localhost/page/user/findAll.html";
                }else if(obj == "删除角色权限"){
                    alert("成功删除角色权限,该用户的用户角色没有,无法删除")
                    window.location.href="http://localhost/page/user/findAll.html";
                }else {
                    alert("删除失败")
                }
            }

        })
    }
}