java web项目对对权限完善的一个架子+数据库文件

CREATE DATABASE app_team0; USE app_team0; CREATE TABLE sys_right ( right_code varchar (50) NOT NULL , right_parent_code varchar (50), right_type varchar (20), right_text varchar (50), right_url varchar (100), right_tip varchar (50), primary key (right_code)) type=MyISAM,default character set utf8; CREATE TABLE sys_role ( role_id bigint PRIMARY KEY AUTO_INCREMENT, role_name nvarchar (50) NOT NULL , role_desc nvarchar (50), role_flag int )type=MyISAM,default character set utf8; CREATE TABLE sys_role_right ( rf_id bigint PRIMARY KEY AUTO_INCREMENT, rf_role_id bigint NOT NULL , rf_right_code varchar (50) NOT NULL )type=MyISAM,default character set utf8; CREATE TABLE sys_user ( usr_id bigint PRIMARY KEY AUTO_INCREMENT, usr_name nvarchar (50) NOT NULL , usr_password nvarchar (50) NOT NULL , usr_flag int NOT NULL, usr_role_id int ) type=MyISAM,default character set utf8; CREATE TABLE sys_user_role ( ur_id bigint PRIMARY KEY AUTO_INCREMENT, ur_user_id bigint , ur_role_id bigint ) type=MyISAM,default character set utf8; INSERT INTO sys_user(usr_id,usr_name,usr_password,usr_flag,usr_role_id) values(1,'qq','qq',1,1); INSERT INTO sys_role(role_name,role_desc,role_flag) values('上帝','全能管理员',1); INSERT INTO sys_role(role_name,role_desc,role_flag) values('用户管理员','用户管理员',1); INSERT INTO sys_role(role_name,role_desc,role_flag) values('角色管理员','角色管理员',1); INSERT INTO sys_user_role(ur_user_id,ur_role_id) values(1,1); INSERT INTO sys_right(right_code,right_parent_code,right_type,right_text,right_url,right_tip) values('L01','ROOT_MENU','Folder','权限管理','','权限管理'); INSERT INTO sys_right(right_code,right_parent_code,right_type,right_text,right_url,right_tip) values('L0101','L01','Folder','用户管理','','用户管理'); INSERT INTO sys_right(right_code,right_parent_code,right_type,right_text,right_url,right_tip) values('L010101','L0101','Document','添加用户','user.do?o=toAdd','添加用户'); INSERT INTO sys_right(right_code,right_parent_code,right_type,right_text,right_url,right_tip) values('L010102','L0101','Document','查询用户','user.do?o=toList','查询用户'); INSERT INTO sys_right(right_code,right_parent_code,right_type,right_text,right_url,right_tip) values('L0102','L01','Folder','角色管理','','角色管理'); INSERT INTO sys_right(right_code,right_parent_code,right_type,right_text,right_url,right_tip) values('L010201','L0102','Document','添加角色','role.do?o=toAdd','添加角色'); INSERT INTO sys_right(right_code,right_parent_code,right_type,right_text,right_url,right_tip) values('L010202','L0102','Document','查询角色','role.do?o=toList','查询角色'); INSERT INTO sys_role_right(rf_role_id,rf_right_code) values(1,'L01'); INSERT INTO sys_role_right(rf_role_id,rf_right_code) values(1,'L0101'); INSERT INTO sys_role_right(rf_role_id,rf_right_code) values(1,'L010101'); INSERT INTO sys_role_right(rf_role_id,rf_right_code) values(1,'L010102'); INSERT INTO sys_role_right(rf_role_id,rf_right_code) values(1,'L0102'); INSERT INTO sys_role_right(rf_role_id,rf_right_code) values(1,'L010201'); INSERT INTO sys_role_right(rf_role_id,rf_right_code) values(1,'L010202'); INSERT INTO sys_role_right(rf_role_id,rf_right_code) values(2,'L01'); INSERT INTO sys_role_right(rf_role_id,rf_right_code) values(2,'L0101'); alter table sys_role_right add constraint `FK_sys_role_right_sys_right` foreign key (rf_right_code) references sys_right(right_code); alter table sys_role_right add constraint `FK_sys_role_right_sys_role` foreign key (rf_role_id) references sys_role(role_id); alter table sys_user_role add constraint `FK_sys_user_role_sys_role` foreign key (ur_role_id) references sys_role(role_id); alter table sys_user_role add constraint `FK_sys_user_role_sys_user` foreign key (ur_user_id) references sys_user(usr_id);