賓館客房管理系統(tǒng)--數(shù)據(jù)庫(kù)課程設(shè)計(jì)-在線瀏覽
2025-08-08 17:48本頁(yè)面
【正文】 ), cid char(18), rid char(6) not null, rstyle varchar(10), arrivetime datetime, o char(10) not null, dingname varchar(10), livetime char(10), dingph char(15) not null, ozt char(4))gocreate table hliveorder /*創(chuàng)建數(shù)據(jù)表hliveorder*/(lno varchar(36) not null, rid char(6) not null, rstyle varchar(10), btime datetime not null, o char(10), ame varchar(10) not null, etime datetime, ono varchar(36), lzt char(4) )goinsert into cusinfo values(39。,39。,39。,39。)insert into cusinfo values(39。,39。,39。,39。)goinsert into roominfo values(39。,39。,39。)insert into roominfo values(39。,39。,39。)insert into roominfo values(39。,39。,39。) insert into roominfo values(39。,39。,39。) insert into roominfo values(39。,39。,39。)insert into roominfo values(39。,39。,39。)insert into roominfo values(39。,39。,39。)insert into roominfo values(39。,39。,39。)insert into roominfo values(39。,39。,39。)insert into roominfo values(39。,39。,39。)insert into roominfo values(39。,39。,39。)insert into roominfo values(39。,39。,39。)goinsert into roomsp values(39。,200)insert into roomsp values(39。,300)go insert into ordform values(39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。)goinsert into liveorder values(39。,39。,39。,39。,39。,39。,39。,39。,39。)insert into liveorder values(39。,39。,39。,39。,39。,39。,39。,39。,39。)insert into liveorder(lno,rid,rstyle,btime,o,ame,ono,lzt) values(39。,39。,39。,39。,39。,39。,39。,39。)insert into liveorder(lno,rid,rstyle,btime,o,ame,ono,lzt)values(39。,39。,39。,39。,39。,39。,null,39。)goinsert into bill(bno,rid,ame,cust,btime) values(39。,39。,39。,0,39。)insert into bill(bno,rid,ame,cust,btime) values(39。,39。,39。,0,39。)goalter table cusinfo add primary key(dingname)alter table ordform add primary key(ono)alter table roominfo add primary key(rid)alter table liveorder add primary key(lno)alter table bill add primary key(bno)alter table roomsp add primary key(rstyle)gocreate proc ordformproc lno varchar(36) /*保存入住單*/asbegin tranupdate roominfo set kfzt=39。 from roominfo,liveorder where = and =lno /*修改客房信息*/update ordform set ozt=39
畢業(yè)設(shè)計(jì)相關(guān)推薦
鄂ICP備17016276號(hào)-1