《数据库课程设计酒店客房管理系统的设计与实现.pdf》由会员分享，可在线阅读，更多相关《数据库课程设计酒店客房管理系统的设计与实现.pdf（38页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、 1 1.:根据宾馆管理系统的理念，宾馆管理系统必须满足一下需要：（1）具有方便的登记、结帐功能和预订客房的功能，能够支持团体登记和团体结帐；（2）能快速、准确地了解宾馆内的客房状态，以便管理者决策；（3）提供多种手段查询客人的信息；（4）具备一定的维护手段，有一定权利的操作员在密码的支持下才可以更改房价、房间类型、增减客房；（5）完善的结帐报表系统；（6）系统维护：如数据安全管理（含备份与恢复）、操作员管理、权限设置等。根据系统的需求分析，得到本系统的功能要求如下：1.系统管理：管理登陆系统的用户 2.订房信息的管理：管理订房信息，对订房信息进行查询 和添加新的订房信息。3.基础数据库管理：
2、设置房的基本属性，如等级，价格等。4.顾客信息管理：管理顾客的信息，查询居住记录等。（1）硬件环境：处理器：Intel Pentium 4 或更高 内存：256M 或更高 硬盘：40G 或更高（2）软件环境 操作系统：Windows 2000/XP/Vista；支持软件：Microsoft SQL Sever 2000，Visual C+6.0。2 1.;有需求分析，要完成本系统的运行，需要的是客户机/服务器的运行方式。采用的是 Visual C+6.0作为开发工具，采用了 SQL Sever 2000 作为后台数据库，就可以满足一般的宾馆的客房管理的需求.2.:3 I 1.1E-R 2E-R
3、 3E-R 4 E-R 5 2.（1）登陆需要的数据有：登陆 ID 密码 pwd,pas2.建立表格 user：（2）房子的属性种类：建立表格 roomtype:（3）预定房子的时候用的表格：（4）客房表 6 （5）结算信息表 利用查询分析器实现他们 1.建立表格 user 2.Bookin 表 7 3.roomtype 表 4.rooms 表 5.oucall 表 输入数据即可。（II）程序设计 1.程序运行数据流程图：8#define AFX_ROOMTYPEDLG_H_487EF091_29D9_404B_B081_0DAC2C2E1223_INCLUDE_#if _MSC_VER 10
4、00 9#pragma once#endif/_MSC_VER 1000/RoomTypeDLG.h:header file class CRoomTypeDLG:public CDialog /Construction public:bool m_bAirCon;bool m_bTel;bool m_bTV;bool m_bToilet;bool m_bAppend;CRoomTypeDLG(CWnd*pParent=NULL);protected:DECLARE_MESSAGE_MAP();#include stdafx.h#include hotel_mis.h#include Room
5、TypeDLG.h#include Hotel_MISView.h#ifdef _DEBUG#define new DEBUG_NEW#undef THIS_FILE static char THIS_FILE=_FILE_;#endif/CRoomTypeDLG dialog CRoomTypeDLG:CRoomTypeDLG(CWnd*pParent/*=NULL*/):CDialog(CRoomTypeDLG:IDD,pParent)/AFX_DATA_INIT(CRoomTypeDLG)m_sArea=_T();m_sBedNo=_T();m_sTypeID=_T();m_sTypeN
6、ame=_T();m_sPrice=_T();/AFX_DATA_INIT void CRoomTypeDLG:DoDataExchange(CDataExchange*pDX)10 CDialog:DoDataExchange(pDX);/AFX_DATA_MAP(CRoomTypeDLG)BEGIN_MESSAGE_MAP(CRoomTypeDLG,CDialog)/AFX_MSG_MAP(CRoomTypeDLG)/AFX_MSG_MAP END_MESSAGE_MAP()/CRoomTypeDLG message handlers BOOL CRoomTypeDLG:OnInitDia
7、log()CDialog:OnInitDialog();/TODO:Add extra initialization here /Init Edit Text limit if(m_bAppend)/Update Dialog Caption SetWindowText(_T(添加客房标准);/Init Combobox (CComboBox*)GetDlgItem(IDC_ROOMTYPE_ISAIRCON)-SetCurSel(1);(CComboBox*)GetDlgItem(IDC_ROOMTYPE_ISTEL)-SetCurSel(1);(CComboBox*)GetDlgItem(
8、IDC_ROOMTYPE_ISTV)-SetCurSel(1);(CComboBox*)GetDlgItem(IDC_ROOMTYPE_ISTOILET)-SetCurSel(1);else /Update Dialog Caption SetWindowText(_T(修改客房标准);/Disable ID and Name Edit GetDlgItem(IDC_ROOMTYPE_ID)-EnableWindow(false);GetDlgItem(IDC_ROOMTYPE_NAME)-EnableWindow(false);/Init Combobox if(m_bAirCon)(CCo
9、mboBox*)GetDlgItem(IDC_ROOMTYPE_ISAIRCON)-SetCurSel(1);else 11 (CComboBox*)GetDlgItem(IDC_ROOMTYPE_ISAIRCON)-SetCurSel(0);if(m_bTel)(CComboBox*)GetDlgItem(IDC_ROOMTYPE_ISTEL)-SetCurSel(1);else(CComboBox*)GetDlgItem(IDC_ROOMTYPE_ISTEL)-SetCurSel(0);if(m_bTV)(CComboBox*)GetDlgItem(IDC_ROOMTYPE_ISTV)-S
10、etCurSel(1);else(CComboBox*)GetDlgItem(IDC_ROOMTYPE_ISTV)-SetCurSel(0);if(m_bToilet)(CComboBox*)GetDlgItem(IDC_ROOMTYPE_ISTOILET)-SetCurSel(1);else(CComboBox*)GetDlgItem(IDC_ROOMTYPE_ISTOILET)-SetCurSel(0);return TRUE;/return TRUE unless you set the focus to a control /EXCEPTION:OCX Property Pages s
11、hould return FALSE void CRoomTypeDLG:OnOK()/TODO:Add extra validation here UpdateData(true);m_sTypeID.TrimRight();m_sTypeName.TrimRight();m_sArea.TrimRight();m_sBedNo.TrimRight();m_sPrice.TrimRight();/Make sure all needed info is available CString sWarning=;if(=m_sTypeID)sWarning=_T(标准编号);else if(=m
12、_sTypeName)sWarning=_T(标准名称);else if(=m_sArea)sWarning=_T(客房面积);else if(=m_sBedNo)sWarning=_T(床位数量);else if(=m_sPrice)sWarning=_T(住房单价);if(!=sWarning)sWarning+=_T(不能为空);AfxMessageBox(sWarning,MB_ICONEXCLAMATION);return;/Make sure the Number info is valid 12 float fArea=atof(m_sArea);if(0=fArea)AfxMe
13、ssageBox(_T(客房面积：请输入非零数字),MB_ICONEXCLAMATION);return;m_sArea.Format(%.2f,fArea);float fPrice=atof(m_sPrice);if(0=fPrice)AfxMessageBox(_T(住房单价：请输入非零数字),MB_ICONEXCLAMATION);return;m_sPrice.Format(%.2f,fPrice);if(atof(m_sPrice)99999999.99)AfxMessageBox(_T(住 房 单 价 溢 出，请 不 要 超 过99999999.99),MB_ICONEXCLAM
14、ATION);return;_variant_t strQuery;if(m_bAppend)/Judge Room Type is Unique strQuery=select*from roomtype where typeid=+m_sTypeID+;theApp.ADOExecute(theApp.m_pADOSet,strQuery);int iCount=theApp.m_pADOSet-GetRecordCount();if(0!=iCount)AfxMessageBox(_T(已经存在 此标 准编 号的 记 录！),MB_ICONEXCLAMATION);return;/Jud
15、ge Room Name is Unique strQuery=select*from roomtype where typeid!=+m_sTypeID+and typename=+m_sTypeName+;13 theApp.ADOExecute(theApp.m_pADOSet,strQuery);iCount=theApp.m_pADOSet-GetRecordCount();if(0!=iCount)AfxMessageBox(_T(已 经 存 相 同 客 房 标 准 的 记 录！),MB_ICONEXCLAMATION);return;/Get other info CString
16、 sAir(0),sTel(0),sTV(0),sToilet(0);if(CComboBox*)GetDlgItem(IDC_ROOMTYPE_ISAIRCON)-GetCurSel()sAir=1;if(CComboBox*)GetDlgItem(IDC_ROOMTYPE_ISTEL)-GetCurSel()sTel=1;if(CComboBox*)GetDlgItem(IDC_ROOMTYPE_ISTV)-GetCurSel()sTV=1;if(CComboBox*)GetDlgItem(IDC_ROOMTYPE_ISTOILET)-GetCurSel()sToilet=1;if(m_b
17、Append)/Append Record strQuery=insert roomtype(typeid,typename,area,bednum,price,haircondition,htelephone,htelevision,htoilet)values(+m_sTypeID+,+m_sTypeName+,+m_sArea+,+m_sBedNo+,+m_sPrice+,+sAir+,+sTel+,+sTV+,+sToilet+);if(theApp.ADOExecute(theApp.m_pADOSet,strQuery)AfxMessageBox(_T(添加记录成功！),MB_IC
18、ONINFORMATION);/Clear all input m_sTypeID=m_sTypeName=m_sArea=m_sBedNo=m_sPrice=;(CComboBox*)GetDlgItem(IDC_ROOMTYPE_ISAIRCON)-SetCurSel(1);(CComboBox*)GetDlgItem(IDC_ROOMTYPE_ISTEL)-SetCurSel(1);(CComboBox*)GetDlgItem(IDC_ROOMTYPE_ISTV)-SetCurSel(1);(CComboBox*)GetDlgItem(IDC_ROOMTYPE_ISTOILET)-Set
19、CurSel(1);UpdateData(false);14 else AfxMessageBox(_T(添加记录失败！),MB_ICONEXCLAMATION);else/Alter Record strQuery=Update roomtype set area=+m_sArea+,bednum=+m_sBedNo+,price=+m_sPrice+,haircondition=+sAir+,htelephone=+sTel+,htelevision=+sTV+,htoilet=+sToilet+where typeid=+m_sTypeID+;if(theApp.ADOExecute(t
20、heApp.m_pADOSet,strQuery)AfxMessageBox(_T(修改记录成功！),MB_ICONINFORMATION);else AfxMessageBox(_T(修改记录失败！),MB_ICONEXCLAMATION);/Refresh RoomType List CHotel_MISView*p=(CHotel_MISView*)(CMainFrame*)AfxGetMainWnd()-GetActiveView();p-RefreshRoomType();if(!m_bAppend)CDialog:OnOK();/Hotel_MISView.cpp:implemen
21、tation of the CHotel_MISView class#include stdafx.h#include Hotel_MIS.h#include Hotel_MISDoc.h#include Hotel_MISView.h#include RoomTypeDLG.h#include RoomDLG.h#include CheckRoomDLG.h#include CheckRemainDLG.h#include BookInDLG.h#include SearchBookInDLG.h#include CheckOutDLG.h#include SearchCheckOutDLG
22、.h#ifdef _DEBUG#define new DEBUG_NEW#undef THIS_FILE static char THIS_FILE=_FILE_;#endif/CHotel_MISView IMPLEMENT_DYNCREATE(CHotel_MISView,CView)15 BEGIN_MESSAGE_MAP(CHotel_MISView,CView)/AFX_MSG_MAP(CHotel_MISView)ON_WM_SIZE()ON_WM_CONTEXTMENU()ON_COMMAND(ID_MENU_ADDROOMTYPE,OnAddRoomType)ON_COMMAN
23、D(ID_MENU_ALTERROOMTYPE,OnAlterRoomType)ON_COMMAND(ID_MENU_DELROOMTYPE,OnDelRoomType)ON_COMMAND(ID_MENU_ADDROOM,OnAddRoom)ON_COMMAND(ID_MENU_ALTERROOM,OnAlterRoom)ON_COMMAND(ID_MENU_DELROOM,OnDelRoom)ON_COMMAND(ID_MENU_CHECKROOM,OnCheckRoom)ON_COMMAND(ID_MENU_CHECKREMAIN,OnCheckRemain)ON_COMMAND(ID_
24、MENU_ADDBOOKIN,OnAddBookIn)ON_COMMAND(ID_MENU_ALTERBOOKIN,OnAlterBookIn)ON_COMMAND(ID_MENU_SEARCHBOOKIN,OnSearchBookIn)ON_COMMAND(ID_MENU_ADDCHECKOUT,OnAddCheckOut)ON_COMMAND(ID_MENU_ALTERCHECKOUT,OnAlterCheckOut)ON_COMMAND(ID_MENU_SEARCHCHECKOUT,OnSearchCheckOut)/AFX_MSG_MAP END_MESSAGE_MAP()/CHote
25、l_MISView construction/destruction CHotel_MISView:CHotel_MISView()/TODO:add construction code here m_sCurrentList=;CHotel_MISView:CHotel_MISView()BOOL CHotel_MISView:PreCreateWindow(CREATESTRUCT&cs)/TODO:Modify the Window class or styles here by modifying /the CREATESTRUCT cs return CView:PreCreateW
26、indow(cs);/CHotel_MISView drawing void CHotel_MISView:OnDraw(CDC*pDC)CHotel_MISDoc*pDoc=GetDocument();ASSERT_VALID(pDoc);16 /TODO:add draw code for native data here /CHotel_MISView diagnostics#ifdef _DEBUG void CHotel_MISView:AssertValid()const CView:AssertValid();void CHotel_MISView:Dump(CDumpConte
27、xt&dc)const CView:Dump(dc);CHotel_MISDoc*CHotel_MISView:GetDocument()/non-debug version is inline ASSERT(m_pDocument-IsKindOf(RUNTIME_CLASS(CHotel_MISDoc);return(CHotel_MISDoc*)m_pDocument;#endif/_DEBUG CHotel_MISView message handlers void CHotel_MISView:OnSize(UINT nType,int cx,int cy)CView:OnSize(
28、nType,cx,cy);/TODO:Add your message handler code here if(m_ListCtrl)CRect rect;GetClientRect(rect);rect.top+=30;m_ListCtrl.MoveWindow(rect);void CHotel_MISView:LoadListCtrl()CRect rect;GetClientRect(rect);rect.top+=30;m_ListCtrl.Create(WS_CHILD|WS_VISIBLE|WS_BORDER|LVS_REPORT,rect,this,1);17 m_ListC
29、trl.SetBkColor(RGB(177,151,240);m_ListCtrl.SetTextColor(RGB(0,0,0);m_ListCtrl.SetTextBkColor(RGB(177,151,240);m_ListCtrl.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP);m_ListCtrl.InsertColumn(0,Node ID,LVCFMT_LEFT,250);m_ListCtrl.InsertColumn(1,2 ID,LVCFMT_LEFT,250);CS
30、tring str;for(int i=0;iTrackPopupMenu(TPM_LEFTALIGN|TPM_LEFTBUTTON|TPM_RIGHTBUTTON,point.x,point.y,this);return;void CHotel_MISView:OnAddRoomType()18 /TODO:Add your command handler code here CRoomTypeDLG dlg;dlg.m_bAppend=true;dlg.DoModal();void CHotel_MISView:OnInitialUpdate()CView:OnInitialUpdate(
31、);/TODO:Add your specialized code here and/or call the base class /Create a Static ctrl for tip CRect rect;rect.left=rect.top=5;rect.bottom=30;rect.right=120;m_StaticCtrl.Create(m_sCurrentList,WS_VISIBLE,rect,this,1);void CHotel_MISView:RefreshRoomType()if(m_ListCtrl)m_ListCtrl.DestroyWindow();Creat
32、eRoomType();m_sCurrentList=_T(房间标准列表);m_StaticCtrl.SetWindowText(m_sCurrentList);void CHotel_MISView:CreateRoomType()/Update m_sCurrentList and Static Ctrl m_sCurrentList=_T(房间标准列表);m_StaticCtrl.SetWindowText(m_sCurrentList);/Get Client Rect CRect rect;GetClientRect(rect);rect.top+=30;/Create m_List
33、Ctrl.Create(WS_CHILD|WS_VISIBLE|WS_BORDER|LVS_REPORT,rect,this,1);/Set Color m_ListCtrl.SetBkColor(RGB(177,151,240);m_ListCtrl.SetTextColor(RGB(0,0,0);19 m_ListCtrl.SetTextBkColor(RGB(177,151,240);/Set EX-Style m_ListCtrl.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP);
34、/Create Header m_ListCtrl.InsertColumn(0,_T(标准编号),LVCFMT_LEFT,100);m_ListCtrl.InsertColumn(1,_T(标准名称),LVCFMT_LEFT,100);m_ListCtrl.InsertColumn(2,_T(房间面积),LVCFMT_LEFT,100);m_ListCtrl.InsertColumn(3,_T(床位数量),LVCFMT_LEFT,100);m_ListCtrl.InsertColumn(4,_T(住房单价/每天),LVCFMT_LEFT,100);m_ListCtrl.InsertColum
35、n(5,_T(是否有空调),LVCFMT_LEFT,100);m_ListCtrl.InsertColumn(6,_T(是否有电话),LVCFMT_LEFT,100);m_ListCtrl.InsertColumn(7,_T(是否有电视),LVCFMT_LEFT,100);m_ListCtrl.InsertColumn(8,_T(是否有卫生间),LVCFMT_LEFT,100);/Get all records _variant_t Holder,strQuery;strQuery=select*from roomtype order by typeid;theApp.ADOExecute(t
36、heApp.m_pADOSet,strQuery);int iCount=theApp.m_pADOSet-GetRecordCount();if(0=iCount)return;CString str;theApp.m_pADOSet-MoveFirst();for(int i=0;iGetCollect(typeid);str=Holder.vt=VT_NULL?:(char*)(_bstr_t)Holder;m_ListCtrl.InsertItem(i,str);/Get typename Holder=theApp.m_pADOSet-GetCollect(typename);str
37、=Holder.vt=VT_NULL?:(char*)(_bstr_t)Holder;m_ListCtrl.SetItemText(i,1,str);/Get area Holder=theApp.m_pADOSet-GetCollect(area);str.Format(%.2f,Holder.dblVal);m_ListCtrl.SetItemText(i,2,str);/Get bednum Holder=theApp.m_pADOSet-GetCollect(bednum);20 str.Format(%d,Holder.vt=VT_NULL?0:Holder.intVal);m_Li
38、stCtrl.SetItemText(i,3,str);/Get price Holder=theApp.m_pADOSet-GetCollect(price);str.Format(%.2f,Holder.vt=VT_NULL?0:Holder.dblVal);m_ListCtrl.SetItemText(i,4,str);/Get airCondition Holder=theApp.m_pADOSet-GetCollect(haircondition);if(Holder.vt=VT_NULL?0:Holder.iVal)str=_T(有);else str=_T(没有);m_ListC
39、trl.SetItemText(i,5,str);/Get Phone Holder=theApp.m_pADOSet-GetCollect(htelephone);if(Holder.vt=VT_NULL?0:Holder.iVal)str=_T(有);else str=_T(没有);m_ListCtrl.SetItemText(i,6,str);/Get TV Holder=theApp.m_pADOSet-GetCollect(htelevision);if(Holder.vt=VT_NULL?0:Holder.iVal)str=_T(有);else str=_T(没有);m_ListC
40、trl.SetItemText(i,7,str);/Get TV Holder=theApp.m_pADOSet-GetCollect(htoilet);if(Holder.vt=VT_NULL?0:Holder.iVal)str=_T(有);else str=_T(没有);m_ListCtrl.SetItemText(i,8,str);theApp.m_pADOSet-MoveNext();void CHotel_MISView:OnAlterRoomType()/TODO:Add your command handler code here if(m_ListCtrl&m_sCurrent
41、List!=房间标准列表)m_ListCtrl.DestroyWindow();CreateRoomType();return;if(!m_ListCtrl)CreateRoomType();return;21 /Popup Alter Dialog POSITION pos=m_ListCtrl.GetFirstSelectedItemPosition();if(pos=NULL)AfxMessageBox(_T(没 有 选 中 的 记 录！),MB_ICONEXCLAMATION);else dlg.DoModal();void CHotel_MISView:OnDelRoomType()
42、/TODO:Add your command handler code here if(m_ListCtrl&m_sCurrentList!=房间标准列表)m_ListCtrl.DestroyWindow();CreateRoomType();return;if(!m_ListCtrl)CreateRoomType();return;/Del Records POSITION pos=m_ListCtrl.GetFirstSelectedItemPosition();if(pos=NULL)AfxMessageBox(_T(没有选中的记录！),MB_ICONEXCLAMATION);retur
43、n;else _variant_t strQuery,Holder;strQuery=select typename from roomtype;theApp.ADOExecute(theApp.m_pADOSet,strQuery);22 int iCount=theApp.m_pADOSet-GetRecordCount();if(0=iCount)AfxMessageBox(_T(请先进行客房标准设置！),MB_ICONEXCLAMATION);return;CRoomDLG dlg;dlg.m_bAppend=true;dlg.DoModal();void CHotel_MISView
44、:RefreshRoom(_variant_t strQuery)if(m_ListCtrl)m_ListCtrl.DestroyWindow();CreateRoom(strQuery);m_sCurrentList=_T(客房信息列表);m_StaticCtrl.SetWindowText(m_sCurrentList);void CHotel_MISView:CreateRoom(_variant_t strQuery)/Update m_sCurrentList and Static Ctrl m_sCurrentList=_T(客房信息列表);m_StaticCtrl.SetWind
45、owText(m_sCurrentList);/Get Client Rect CRect rect;GetClientRect(rect);rect.top+=30;/Create m_ListCtrl.Create(WS_CHILD|WS_VISIBLE|WS_BORDER|LVS_REPORT,rect,this,1);/Set Color m_ListCtrl.SetBkColor(RGB(177,151,240);m_ListCtrl.SetTextColor(RGB(0,0,0);m_ListCtrl.SetTextBkColor(RGB(177,151,240);/Set EX-
46、Style m_ListCtrl.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES|LVS_EX_HEADERDRAGDROP);/Create Header m_ListCtrl.InsertColumn(0,_T(客房编号),LVCFMT_LEFT,100);23 m_ListCtrl.InsertColumn(1,_T(客房类型),LVCFMT_LEFT,100);m_ListCtrl.InsertColumn(2,_T(客房位置),LVCFMT_LEFT,100);m_ListCtrl.InsertColumn(3,_T(客房
47、单价),LVCFMT_LEFT,100);m_ListCtrl.InsertColumn(4,_T(是否被定),LVCFMT_LEFT,100);m_ListCtrl.InsertColumn(5,_T(备注),LVCFMT_LEFT,200);/Get all records _variant_t Holder;theApp.ADOExecute(theApp.m_pADOSet,strQuery);int iCount=theApp.m_pADOSet-GetRecordCount();if(0=iCount)return;CString str;theApp.m_pADOSet-Move
48、First();for(int i=0;iGetCollect(roomNo);str=Holder.vt=VT_NULL?:(char*)(_bstr_t)Holder;m_ListCtrl.InsertItem(i,str);/Get room type Holder=theApp.m_pADOSet-GetCollect(roomtype);str=Holder.vt=VT_NULL?:(char*)(_bstr_t)Holder;m_ListCtrl.SetItemText(i,1,str);/Get position Holder=theApp.m_pADOSet-GetCollec
49、t(roomposition);str=Holder.vt=VT_NULL?:(char*)(_bstr_t)Holder;/str.Format(%.2f,Holder.dblVal);m_ListCtrl.SetItemText(i,2,str);/Get price Holder=theApp.m_pADOSet-GetCollect(roomprice);str.Format(%.2f,Holder.vt=VT_NULL?0:Holder.dblVal);m_ListCtrl.SetItemText(i,3,str);/Get Putup Holder=theApp.m_pADOSet
50、-GetCollect(putup);if(Holder.vt=VT_NULL?0:Holder.iVal)str=_T(有);else str=_T(没有);m_ListCtrl.SetItemText(i,4,str);/Get Memo Holder=theApp.m_pADOSet-GetCollect(roommemo);str=Holder.vt=VT_NULL?:(char*)(_bstr_t)Holder;24 m_ListCtrl.SetItemText(i,5,str);theApp.m_pADOSet-MoveNext();void CHotel_MISView:OnAl