酒店預訂系統(前后臺)(編輯修改稿)

　

【文章內容簡介】 ), 單價oi_remark varchar2(100) default 39。無39。 備注信息)select * from hotel_oinfo order by r_id。drop table hotel_oinfo。delete from hotel_oinfoinsert into hotel_oinfo values(,100000,1000,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100000,1001,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100000,1003,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100001,1005,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100002,1004,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100003,1002,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100004,1007,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100005,1006,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100006,1008,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100007,1009,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100007,1010,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100008,1011,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100009,1012,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100010,1013,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100011,1014,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100012,1015,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。insert into hotel_oinfo values(,100013,1016,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。無39。)。mit。事務處理同事插入begin savepoint point1。 insert into hotel_oinfo values(,1000,39。20130728 12:00:0039。,39。20130728 12:00:0039。,10000,39。已付款39。,39。無39。)。 insert into hotel_olist values(,hotel_oinfo_id,39。admin39。,39。20130726 12:00:0039。,39。無39。,39。預定中39。,39。無39。)。 mit。 exception when others then rollback work to savepoint point1。 end。 create sequence hotel_assess_id START WITH 1 序列的開始位置(開始位置不能被修改) INCREMENT BY 1 間隔為 1 MAXVALUE 99999999 最大值 CACHE 30 緩存 NOCACHE （沒有緩存） NOCYCLE 不循環 CYCLE（循環） drop sequence hotel_assess_id。（用于保存客戶點評）hotel_assesscreate table hotel_assess(a_id number(10) primary key , 留言編號ad_name varchar2(20), 留言客戶名reply varchar(200) , 酒店回復detail varchar(300) 客戶留言)select * from hotel_assess。drop table hotel_assess。insert into hotel_assess values(,39。admin39。,39。39。,39。卓京國際商務酒店服務還不錯啊！39。)。insert into hotel_assess values(,39。admin39。,39。39。,39。卓京國際商務酒店環境真的還不錯啊！39。)。insert into hotel_assess values(,39。admin39。,39。39。,39。住的很開心！39。)。insert into hotel_assess values(,39。admin39。,39。謝謝您的建議，我們會努力的！39。,39。訂房有點復雜！希望能改好些！39。)。insert into hotel_assess values(,39。admin39。,39。39。,39。卓京國際商務酒店，整體來說還不錯的，以后常來！39。)。insert into hotel_assess values(,39。admin39。,39。39。,39。越來越好！39。)。insert into hotel_assess values(,39。admin39。,39。39。,39。什么亂七八糟的酒店嗎！39。)。insert into hotel_assess values(,39。admin39。,39。39。,39。服務態度不怎么好！39。)。insert into hotel_assess values(,39。admin39。,39。39。,39。卓京國際商務酒店很給力啊！！39。)。insert into hotel_assess values(,39。admin39。,39。39。,39。卓京國際商務酒店很給力啊！哈哈！39。)。insert into hotel_assess values(,39。admin39。,39。39。,39。飯菜不給力！39。)。mit。create sequence hotel_notice_id START WITH 1 序列的開始位置(開始位置不能被修改) INCREMENT BY 1 間隔為 1 MAXVALUE 99999999 最大值 CACHE 30 緩存 NOCACHE （沒有緩存） NOCYCLE 不循環 CYCLE（循環） drop sequence hotel_notice_id。，活動信息表 (保存酒店發布的公告活動通知)hotel_noticecreate table hotel_notice(n_id number(10) primary key , 編號n_title varchar2(20) not null, 發布的題目n_time varchar2(20) not null, 發布的時間n_picture varchar2(50) ,n_detailes varchar(500) not null 保存發布的內容)select * from hotel_notice。drop table hotel_notice。insert into hotel_notice values(,39。訂酒店返現金39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動情況39。)。insert into hotel_notice values(,39。七天暢游暑假39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動情況39。)。insert into hotel_notice values(,39。幸運抽獎39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動情況39。)。insert into hotel_notice values(,39。99元特惠房39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動情況39。)。insert into hotel_notice values(,39。訂酒店返現金39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動情況39。)。insert into hotel_notice values(,39。七天暢游暑假39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動情況39。)。insert into hotel_notice values(,39。幸運抽獎39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動情況39。)。insert into hotel_notice values(,39。99元特惠房39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動情況39。)。insert into hotel_notice values(,39。訂酒店返現金39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動情況39。)。insert into hotel_notice values(,39。七天暢游暑假39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動情況39。)。insert into hotel_notice values(,39。幸運抽獎39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動情況39。)。insert into hotel_notice values(,39。99元特惠房39。,39。20130801 12:00:0039。,39。img/39。,39。八月最新活動情況39。)。mit。create sequence hotel_introduce_id START WITH 1 序列的開始位置(開始位置不能被修改) INCREMENT BY 1 間隔為 1 MAXVALUE 99999999 最大值 CACHE 30 緩存 NOCACHE （沒有緩存） NOCYCLE 不循環 CYCLE（循環） drop sequence hotel_introduce_id。11,酒店介紹信息create table hotel_introduce(i_id number(10) primary key, 編號i_title varchar2(100), 標題i_detail varchar2(800), 詳細介紹i_remark varchar2(200) 備注)select * from hotel_introduceselect count(*) from hotel_introducedrop table hotel_introduceinsert into hotel_introduce values(,39。酒店背景介紹39。,39。客房寬敞