use Vistors;
select * from Guest;
select * from Reservations;
select * from Transactions;
select * from Server;
insert into Guest values('123456789098765432','王二','(123)456-1111','11111-1111','中国');
delete from Guest where GuestName='王二';
Select G.GuestId,G.GuestName,G.GuestPhone,G.GuestCodezip,R.RoomNo,R.RoomType,R.AtDate,R.FromDate,R.ToDate,R.days
From Guest as G,Reservations as R Where G.GuestId=R.GuestId AND G.GuestName='王二'
select * from Room;
insert into Reservations values('123456789098765432','DX-001','DX','08/15/2004','08/16/2004','08/17/2004','1','','','');
delete from Reservations where GuestId= '123456789098765432';
select T.GuestId,S.ServerName,T.AtDate
from Reservations as R,Server as S,Transactions as T where R.GuestId=T.GuestId and T.ServerId=S.ServerId and R.RoomNo='王二'
select * from Server
insert into Transactions values('123456789098765432','02','08/17/2004');
shujuku.rar_java shujuku_旅店登记系统
版权申诉
2 浏览量
2022-09-24
02:58:12
上传
评论
收藏 454KB RAR 举报
shujuku.rar （83个子文件） 
数据库课程设计 
Hotel1.sql 17KB bin com ServerUpdate.class 3KB DeleteServer.class 1KB BookCancelTabPane.class 3KB ServerUpdateSuccess$MyActionListener.class 718B ServerUpdateSuccess.class 1KB NGuestSearch$MyActionListener.class 2KB BookReworkTabPane$MyActionListener.class 4KB RoomtypesUpdate$MyActionListener.class 3KB RoomtypesUpdateFault$MyActionListener.class 724B RoomEnrollTabPane$cancel_ActionListener.class 1KB RoomReturnTabPane$cancel_ActionListener.class 892B Hotel.class 3KB RoomtypesUpdate.class 3KB AddServer$MyActionListener.class 658B GuestNumber$MyActionListener.class 2KB BookCancelTabPane$MyActionListener.class 3KB RoomtypesUpdateFault.class 1KB EmptyDXRoom.class 2KB SerList$MyActionListener.class 2KB RoomtypesUpdateSuccess.class 1KB RoomReturnTabPane.class 4KB ServerCostEnrollTabPane.class 5KB BookReworkTabPane$cancel_ActionListener.class 929B RGuestSearch$MyActionListener.class 2KB AddServer.class 1KB RoomEnrollTabPane$MyActionListener.class 5KB SerSearch.class 3KB BookCancelTabPane$cancel_ActionListener.class 892B Hotel$1.class 642B ServerUpdateFault.class 1KB SerList.class 3KB EmptyRoom.class 2KB RoomtypesUpdateSuccess$MyActionListener.class 736B EmptyGRRoom.class 2KB GuestNumber.class 4KB BookReworkTabPane.class 4KB ServerCostEnrollTabPane$MyActionListener.class 6KB RGuestSearch.class 3KB SerSearch$MyActionListener.class 2KB NGuestSearch.class 3KB ServerCostEnrollTabPane$cancel_ActionListener.class 934B ServerUpdateFault$MyActionListener.class 706B util DBHelp.class 2KB DeleteServer$MyActionListener.class 676B RoomReturnTabPane$MyActionListener.class 4KB ServerList.class 2KB RoomEnrollTabPane.class 7KB RoomtypesList.class 2KB ServerUpdate$MyActionListener.class 3KB RoomCount.class 3KB
新建文本文档.txt 938B
mssqlserver.jar 66KB msbase.jar 280KB msutil.jar 58KB src com SerSearch.java 3KB NGuestSearch.java 3KB RoomtypesUpdateSuccess.java 793B RoomReturnTabPane.java 5KB ServerUpdate.java 4KB RoomtypesUpdate.java 4KB RGuestSearch.java 3KB DeleteServer.java 770B RoomEnrollTabPane.java 6KB BookReworkTabPane.java 4KB GuestNumber.java 3KB Hotel.java 6KB RoomtypesList.java 2KB EmptyDXRoom.java 2KB AddServer.java 767B ServerList.java 2KB RoomtypesUpdateFault.java 800B ServerUpdateFault.java 800B BookCancelTabPane.java 4KB RoomCount.java 1KB EmptyGRRoom.java 2KB EmptyRoom.java 2KB util DBHelp.java 1KB SerList.java 3KB ServerUpdateSuccess.java 787B ServerCostEnrollTabPane.java 9KB .project 397B .classpath 384B资源评论
