基于J2EE的酒店客房網(wǎng)上預(yù)訂與管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)畢業(yè)論文

1、§§§序號(hào)列名類(lèi)型長(zhǎng)度小數(shù)可空說(shuō)明1noticeIdint110否公告ID2noticeDatetimestamp160否公告發(fā)布日期3issuervarchar160否發(fā)布人4contentvarchar8003否公告內(nèi)容5titlevarchar200否公告標(biāo)題序號(hào)列名類(lèi)型長(zhǎng)度小數(shù)可空說(shuō)明1hotelIdint110否主鍵ID2hotelPicturevarchar1000否酒店圖片3hotelNamevarchar1000否酒店名稱(chēng)4businessNovarchar150否工商企業(yè)編號(hào)5hoteltypeIdint110否酒店級(jí)別ID6cityvarcha

2、r100否酒店所在城市7hotelAddressvarchar2000否具體地址8servicevarchar5000是酒店服務(wù)9entertainmentvarchar5000是娛樂(lè)項(xiàng)目10reservePhonevarchar120否預(yù)訂 11facilitiesvarchar3000是酒店配置12specialDietvarchar3000是飲食服務(wù)13introductionvarchar5000是酒店簡(jiǎn)介14opentimevarchar200是開(kāi)業(yè)時(shí)間15hotelPricedouble102否預(yù)訂價(jià)格序號(hào)列名類(lèi)型長(zhǎng)度小數(shù)可空說(shuō)明1roomIdint110否主鍵ID2roomtyp

3、eIdint110否客房類(lèi)型ID3roomStandardvarchar1000否客房配置4roomNumberint110否可預(yù)訂數(shù)量5roomPricedouble102否價(jià)格6discountvarchar1000是優(yōu)惠政策7hotelIdint110否所屬酒店8roomPicturevarchar200是客房圖片序號(hào)列名類(lèi)型長(zhǎng)度小數(shù)可空說(shuō)明1reserveIdint110否預(yù)訂ID2reserveDatetimestamp00否預(yù)定日期3residentNamevarchar200否預(yù)訂人姓名4residentPhonevarchar163否聯(lián)系 5reserveTypevarchar

4、200否預(yù)訂客房類(lèi)型6checkinDatetimestamp00否入住日期7ordersNumberint110否預(yù)訂房間數(shù)8checkoutDatetimestamp00否退房日期序號(hào)列名類(lèi)型長(zhǎng)度小數(shù)可空說(shuō)明1idint110否主鍵ID2usernamevarchar160否用戶(hù)名3passwordvarchar160否密碼4namevarchar320是姓名5sexvarchar20是性別6phonevarchar160是手機(jī)號(hào)碼7emailvarchar640是電子郵箱8registDatetimestamp00是注冊(cè)日期9latestDatetimestamp00是最近登錄日期10loginNumberint110是登錄次數(shù)用戶(hù)名用戶(hù)密碼權(quán)限測(cè)試結(jié)果a11111a11111用戶(hù)顯示主界面空空用戶(hù)提示輸入信息a11111空用戶(hù)提示輸入密碼a11111111111用戶(hù)密碼錯(cuò)誤a1111