菜单增删改查940303_parentmenuid-CSDN博客

本文链接：https://blog.csdn.net/as19862500/article/details/114339366

这篇博客介绍了如何使用Java进行菜单的增删改查操作，涵盖了Controller层和Service层的实现，以及相关的SQL查询。

摘要由CSDN通过智能技术生成

菜单Controller

@RestController
@RequestMapping("/menu")
public class MenuController {

    //查找服务
    @Reference
    private MenuService menuService;


    //分页查询
    @RequestMapping("/pageQuery")
    public PageResult findPage(@RequestBody QueryPageBean queryPageBean) {
        PageResult pageResult = menuService.pageQuery(queryPageBean);
        return pageResult;
    }


    //用于角色的新增或者编辑,查询出所有的菜单,展示在表单中
    @RequestMapping("/findAll")
    public Result findAll() {
        List<Menu> data = null;
        try {
            data = menuService.findAll();
            return new Result(true, MessageConstant.QUERY_MENU_SUCCESS, data);
        } catch (Exception e) {
            e.printStackTrace();
            return new Result(false, MessageConstant.QUERY_MENU_FAIL);
        }

    }


    //新增一个菜单
    @RequestMapping("/add")
    public Result add(@RequestBody Menu menu, Integer id) {
        try {
            if (id == 999999) {
                menu.setParentMenuId(null);
            } else {
                menu.setParentMenuId(id);
            }
            menuService.add(menu);
        } catch (Exception e) {
            e.printStackTrace();
            return new Result(false, MessageConstant.ADD_MENU_FAIL);
        }
        return new Result(true, MessageConstant.ADD_MENU_SUCCESS);
    }

    //编辑菜单用于数据的回显
    @RequestMapping("/findById")
    public Result findByPath(Integer id) {
        try {
            Menu data = menuService.findById(id);
            return new Result(true, MessageConstant.QUERY_MENU_SUCCESS, data);
        } catch (Exception e) {
            e.printStackTrace();
            return new Result(false, MessageConstant.QUERY_MENU_FAIL);
        }

    }

    //编辑一个菜单
    @RequestMapping("/edit")
    public Result edit(@RequestBody Menu menu,Integer id) {
        try {
            if (id==999999){
                menuService.edit(menu);
            }else {
                menu.setParentMenuId(id);
                menuService.edit(menu);
            }


            return new Result(true, MessageConstant.EDIT_MENU_SUCCESS);
        } catch (Exception e) {
            e.printStackTrace();
            if(e.getMessage().contains("uk_path")){
                return new Result(false, "路径级别不能重复！");
            }
            return new Result(false, MessageConstant.EDIT_MENU_FAIL);
        }

    }

    //删除一个菜单
    @RequestMapping("/delete")
    public Result delete(Integer id) {
        try {
            menuService.delete(id);
            return new Result(true, MessageConstant.DELETE_MENU_SUCCESS);
        } catch (Exception e) {
            e.printStackTrace();
            return new Result(false, MessageConstant.DELETE_MENU_FAIL);
        }

    }

    //用于查找所有的自关联的id
    @RequestMapping("/findMenuparentMenuId")
    public Result findMenuparentMenuId() {
        try {
            List<Map> data = menuService.findMenuparentMenuId();
            return new Result(true, MessageConstant.QUERY_MENU_SUCCESS, data);
        } catch (Exception e) {
            e.printStackTrace();
            return new Result(false, MessageConstant.QUERY_MENU_FAIL);
        }
    }


    //用于查找所有的自关联的id
    @RequestMapping("/findMenuIdAndDisabled")
    public Result findMenuIdAndDisabled(Integer id) {
        try {
            List<Map> data = menuService.findMenuIdAndDisabled(id);
            return new Result(true, MessageConstant.QUERY_MENU_SUCCESS, data);
        } catch (Exception e) {
            e.printStackTrace();
            return new Result(false, MessageConstant.QUE