查询1.sql

酒店管理系统后台数据库存储过程

select                  20011,'B3011','标准',200,180,0,'三楼','向阳','可以看海'   union
select                  20012,'B3012','标准',200,180,0,'三楼','背阳',''   union
select                  20013,'B3013','标准',200,180,0,'三楼','向阳','可以看海'   union
select                  20014,'B3014','标准',200,180,0,'三楼','背阳',''   union
select                  20015,'B3015','标准',200,180,0,'三楼','向阳','可以看海'   union
select                  20016,'B3016','标准',200,180,0,'三楼','背阳',''   union
select                  20017,'B3017','标准',200,180,0,'三楼','向阳','可以看海'   union
select                  20018,'B3018','标准',200,180,0,'三楼','背阳',''   union
select                  20019,'B3019','标准',200,180,0,'三楼','向阳','可以看海'   union
select                  20020,'B3020','标准',200,180,0,'三楼','背阳',''  


--插入豪华房间数据
insert into roomstatus (id,roomNo ,class ,standardpri,rebatepri,onuse,place,roomIntro,remark)
select                  30001,'A4001','豪华',320,260,0,'四楼','向阳','可以看海看日出'   union
select                  30002,'A4002','豪华',320,260,0,'四楼','背阳','可以燕山夕阳西下'   union
select                  30003,'A4003','豪华',320,260,0,'四楼','向阳','可以看海看日出'   union
select                  30004,'A4004','豪华',320,260,0,'四楼','背阳','可以燕山夕阳西下'   union
select                  30005,'A4005','豪华',320,260,0,'四楼','向阳','可以看海看日出'   union
select                  30006,'A4006','豪华',320,260,0,'四楼','背阳','可以燕山夕阳西下'   union
select                  30007,'A4007','豪华',320,260,0,'四楼','向阳','可以看海看日出'   union
select                  30008,'A4008','豪华',320,260,0,'四楼','背阳','可以燕山夕阳西下'   union
select                  30009,'A4009','豪华',320,260,0,'四楼','向阳','可以看海看日出'   union
select                  30010,'A4010','豪华',320,260,0,'四楼','背阳','可以燕山夕阳西下'   union
select                  30011,'A4011','豪华',320,260,0,'四楼','向阳','可以看海看日出'   union
select                  30012,'A4012','豪华',320,260,0,'四楼','背阳','可以燕山夕阳西下'   union
select                  30013,'A4013','豪华',320,260,0,'四楼','向阳','可以看海看日出'  union
select                  30014,'A4014','豪华',320,260,0,'四楼','背阳','可以燕山夕阳西下'   union
select                  30015,'A4015','豪华',320,260,0,'四楼','向阳','可以看海看日出'   union
select                  30016,'A4016','豪华',320,260,0,'四楼','背阳','可以燕山夕阳西下'   union
select                  30017,'A4017','豪华',320,260,0,'四楼','向阳','可以看海看日出'   union
select                  30018,'A4018','豪华',320,260,0,'四楼','背阳','可以燕山夕阳西下'   union
select                  30019,'A4019','豪华',320,260,0,'四楼','向阳','可以看海看日出'   union
select                  30020,'A4020','豪华',320,260,0,'四楼','背阳','可以燕山夕阳西下'  


select * from roomstatus


insert into admin (id,name,password,remark)
values            (201,'admin','000','普通管理员')

insert into admin (id,name,password,remark)
values            (101,'boss','999','系统管理员')

select * from admin

select * from Employee

insert into employee (id,name,sex,age,idcard,native,address,phone,title)
values      ('SH1001','张飞','男',35,'130130197205661647','河北省秦皇岛市山海关区','山海关区上海道海天驾校','13933556745','总经理')

insert into employee (id,name,sex,age,idcard,native,address,phone,title)
select      'SH2001','赵云','男',32,'130130197505665621','河北省秦皇岛市山海关区','山海关区上海道谨海家园','13933556743','副经理' union
select      'SH2002','刘彩霞','女',28,'130130198005666821','河北省秦皇岛市',      '山海关区上海道谨海家园','13933556742','副经理' union
select      'SH2003','韩恩达','男',28,'130130198005664561','河北省秦皇岛市卢龙',  '山海关区上海道谨海家园','13933556740','大堂经理' union
select      'SH2004','刘建平','男',27,'130130198005665621','河北省秦皇岛市山海关区','山海关区上海道船厂','13933556739','客房经理' 



insert into employee (id,name,sex,age,idcard,native,address,phone,title,remark)
select      'SH2005','宗朋','男',32,'130130197505665621','河北省秦皇岛市山海关区','山海关区上海道谨海家园','13933556743','后勤部经理',null union
select      'SH3001','赵非','男',32,'130130197505665621','河北省秦皇岛市山海关区','山海关区上海道谨海家园','13933556743','一楼层部长',null 

insert into employee (id,name,sex,age,idcard,native,address,phone,title,remark)
select      'SH3002','宋士杰','男',25,'130130198205665621','河北省秦皇岛市青龙','山海关区上海道谨海家园','13933556743','二楼层经理',null union
select      'SH3003','李逵','男',25,'130130198205665621','河北省秦皇岛市青龙','山海关区上海道谨海家园','13933556743','三楼层经理',null union
select      'SH3005','小光','女',25,'130130197505665621','河北省秦皇岛市山海关区','山海关区上海道谨海家园','13933556743','副经理',null 



insert into employee (id,name,sex,age,idcard,native,address,phone,title,remark)
select      'SH4001','一楼部长1','男',32,'130130197505665621','河北省秦皇岛市山海关区','山海关区上海道谨海家园','13933556743','一楼部长1',null union
select      'SH4002','一楼部长2','男',32,'130130197505665621','河北省秦皇岛市','山海关区上海道老龙头','13933556743','一楼部长2',null union
select      'SH4003','二楼部长1','男',32,'130130197505665621','河北省秦皇岛市山海关区','山海关区上海道谨海家园','13933556743','二楼部长1',null union
select      'SH4004','二楼部长2','男',32,'130130197505665621','河北省秦皇岛市','山海关区上海道老龙头','13933556743','二楼部长2',null union
select      'SH4005','三楼部长1','男',32,'130130197505665621','河北省秦皇岛市山海关区','山海关区上海道谨海家园','13933556743','三楼部长1',null union
select      'SH4006','三楼部长2','男',32,'130130197505665621','河北省秦皇岛市','山海关区上海道老龙头','13933556743','三楼部长2',null union
select      'SH4007','四楼部长1','男',32,'130130197505665621','河北省秦皇岛市山海关区','山海关区上海道谨海家园','13933556743','四楼部长1',null union
select      'SH4008','四楼部长2','男',32,'130130197505665621','河北省秦皇岛市','山海关区上海道老龙头','13933556743','四楼部长2',null 




insert into employee (id,name,sex,age,idcard,native,address,phone,title)
select      'SH5001','一楼服务员1','女',32,'130130197505665621','河北省秦皇岛市山海关区','山海关区上海道谨海家园','13933556743','一楼服务员' union
select      'SH5002','一楼服务员2','女',28,'130130198005666821','河北省秦皇岛市',      '山海关区上海道谨海家园','13933556742','一楼服务员' union
select      'SH5003','一楼服务员3','男',28,'130130198005664561','河北省秦皇岛市卢龙',  '山海关区上海道谨海家园','13933556740','一楼服务员' union
select      'SH5004','一楼服务员4','男',27,'130130198005665621','河北省秦皇岛市山海关区','山海关区上海道船厂','13933556739','一楼服务员'  union 
select      'SH5005','一楼服务员5','女',28,'130130198005666821','河北省秦皇岛市',      '山海关区上海道谨海家园','13933556742','一楼服务员'




insert into employee (id,name,sex,age,idcard,native,address,phone,title)
select      'SH5021','二楼服务员1','女',32,'130130197505665621','河北省秦皇岛市山海关区','山海关区上海道谨海家园','13933556743','二楼服务员' union
select      'SH5022','二楼服务员2','女',28,'130130198005666821','河北省秦皇岛市',      '山海关区上海道谨海家园','13933556742','二楼服务员' union
select      'SH5023','二楼服务员3','男',28,'130130198005664561','河北省秦皇岛市卢龙',  '山海关区上海道谨海家园','13933556740','二楼服务员' union
select      'SH5024','二楼服务员4','男',27,'130130198005665621','河北省秦皇岛市山海关区','山海关区上海道船厂','13933556739','二楼服务员'  union 
select      'SH5025','二一楼服务员5','女',28,'130130198005666821','河北省秦皇岛市',      '山海关区上海道谨海家园','13933556742','二楼服务员'



insert into employee (id,name,sex,age,idcard,native,address,phone,title)
select      'SH5031','三楼服务员1','女',32,'130130197505665621','河北省秦皇岛市山海关区','山海关区上海道谨海家园','13933556743','三楼服务员' union
select      'SH5032','三楼服务员2','女',28,'130130198005666821','河北省秦皇岛市',      '山海关区上海道谨海家园','13933556742','三楼服务员' union
select      'SH5033','三楼服务员3','男',28,'130130198005664561','河北省秦皇岛市卢龙',  '山海关区上海道谨海家园','13933556740','三楼服务员' union
select      'SH5034','三楼服务员4','男',27,'130130198005665621','河北省秦皇岛市山海关区','山海关区上海道船厂','13933556739','三楼服务员'  union 
select      'SH5035','三楼服务员5','女',28,'130130198005666821','河北省秦皇岛市',      '山海关区上海道谨海家园','13933556742','三楼服务员'



insert into employee (id,name,sex,age,idcard,native,address,phone,title)
select      'SH5041','四楼服务员1','女',32,'130130197505665621','河北省秦皇岛市山海关区','山海关区上海道谨海家园','13933556743','四楼服务员' union
select      'SH5042','四楼服务员2','女',28,'130130198005666821','河北省秦皇岛市',      '山海关区上海道谨海家园','13933556742','四楼服务员' union
select      'SH5043','四楼服务员3','男',28,'130130198005664561','河北省秦皇岛市卢龙',  '山海关区上海道谨海家园','13933556740','四楼服务员' union
select      'SH5044','四楼服务员4','男',27,'130130198005665621','河北省秦皇岛市山海关区','山海关区上海道船厂','13933556739','四楼服务员'  union 
select      'SH5045','四楼服务员5','女',28,'130130198005666821','河北省秦皇岛市',      '山海关区上海道谨海家园','13933556742','四楼服务员'


select * from Employee