关于springboot:用户角色菜单查询
多对多,依据用户id,查问用户的多个角色,同时查问每个角色下对应的菜单, 同时过滤出雷同的菜单 用户<-->角色, 角色<-->菜单, 多对多的关系 个别状况下, 菜单不过滤, 前端框架主动反复的数据会笼罩 办法一 @RequestMapping("getMenuByUserid") public List<MenuRoleView> getMenuByUserid(HttpServletRequest request){ int userid = (int) request.getSession().getAttribute("userid"); //依据userid查问登录用户的角色信息 UserRoleViewExample userRoleViewExample=new UserRoleViewExample(); Criteria criteria2 = userRoleViewExample.createCriteria(); userRoleViewMapper.selectByExample(userRoleViewExample); criteria2.andUseridEqualTo(userid); List<UserRoleView> roleList = userRoleViewMapper.selectByExample(userRoleViewExample); List<Integer> roleIds=new ArrayList<Integer>();//角色id的汇合 for (UserRoleView userRoleView : roleList) { roleIds.add(userRoleView.getRoleid()); } //依据userid的汇合，查问 MenuRoleViewExample menuRoleViewExample=new MenuRoleViewExample(); com.bw.entity.MenuRoleViewExample.Criteria criteria = menuRoleViewExample.createCriteria(); criteria.andRoleidIn(roleIds); List<MenuRoleView> menuList = menuRoleViewMapper.selectByExample(menuRoleViewExample); return menuList; }办法二 @RequestMapping("getMenuByUserid2") public List<MenuRoleView> getMenuByUserid2(HttpServletRequest request){ Integer userid = (Integer) request.getSession().getAttribute("userid"); if(userid==null){ return new ArrayList(); } List<MenuRoleView> menuList = menuRoleViewMapper.getMenuByUserid2(userid); //工具类 HashMap<Integer, MenuRoleView> map=new HashMap<Integer, MenuRoleView>(); for (MenuRoleView menuRoleView : menuList) { map.put(menuRoleView.getMenuid(), menuRoleView); } Collection<MenuRoleView> values = map.values(); menuList=new ArrayList<MenuRoleView>(values); return menuList; }