最代码位
jeremygilbert的gravatar头像
jeremygilbert2016-01-06 08:46:16

龙8国际娱乐pt老虎机

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.龙8国际娱乐pt老虎机实用的html模板框架

2.只采用龙8国际娱乐pt老虎机的jsp+servlet+mysql+json+ajax技术,适用龙8国际娱乐pt老虎机初学者来参考学习

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

4.输入框采用了时间日期控件,省市区三级联动的基本控件。 <p>5.基本实现mvc模式,实现龙8国际娱乐官方网站业务页面分层

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

jsp+servlet+mysql+json+ajax开发的java权限管理系统,包括项目需求jsp+servlet+mysql+json+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
最代码最近下载分享源代码列表最近下载
小肥羊 LV131月10日
月亮月亮月亮星星
2323552609 LV62019年12月25日
月亮星星星星
zhang5712 LV12019年12月23日
星星
t19611321 LV42019年12月22日
月亮
adminima LV42019年12月5日
月亮
yjk199733 LV22019年11月19日
星星星星
1450747406 LV62019年11月8日
月亮星星星星
半白易 LV22019年10月30日
星星星星
hcyhard LV72019年10月18日
月亮星星星星星星
sunlei56841 LV102019年9月23日
月亮月亮星星星星
最代码最近浏览分享源代码列表最近浏览
hehe264 LV181月17日
太阳星星星星
小猪猪 LV121月16日
月亮月亮月亮
pk316550625 LV11月12日
星星
小肥羊 LV131月10日
月亮月亮月亮星星
abclini LV11月9日
星星
zhu_terry1月8日
暂无贡献等级
Tsll520 LV41月7日
月亮
zhangshuhang LV11月6日
星星
暂无贡献等级
635969151 LV91月5日
月亮月亮星星
顶部客服微信二维码底部
>扫描二维码关注最代码为好友扫描二维码关注最代码为好友