java/zhihuishenqu.git

			@@ -3,7 +3,6 @@
			import java.util.List;

			import org.apache.ibatis.annotations.Mapper;
			import org.apache.ibatis.annotations.Select;
			import org.springframework.web.bind.annotation.RequestParam;

			import com.baomidou.mybatisplus.core.mapper.BaseMapper;
			@@ -18,18 +17,18 @@
			**/
			@Mapper
			public interface RoleDAO extends BaseMapper<SysRoleDO> {
			@Select("select r.* from sys_user_role u join sys_role r on u.role_id=r.role_id where u.user_id=#{userId}")

			List<SysRoleDO> selectByUserId(Long userId);

			@Select("select r.role_key role,m.component url from sys_role r join sys_role_menu rm on r.role_id=rm.role_id join sys_menu m on rm.menu_id=m.menu_id WHERE m.component is not null ")

			List<MenuVO> selectAllMenuUrl();

			@Select("select r.role_key from sys_user_role ur join sys_role r on ur.role_id = r.role_id where ur.user_id=#{username}")

			List<String> selectRoles(String username);

			@Select("")

			Long selectMaxRole(Long communityId);

			@Select("delete from sys_role where role_key =#{roleKey}")

			void deleteByRoleKey(@RequestParam("roleKey") String roleKey);
			}