资源描述：
《数据库课程设计程序代码(宾馆客房管理系统)》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、createdatabasehotelmanager/*创建数据库hotelmanager*/gousehotelmanagergocreatetablecusinfo/*创建数据表cusinfo*/(dingnamevarchar(10)notnull,cnamevarchar(10),cidchar(18),vipchar(2))gocreatetableordform/*创建数据表ordform*/(onovarchar(36)notnull,cnamevarchar(10)notnull,csexchar(2),ci
2、dchar(18),ridchar(6)notnull,rstylevarchar(10),arrivetimedatetime,cnochar(10)notnull,dingnamevarchar(10),livetimechar(10),dingphchar(15)notnull,oztchar(4))gocreatetableroominfo/*创建数据表roominfo*/(ridchar(6)notnull,rstylevarchar(10),kfztchar(2)notnull)gocreatetablelive
3、order/*创建数据表liveorder*/(lnovarchar(36)notnull,ridchar(6)notnull,rstylevarchar(10),btimedatetimenotnull,cnochar(10),cnamevarchar(10)notnull,etimedatetime,onovarchar(36),lztchar(4))gocreatetablebill/*创建数据表bill*/(bnovarchar(36)notnull,ridchar(6)notnull,cnamevarchar(10
4、),custmoney,btimedatetime,etimedatetime,remarksvarchar(40))gocreatetableroomsp/*创建数据表roomsp*/(rstylevarchar(10)notnull,rpricemoney)gocreatetablehordform/*创建数据表hordform*/(onovarchar(36)notnull,cnamevarchar(10)notnull,csexchar(2),cidchar(18),ridchar(6)notnull,rstylev
5、archar(10),arrivetimedatetime,cnochar(10)notnull,dingnamevarchar(10),livetimechar(10),dingphchar(15)notnull,oztchar(4))gocreatetablehliveorder/*创建数据表hliveorder*/(lnovarchar(36)notnull,ridchar(6)notnull,rstylevarchar(10),btimedatetimenotnull,cnochar(10),cnamevarchar
6、(10)notnull,etimedatetime,onovarchar(36),lztchar(4))goinsertintocusinfovalues('mao','zcl','330227198805060071','n')insertintocusinfovalues('qxb','zyy','330227198603070022','n')goinsertintoroominfovalues('2010','s','n')insertintoroominfovalues('2201','s','n')inserti
7、ntoroominfovalues('2301','s','n')insertintoroominfovalues('3010','s','y')insertintoroominfovalues('3012','s','n')insertintoroominfovalues('3015','s','n')insertintoroominfovalues('4210','d','n')insertintoroominfovalues('4110','d','n')insertintoroominfovalues('4010',
8、'd','n')insertintoroominfovalues('5220','d','n')insertintoroominfovalues('5210','d','n')insertintoroominfovalues('5201','d','n')goinsertintorooms
