最代码网站
首页>代码>jsp+servlet+mysql+json+ajax开发的java权限管理系统，包括项目需求 下载  打赏  举报
jeremygilbert的gravatar头像
jeremygilbert 2016-01-06 08:46:16
原

jsp+servlet+mysql+json+ajax开发的java权限管理系统，包括项目需求

use company;
drop table if exists  tt_dept;
create table tt_dept (
   dept_id int not null auto_increment PRIMARY key,
   dept_mgr_id int not null ,
   dept_name VARCHAR(30) UNIQUE,
   dept_addr VARCHAR(100),
   tel  VARCHAR(20),
   fax  VARCHAR(30),
   add_time  datetime
)auto_increment=100000;
 
insert into  tt_dept(dept_mgr_id,dept_name,dept_addr,tel,fax,add_time) 
values(100000,'软件部','广东省深圳市龙岗区坑梓镇龙湾路168号','0755-233556348','0755-233557366',NOW());
insert into  tt_dept(dept_mgr_id,dept_name,dept_addr,tel,fax,add_time) 
values(100001,'学习部','广东省深圳市龙岗区坑梓镇龙湾路168号','0755-233556348','0755-233557366',NOW());
insert into  tt_dept(dept_mgr_id,dept_name,dept_addr,tel,fax,add_time) 
values(100002,'小卖部','广东省深圳市龙岗区坑梓镇龙湾路168号','0755-233556348','0755-233557366',NOW());
insert into  tt_dept(dept_mgr_id,dept_name,dept_addr,tel,fax,add_time) 
values(100003,'中专部','广东省深圳市龙岗区坑梓镇龙湾路168号','0755-233556348','0755-233557366',NOW());
insert into  tt_dept(dept_mgr_id,dept_name,dept_addr,tel,fax,add_time) 
values(100004,'武装部','广东省深圳市龙岗区坑梓镇龙湾路168号','0755-233556348','0755-233557366',NOW());
insert into  tt_dept(dept_mgr_id,dept_name,dept_addr,tel,fax,add_time) 
values(100005,'体育部','广东省深圳市龙岗区坑梓镇龙湾路168号','0755-233556348','0755-233557366',NOW());


drop table if exists tt_dept_user;
create table tt_dept_user(
    user_id int not null auto_increment PRIMARY key,
    user_name VARCHAR(30) UNIQUE,
    first_name varchar(10),
    last_name varchar(20),
    password VARCHAR(30),
    dept_id int not null,
    add_time  datetime,
    sex int,
   email  varchar(50),
   phone  varchar(11),
    tel   VARCHAR(20),
    birthday  date,
    address  varchar(100),
   id_card   varchar(18),
   image    varchar (100),
    remark   varchar(200),
    status   int

)auto_increment=100000;



insert  into tt_dept_user(user_name,first_name,last_name,password,dept_id,add_time,sex,email,phone,tel,birthday,address,id_card,image,remark,status)
VALUES ('admin','周','海波','123456',100000,NOW(),1,'jeremy@163.com','15207442209','075584351234',NOW(),'深圳','430525199902262738','D:/2.jpg','呵呵',1);
insert  into tt_dept_user(user_name,first_name,last_name,password,dept_id,add_time,sex,email,phone,tel,birthday,address,id_card,image,remark,status)
VALUES ('jeremy','张','三','123456',100001,NOW(),1,'jeremy@163.com','15207442209','075584351234',NOW(),'深圳','430525199902262738','D:/2.jpg','呵呵',1);
insert  into tt_dept_user(user_name,first_name,last_name,password,dept_id,add_time,sex,email,phone,tel,birthday,address,id_card,image,remark,status)
VALUES ('john','王','五','123456',100002,NOW(),1,'jeremy@163.com','15207442209','075584351234',NOW(),'深圳','430525199902262738','D:/2.jpg','呵呵',1);
insert  into tt_dept_user(user_name,first_name,last_name,password,dept_id,add_time,sex,email,phone,tel,birthday,address,id_card,image,remark,status)
VALUES ('jelly','赵','六','123456',100003,NOW(),1,'jeremy@163.com','15207442209','075584351234',NOW(),'深圳','430525199902262738','D:/2.jpg','呵呵',1);
insert  into tt_dept_user(user_name,first_name,last_name,password,dept_id,add_time,sex,email,phone,tel,birthday,address,id_card,image,remark,status)
VALUES ('tom','周','三','123456',100004,NOW(),1,'jeremy@163.com','15207442209','075584351234',NOW(),'深圳','430525199902262738','D:/2.jpg','呵呵',1);
insert  into tt_dept_user(user_name,first_name,last_name,password,dept_id,add_time,sex,email,phone,tel,birthday,address,id_card,image,remark,status)
VALUES ('mary','钱','六','123456',100001,NOW(),1,'jeremy@163.com','15207442209','075584351234',NOW(),'深圳','430525199902262738','D:/2.jpg','呵呵',1);
insert  into tt_dept_user(user_name,first_name,last_name,password,dept_id,add_time,sex,email,phone,tel,birthday,address,id_card,image,remark,status)
VALUES ('sam','小','五','123456',100002,NOW(),1,'jeremy@163.com','15207442209','075584351234',NOW(),'深圳','430525199902262738','D:/2.jpg','呵呵',1);
insert  into tt_dept_user(user_name,first_name,last_name,password,dept_id,add_time,sex,email,phone,tel,birthday,address,id_card,image,remark,status)
VALUES ('summer','小','张','123456',100003,NOW(),1,'jeremy@163.com','15207442209','075584351234',NOW(),'深圳','430525199902262738','D:/2.jpg','呵呵',1);
insert  into tt_dept_user(user_name,first_name,last_name,password,dept_id,add_time,sex,email,phone,tel,birthday,address,id_card,image,remark,status)
VALUES ('mine','小','朱','123456',100004,NOW(),1,'jeremy@163.com','15207442209','075584351234',NOW(),'深圳','430525199902262738','D:/2.jpg','呵呵',1);
insert  into tt_dept_user(user_name,first_name,last_name,password,dept_id,add_time,sex,email,phone,tel,birthday,address,id_card,image,remark,status)
VALUES ('sunny','杨','康','123456',100003,NOW(),1,'jeremy@163.com','15207442209','075584351234',NOW(),'深圳','430525199902262738','D:/2.jpg','呵呵',1);
insert  into tt_dept_user(user_name,first_name,last_name,password,dept_id,add_time,sex,email,phone,tel,birthday,address,id_card,image,remark,status)
VALUES ('only','朱','名','123456',100005,NOW(),1,'jeremy@163.com','15207442209','075584351234',NOW(),'深圳','430525199902262738','D:/2.jpg','呵呵',1);
insert  into tt_dept_user(user_name,first_name,last_name,password,dept_id,add_time,sex,email,phone,tel,birthday,address,id_card,image,remark,status)
VALUES ('user','中','国','123456',100003,NOW(),1,'jeremy@163.com','15207442209','075584351234',NOW(),'深圳','430525199902262738','D:/2.jpg','呵呵',1);
insert  into tt_dept_user(user_name,first_name,last_name,password,dept_id,add_time,sex,email,phone,tel,birthday,address,id_card,image,remark,status)
VALUES ('summy','王','强','123456',100004,NOW(),1,'jeremy@163.com','15207442209','075584351234',NOW(),'深圳','430525199902262738','D:/2.jpg','呵呵',1);
insert  into tt_dept_user(user_name,first_name,last_name,password,dept_id,add_time,sex,email,phone,tel,birthday,address,id_card,image,remark,status)
VALUES ('hony','赵','找','123456',100004,NOW(),1,'jeremy@163.com','15207442209','075584351234',NOW(),'深圳','430525199902262738','D:/2.jpg','呵呵',1);
insert  into tt_dept_user(user_name,first_name,last_name,password,dept_id,add_time,sex,email,phone,tel,birthday,address,id_card,image,remark,status)
VALUES ('apple','宋','家','123456',100004,NOW(),1,'jeremy@163.com','15207442209','075584351234',NOW(),'深圳','430525199902262738','D:/2.jpg','呵呵',1);
insert  into tt_dept_user(user_name,first_name,last_name,password,dept_id,add_time,sex,email,phone,tel,birthday,address,id_card,image,remark,status)
VALUES ('sunshine','小','成','123456',100002,NOW(),1,'jeremy@163.com','15207442209','075584351234',NOW(),'深圳','430525199902262738','D:/2.jpg','呵呵',1);
insert  into tt_dept_user(user_name,first_name,last_name,password,dept_id,add_time,sex,email,phone,tel,birthday,address,id_card,image,remark,status)
VALUES ('tony','小','阳','123456',100004,NOW(),1,'jeremy@163.com','15207442209','075584351234',NOW(),'深圳','430525199902262738','D:/2.jpg','呵呵',1);

drop TABLE if EXISTS  tt_role;
create table tt_role(
    role_id int not null auto_increment primary key,
    role_name varchar(20) UNIQUE,
    role_desc  VARCHAR(200)
)auto_increment=100000;

insert into tt_role(role_name,role_desc) values('部门经理','部门事务管理');
insert into tt_role(role_name,role_desc) values('人事经理','人员事务管理');
insert into tt_role(role_name,role_desc) values('财务经理','财务事务管理');
insert into tt_role(role_name,role_desc) values('市场经理','市场事务管理');
insert into tt_role(role_name,role_desc) values('股东经理','股东事务管理');
insert into tt_role(role_name,role_desc) values('学习部经理','股东事务管理');
drop table if exists tt_menu;
create table tt_menu(
    menu_id int not null  auto_increment PRIMARY key,
    menu_name VARCHAR(30) UNIQUE,
    menu_desc  varchar(200),
    menu_value  varchar(100) unique,
    father_menu_id int 
)auto_increment=100000;

insert into tt_menu(menu_name,menu_desc,menu_value,father_menu_id) values('部门管理','所有部门信息','http://localhost:8080/RBAC/loginConfirm#dept',1);
insert into tt_menu(menu_name,menu_desc,menu_value,father_menu_id) values('用户管理','所有用户信息','http://localhost:8080/RBAC/loginConfirm#user',1);
insert into tt_menu (menu_name,menu_desc,menu_value,father_menu_id)values('角色管理','所有角色信息','http://localhost:8080/RBAC/loginConfirm#role',1);
insert into tt_menu (menu_name,menu_desc,menu_value,father_menu_id) values('菜单管理','所有菜单信息','http://localhost:8080/RBAC/loginConfirm#menu',1);
insert into tt_menu (menu_name,menu_desc,menu_value,father_menu_id) values('角色人员管理','所有角色人员信息','http://localhost:8080/RBAC/loginConfirm#roleMem',1);
insert into tt_menu (menu_name,menu_desc,menu_value,father_menu_id) values('权限管理','所有权限信息','http://localhost:8080/RBAC/loginConfirm#authority',1);


insert into tt_menu (menu_name,menu_desc,menu_value,father_menu_id) VALUES ('部门增加','部门信息增加','http://localhost:8080/RBAC/Department/Department_add.jsp',100000);
insert into tt_menu (menu_name,menu_desc,menu_value,father_menu_id) VALUES ('部门维护','部门信息维护','http://localhost:8080/RBAC/selectDepartment',100000);

insert into tt_menu (menu_name,menu_desc,menu_value,father_menu_id) VALUES ('用户增加','用户信息增加','http://localhost:8080/RBAC/getDeptNameList',100001);
insert into tt_menu (menu_name,menu_desc,menu_value,father_menu_id) VALUES ('用户维护','用户信息维护','http://localhost:8080/RBAC/selectUser',100001);

insert into tt_menu (menu_name,menu_desc,menu_value,father_menu_id) VALUES ('角色增加','角色信息增加','http://localhost:8080/RBAC/Role/role_add.jsp',100002);
insert into tt_menu (menu_name,menu_desc,menu_value,father_menu_id) VALUES ('角色维护','角色信息维护','http://localhost:8080/RBAC/selectRole',100002);

insert into tt_menu (menu_name,menu_desc,menu_value,father_menu_id) VALUES ('菜单增加','菜单信息增加','http://localhost:8080/RBAC/selectFatherMenu',100003);
insert into tt_menu (menu_name,menu_desc,menu_value,father_menu_id) VALUES ('菜单维护','菜单信息维护','http://localhost:8080/RBAC/selectMenu',100003);

insert into tt_menu (menu_name,menu_desc,menu_value,father_menu_id) VALUES ('角色人员维护','角色人员信息维护','http://localhost:8080/RBAC/selectRoleUser',100004);


insert into tt_menu (menu_name,menu_desc,menu_value,father_menu_id) VALUES ('用户权限设置','用户菜单信息维护','http://localhost:8080/RBAC/selectUserMenu',100005);

insert into tt_menu (menu_name,menu_desc,menu_value,father_menu_id) VALUES ('部门权限设置','部门菜单信息维护','http://localhost:8080/RBAC/selectDeptMenu',100005);
insert into tt_menu (menu_name,menu_desc,menu_value,father_menu_id) VALUES ('角色权限设置','角色菜单信息维护','http://localhost:8080/RBAC/selectRoleMenu',100005);


select* from tt_menu;


drop table if exists tt_role_user;


create table tt_role_user(
    role_id int not null ,
    user_id int not null 
);


insert into tt_role_user (role_id,user_id) values(100000,100001);
insert into tt_role_user (role_id,user_id) values(100000,100002);

insert into tt_role_user (role_id,user_id) values(100001,100003);
insert into tt_role_user (role_id,user_id) values(100001,100004);
insert into tt_role_user (role_id,user_id) values(100002,100005);
insert into tt_role_user (role_id,user_id) values(100004,100006);
insert into tt_role_user (role_id,user_id) values(100003,100007);

insert into tt_role_user (role_id,user_id) values(100004,100008);
insert into tt_role_user (role_id,user_id) values(100004,100009);
insert into tt_role_user (role_id,user_id) values(100002,100011);

drop table if exists tt_user_menu;
create table tt_user_menu(
   user_id int not null,
   menu_id int not null
);

insert into tt_user_menu(user_id,menu_id) values(100000,100006);
insert into tt_user_menu (user_id,menu_id) values(100000,100007);
insert into tt_user_menu (user_id,menu_id) values(100000,100008);
insert into tt_user_menu (user_id,menu_id) values(100000,100009);
insert into tt_user_menu (user_id,menu_id) values(100000,1000010);
insert into tt_user_menu (user_id,menu_id) values(100000,100011);
insert into tt_user_menu (user_id,menu_id) values(100000,100012);
insert into tt_user_menu (user_id,menu_id) values(100000,100013);
insert into tt_user_menu (user_id,menu_id) values(100000,100014);
insert into tt_user_menu (user_id,menu_id) values(100000,100015);
insert into tt_user_menu (user_id,menu_id) values(100000,100016);
insert into tt_user_menu (user_id,menu_id) values(100000,100017);
insert into tt_user_menu (user_id,menu_id) values(100000,100018);

insert into tt_user_menu (user_id,menu_id) values(100001,100003);
insert into tt_user_menu (user_id,menu_id) values(100001,100004);
insert into tt_user_menu (user_id,menu_id) values(100002,100005);
insert into tt_user_menu  (user_id,menu_id) values(100004,100006);
insert into tt_user_menu (user_id,menu_id)  values(100003,100007);

insert into tt_role_user (role_id,user_id) values(100004,100008);
insert into tt_role_user (role_id,user_id) values(100004,100009);
insert into tt_role_user (role_id,user_id) values(100002,100011);


drop table if EXISTS  tt_dept_menu;
create table tt_dept_menu(
     dept_id int not null,
     menu_id int not null
);


insert into tt_dept_menu (dept_id,menu_id) values(100000,100002);

insert into tt_dept_menu (dept_id,menu_id) values(100001,100003);
insert into tt_dept_menu (dept_id,menu_id) values(100001,100004);
insert into tt_dept_menu (dept_id,menu_id) values(100002,100005);
insert into tt_dept_menu  (dept_id,menu_id) values(100004,100006);
insert into tt_dept_menu (dept_id,menu_id)  values(100003,100007);


drop table if exists tt_role_menu;
create table tt_role_menu(
  role_id int  not null,
  menu_id int not null
);


insert into tt_role_menu (role_id,menu_id) values(100000,100002);

insert into tt_role_menu (role_id,menu_id) values(100001,100003);
insert into tt_role_menu (role_id,menu_id) values(100001,100004);
insert into tt_role_menu (role_id,menu_id) values(100002,100005);
insert into tt_role_menu  (role_id,menu_id) values(100004,100006);
insert into tt_role_menu (role_id,menu_id)  values(100003,100007);


select  * from tt_dept;
select * from  tt_dept_user;
select * from tt_role;
select * from tt_role_user;
select * from tt_menu;

select * from tt_user_menu;

select * from tt_dept where 1=1 and dept_name like '%嘘唏%';

select * from tt_user_menu where user_id=100000 AND menu_id=100008;
select role_id,role_name,(select COUNT(*) from tt_role_user as t1 where t1.role_id =t2.role_id)as count from tt_role as t2  and t2.role_name like '%经理%'

select menu_id,menu_name from tt_menu where father_menu_id=1;
select menu_id,menu_name from tt_menu where father_menu_id=10000;
select * from tt_menu as t1, tt_user_menu as t2 where t1.father_menu_id=100000 and user_id =100000 and t1.menu_id=t2.menu_id;
select * from tt_menu as  t1 where t1.father_menu_id=100000;

select t2.dept_id,t2.dept_name,(select COUNT(*) from tt_dept_menu as t1 where t1.dept_id=t2.dept_id) as count  from tt_dept as t2 ORDER BY t2.dept_id;
select t2.role_id,t2.role_name,t2.role_desc,(select COUNT(*) from tt_role_menu as t1 where t1.role_id=t2.role_id) as count  from tt_role as t2 ORDER BY t2.role_id;


select t1.menu_name,t2.user_name from tt_menu as t1,tt_dept_user as t2,tt_user_menu as t3 where t1.menu_id=t3.menu_id and t2.user_id=t3.user_id and t2.user_name='admin';

select m.menu_id,m.menu_name from tt_menu m where menu_id in(select menu_id from tt_user_menu where user_id=(select user_id from tt_dept_user where user_name='admin'))
or menu_id in (select menu_id from tt_dept_menu where dept_id=(select dept_id from tt_dept_user where user_id=(select user_id from tt_dept_user where user_name='admin')))
or menu_id in (select menu_id from tt_role_menu where role_id in (select role_id from tt_role_user where user_id=(select user_id from tt_dept_user where user_name='admin')))

select t2.* ,(select CONCAT(first_name,last_name) from tt_dept_user as t1 where t1.user_id=t2.dept_mgr_id) as dept_manager from tt_dept as t2

1.简单实用的html模板框架

2.只采用简单的jsp+servlet+mysql+json+ajax技术，适用简单初学者来参考学习

3.表单提交使用js，validateForm校验

4.输入框采用了时间日期控件，省市区三级联动的基本控件。 <p>5.基本实现mvc模式，实现数据业务页面分层

jsp+servlet+mysql+json+ajax开发的java权限管理系统，包括项目需求

jsp+servlet+mysql+json+ajax开发的java权限管理系统，包括项目需求jsp+servlet+mysql+json+ajax开发的java权限管理系统，包括项目需求

猜你喜欢

打赏

最代码分享评论总数11个评论 最代码分享牛币数5个牛币 AJAX用户角色权限管理系统 Java
文件名:RBAC.rar,文件大小:6340.04K 下载
  • /
      • /RBAC
        • /RBAC/.classpath
        • /RBAC/.project
          • /RBAC/.settings
            • /RBAC/.settings/.jsdtscope
            • /RBAC/.settings/org.eclipse.core.resources.prefs
            • /RBAC/.settings/org.eclipse.jdt.core.prefs
            • /RBAC/.settings/org.eclipse.wst.common.component
            • /RBAC/.settings/org.eclipse.wst.common.project.facet.core.xml
            • /RBAC/.settings/org.eclipse.wst.jsdt.ui.superType.container
            • /RBAC/.settings/org.eclipse.wst.jsdt.ui.superType.name
最代码相关代码源代码列表相关代码
最代码最近下载分享源代码列表最近下载
xaiozhu  LV7 2021年6月28日
小安同学  LV7 2021年6月18日
zxl201377  LV2 2021年6月5日
liusha625184071  LV13 2021年6月5日
陈若愚  LV4 2021年5月14日
yuting Wang  LV9 2021年5月12日
米奇LOVE  LV4 2021年4月29日
子非鱼 淡  LV6 2020年12月23日
runningjoice  LV2 2020年12月17日
77198453  LV1 2020年11月15日
最代码最近浏览分享源代码列表最近浏览
陈小灏  LV15 6月23日
15719908287  LV9 6月19日
zn2020  LV1 2023年12月19日
wxhua198  LV5 2023年11月30日
2036495585  LV9 2023年9月25日
xuweiwowzy  LV5 2023年9月21日
mumucfvbnm 2023年9月17日
暂无贡献等级
王毅麟  LV1 2023年8月23日
顶部 客服 微信二维码 底部
>扫描二维码关注最代码为好友扫描二维码关注最代码为好友
帮助|联系我|友情链接|网站地图|RSS订阅分享源代码|RSS订阅问答|最新分享源代码|最新问答 京ICP备12032064号-2