JSP实现权限动态树型菜单
就是根据不同的用户,显示出不同的树型菜单项,问题是怎么将菜单从数据库中读取出来封装成一个对象
数据库如下
/*--存放菜单功能基本信息*/
DROP TABLE IF EXISTS SYS_FUNC;
CREATE TABLE SYS_FUNC (
NODE_ID VARCHAR(20) PRIMARY KEY NOT NULL,
DISPLAY_NAME VARCHAR(50) NOT NULL,
NODE_URL VARCHAR(50),
DISPLAY_ORDER INT NOT NULL,
PARENT_NODE_ID VARCHAR(20) NOT NULL
);
INSERT INTO SYS_FUNC VALUES('101','人事管理','',0,'0');
INSERT INTO SYS_FUNC VALUES('101001','机构管理','personnel/Branch_browse',1,'101');
INSERT INTO SYS_FUNC VALUES('101002','部门管理','personnel/Dept_browse',2,'101');
INSERT INTO SYS_FUNC VALUES('101003','员工管理','personnel/UserInfo_browse',3,'101');
INSERT INTO SYS_FUNC VALUES('102','日程管理','',4,'0');
INSERT INTO SYS_FUNC VALUES('102001','我的日程','schedule/Schedule_mySchedule',5,'102');
INSERT INTO SYS_FUNC VALUES('102002','部门日程','schedule/Schedule_deptSchedule',6,'102');
INSERT INTO SYS_FUNC VALUES('102003','我的便签','schedule/MyNote_myNote',7,'102');
/*--存放所有父节点*/
DROP TABLE IF EXISTS ROLE_RIGHT;
CREATE TABLE ROLE_RIGHT(
ROLE_RIGHT_ID INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
ROLE_ID INT NOT NULL,
NODE_ID VARCHAR(20) NOT NULL
);
/*管理员权限数据*/
INSERT INTO ROLE_RIGHT VALUES(DEFAULT,1,'102');
INSERT INTO ROLE_RIGHT VALUES(DEFAULT,1,'102001');
INSERT INTO ROLE_RIGHT VALUES(DEFAULT,1,'102002');
INSERT INTO ROLE_RIGHT VALUES(DEFAULT,1,'102003');
INSERT INTO ROLE_RIGHT VALUES(DEFAULT,1,'104');
INSERT INTO ROLE_RIGHT VALUES(DEFAULT,1,'104001');
INSERT INTO ROLE_RIGHT VALUES(DEFAULT,1,'104002');
INSERT INTO ROLE_RIGHT VALUES(DEFAULT,1,'105');
INSERT INTO ROLE_RIGHT VALUES(DEFAULT,1,'105001');
INSERT INTO ROLE_RIGHT VALUES(DEFAULT,1,'105002');
INSERT INTO ROLE_RIGHT VALUES(DEFAULT,1,'105003');
INSERT INTO ROLE_RIGHT VALUES(DEFAULT,1,'105004');