軟件工程課程設(shè)計(jì)酒店管理系統(tǒng)

1、 軟件工程課程設(shè)計(jì)報(bào)告軟件工程課程設(shè)計(jì)報(bào)告班級(jí)：班級(jí)：軟件軟件 xxx 姓名：姓名：xxx 學(xué)號(hào)：學(xué)號(hào)：xx4 指導(dǎo)教師：指導(dǎo)教師： 郭鵬飛郭鵬飛 遼寧工程技術(shù)大學(xué)軟件學(xué)院 目目錄錄1 1 設(shè)計(jì)內(nèi)容設(shè)計(jì)內(nèi)容 .1 12 2 概要設(shè)計(jì)概要設(shè)計(jì) .1 12.1 數(shù)據(jù)庫設(shè)計(jì) .12.1.1 數(shù)據(jù)庫 e-r 圖.12.1.2 .12.1.3 數(shù)據(jù)庫表設(shè)計(jì).22.2 邏輯結(jié)構(gòu)設(shè)計(jì) .22.2.1 酒店管理系統(tǒng)數(shù)據(jù)流圖.22.2.2 數(shù)據(jù)字典.33 3 詳細(xì)設(shè)計(jì)詳細(xì)設(shè)計(jì) .4 44 4 程序源碼程序源碼 .5 54.1 客房申請(qǐng) .54.2 退房申請(qǐng) .64.3 查看 .95 5 程序運(yùn)行與調(diào)試程序運(yùn)行與

2、調(diào)試 .9 95.1 酒店入住頁面 .95.2 退房 .105.3 查詢 .106 6 總結(jié)總結(jié) .1111參考文獻(xiàn)參考文獻(xiàn).1212成績評(píng)定成績評(píng)定.1212 01 設(shè)計(jì)內(nèi)容酒店管理系統(tǒng)：實(shí)現(xiàn)住房，退房，住房人數(shù)統(tǒng)計(jì)等功能2 概要設(shè)計(jì)2.1 數(shù)據(jù)庫設(shè)計(jì)2.1.1 數(shù)據(jù)庫 e-r 圖圖 2-1 e-r2.1.2住戶（序號(hào)，姓名，性別，身份證號(hào)）房間（房號(hào)，類型，人數(shù)）所住（序號(hào)，房號(hào)）所住房間房號(hào)類型房號(hào)序號(hào)序號(hào)身份證號(hào)姓名住戶性別n1人數(shù) 12.1.3 數(shù)據(jù)庫表設(shè)計(jì)表 2-1 住戶-person列名列名（table）類型長度非空序號(hào)numberint4是姓名namevarchar20是性別s

3、exchar4否身份證號(hào)idint18是表 2-2 房間-room列名列名（table）類型長度非空房號(hào)roomidint4是類型typevarchar4否人數(shù)numint4否表 2-3 所住-relax列名列名（table）類型長度非空序號(hào)numberint4是房號(hào)idint4是2.2 邏輯結(jié)構(gòu)設(shè)計(jì)2.2.1 酒店管理系統(tǒng)數(shù)據(jù)流圖酒店管理系統(tǒng)數(shù)據(jù)流圖圖 2-2 數(shù)據(jù)流圖房間檢查住房信息住房信息管理員統(tǒng)計(jì)信息住房標(biāo)識(shí)人數(shù)統(tǒng)計(jì)退房標(biāo)識(shí)結(jié)賬處理退房房間房間信息結(jié)賬款項(xiàng)退房申請(qǐng)住房信息住房申請(qǐng)入住系統(tǒng)住戶 22.2.2 數(shù)據(jù)字典圖 2-3圖 2-4圖 2-5圖 2-6名字：住房信息別名：描述：房間擁

4、有的信息定義：住房信息=房間號(hào)+房間人數(shù)+住房類型位置：交給住戶房間申請(qǐng)退房申請(qǐng)名字：樓層號(hào)別名：定義：樓層號(hào)=1數(shù)字1位置：名字：房間號(hào)別名：定義：房間號(hào)=2數(shù)字2位置：名字：房間號(hào)別名：描述：房間的編號(hào)定義：房間號(hào)=樓層號(hào)+房間號(hào)位置： 33 3 詳細(xì)設(shè)計(jì)詳細(xì)設(shè)計(jì)3.1 酒店管理系統(tǒng)程序流程圖圖 3-1 酒店管理系統(tǒng)程序流程圖房間檢查申請(qǐng)成功登記結(jié)賬房間檢查顯示結(jié)束房間申請(qǐng)房間申請(qǐng)房間申請(qǐng)用戶申請(qǐng)統(tǒng)計(jì)申請(qǐng)退房申請(qǐng)選擇功能開始 44 4 程序源碼程序源碼4.1 客房申請(qǐng)主要思想：輸入身份證號(hào)，查看房間的剩余，進(jìn)行入住 request.setcharacterencoding(utf-8);s

5、ervletcontext application = getservletcontext();string leixing= (string) application.getattribute(leixing);string roomno = (string) application.getattribute(roomno); datasource ds = null;context context;try context = new initialcontext();ds = (datasource) context.lookup(java:/comp/env/jdbc/mysqlds);

6、 catch (namingexception e) e.printstacktrace();system.out.println(獲取數(shù)據(jù)源錯(cuò)誤！);try string sql = select * from room where statue=? and roomno=?;queryrunner run = new queryrunner(ds);string str=leixing,roomno;list list=(list) run.query(sql,str,new beanlisthandler(room.class);if(list.isempty()request.getr

7、equestdispatcher(/servlet/insertroom).forward(request,response);elseservletcontext application1= getservletcontext(); application1.setattribute(roomno,roomno);application1.setattribute(leixing,leixing);requestdispatcher rs=request.getrequestdispatcher(/servlet/insertroom);tryrs.forward(request,respo

8、nse);return;catch (exception e) catch (sqlexception e) e.printstacktrace();try string sql=select clientname,sex,shenfenzheng,roomnumber from client where yuding=1;queryrunner run = new queryrunner(ds);list list = (list) run.query(sql, new beanlisthandler(dbcommen.class); 5request.setattribute(list,l

9、ist);request.getrequestdispatcher(/main/yudingruzhu.jsp).forward(request,response);catch(sqlexception e) e.printstacktrace();4.2 退房申請(qǐng)客戶退房模塊設(shè)計(jì)是：輸入房間號(hào)后查詢客戶信息及消費(fèi)情況；在輸出之前首先要預(yù)先查詢房間號(hào)是否有人入住，再修改數(shù)據(jù)庫信息，最后顯示客戶的信息及消費(fèi)情況。退房設(shè)計(jì)思想為：當(dāng)輸入房間號(hào)后到 trueroom2 控制塊中查詢該房間是否已經(jīng)入住，到滿足條件時(shí)，到 insertroom 對(duì)數(shù)據(jù)庫插入退房時(shí)間，然后再到getall 控制塊查詢：客戶

10、信息，房間入住，退房時(shí)間以及客戶消費(fèi)信息。最后到 all.jsp 頁面顯示所有信息。然后結(jié)賬，退房。request.setcharacterencoding(utf-8);string roomno = request.getparameter(roomno);string leixing= request.getparameter(leixing);try string sql = select * from room where statue=? and roomno=?;queryrunner run = new queryrunner(ds);string str = leixing,

11、 roomno ;list list = (list)run.query(sql, str, new beanlisthandler(room.class);servletcontext application1 = getservletcontext();application1.setattribute(roomno, roomno);application1.setattribute(leixing, leixing);requestdispatcher rs = request.getrequestdispatcher(/servlet/insertroom);try rs.forwa

12、rd(request, response);return; catch (exception e) catch (sqlexception e) e.printstacktrace();insertroom 的實(shí)現(xiàn)如下：request.setcharacterencoding(utf-8);servletcontext application = getservletcontext(); 6string leixing = (string) application.getattribute(leixing);string roomno= (string) application.getattr

13、ibute(roomno);system.out.println(roomno);system.out.println(leixing); int i=integer.parseint(leixing);int result = 0;string message = null;string sql=null;try switch(i)case 0:sql=update room set statue=1 where roomno=?;break;case 1:sql=update room set statue=2,startdate=now() where roomno=?;break;ca

14、se 2:sql=update room set enddate=now() where roomno=?;break; string sr = roomno;queryrunner run = new queryrunner(ds);result = run.update(sql, sr);if(i=1) sql=update client set yuding=2 where roomnumber=?; queryrunner run1 = new queryrunner(ds); run1.update(sql, sr);if(i=2)servletcontext application

15、1 = getservletcontext();application1.setattribute(roomno, roomno);requestdispatcher rs = request.getrequestdispatcher(/servlet/seachall);try rs.forward(request, response);return; catch (exception e) elseif (result = 1) message = 操作成功!; else message = 操作失敗!;request.setattribute(message, message);requ

16、est.getrequestdispatcher(/addresult.jsp).forward(request, 7response); catch (sqlexception e) e.printstacktrace();seachall的實(shí)現(xiàn)如下：request.setcharacterencoding(utf-8);servletcontext application = getservletcontext();string roomno = (string) application.getattribute(roomno);string consumerno = 123456;dat

17、asource ds = null;string sql = null;try sql = select clientname,sex,shenfenzheng from client where yuding=2 and roomnumber=?;queryrunner run = new queryrunner(ds);string str = roomno ;list list = (list) run.query(sql, str, new beanlisthandler(dbcommen.class);dbcommen bl = (dbcommen) list.get(0);requ

18、est.setattribute(bl, bl);sql = select roomno,startdate,enddate,timestampdiff(day,startdate,enddate) as day from room where statue=2 and roomno=?;list list1 = (list) run.query(sql, str, new beanlisthandler(room.class);room room1 = (room) list1.get(0);request.setattribute(room1, room1);sql = select *

19、from consumer where consumerno=?;string str1 = consumerno ; list list2 = (list) run.query(sql, str1, new beanlisthandler(consumer.class);consumer cm = (consumer) list2.get(0);request.setattribute(cm, cm);if(list.isempty()|list1.isempty()|list2.isempty()system.out.println(讀取失敗！);elserequest.getreques

20、tdispatcher(/seachall.jsp).forward(request,response); catch (sqlexception e) e.printstacktrace(); 84.3 查看房間查詢的思想為：先到 getallroom 控制塊對(duì)條件進(jìn)行處理，將滿足條件的房間號(hào)的數(shù)組放到 room.class 中，再到 roomseach.jsp 頁面將數(shù)組顯示出來。try sql = select roomno,statue,startdate,enddate from room; queryrunner run = new queryrunner(ds);list lis

21、t = (list) run.query(sql, new beanlisthandler(room.class); request.setattribute(list,list); request.getrequestdispatcher(/main/roomseach.jsp).forward(request,response); catch (sqlexception e) e.printstacktrace();5 5 程序運(yùn)行與調(diào)試程序運(yùn)行與調(diào)試5.1 酒店入住頁面圖 5-1 入住 95.2 退房5-2 酒店退房管理5.3 查詢5-3 住戶查詢頁面 106 6 總結(jié)總結(jié)通過一段時(shí)間的設(shè)計(jì)與編寫，該酒店管理系統(tǒng)終于有了一個(gè)比較完整的框架?，F(xiàn)將心得體會(huì)總結(jié)如下：由于時(shí)間倉促，這暫時(shí)只是一個(gè)簡單的管理系統(tǒng)，但從設(shè)計(jì)這個(gè)系統(tǒng)的過程中，我感受到了關(guān)于軟件工程，數(shù)據(jù)庫設(shè)計(jì)、商業(yè)管理等各方面知識(shí)在實(shí)際工作中的應(yīng)用。在開發(fā)該系統(tǒng)過程中，我始終堅(jiān)持以下四項(xiàng)原則，并朝相應(yīng)目標(biāo)靠攏： （1）實(shí)用為主任何系統(tǒng)都應(yīng)該以用戶需求為最終目標(biāo)，以方便用戶為最高原則，同