【正文】 ( = 39。否39。 )。 else int idno,idsum SELECT INTO :idno FROM cai_tongji where ( = :cai ) AND ( = :zh ) AND ( = 39。否39。 )。 SELECT count( ) INTO :idsum FROM cai_tongji 。 delete from cai_tongji where ( = :cai ) AND ( = :zh ) AND ( = 39。否39。 )。 UPDATE cai_tongji SET id = :idno WHERE = :idsum。 end if (sqlca) (zh,39。否39。) end if結(jié)束語 該系統(tǒng)的設計主要針對小型酒店并且只實現(xiàn)了一些酒店的基本管理，應用起來簡單方便，易于操作。研究這個課題的意義不僅僅在于做出一個實際可用的系統(tǒng)，更在于對未成熟的酒店管理系統(tǒng)進行探索。鑒于水平有限，此系統(tǒng)存在著許多不足之處，還有待進一步升級與改造，希望各位老師與同學多提寶貴意見。參考文獻[1] [M].北京：清華大學出版社，.[2] 馬承志， [M].北京：機械工業(yè)出版社，.[3] 崔杜武， [M].北京：人民郵電出版社，.[4] 政阿奇，[M].北京：工業(yè)出版社，.[5] 徐國智， SEVER 數(shù)據(jù)庫開發(fā)實例精粹電子[M].北京：工業(yè)出版社，.[6] 何旭洪， [M].北京：人民郵電出版社，.[7] [J].辦公自動化, 2010, (04):2642.[8] 白雪峰,[J].電腦知識與技術,2010,(06):1242. [9] [J].合作經(jīng)濟與科技,2010,(07):423.[10] [M].北京：中國紡織出版社，.[11] （第二版）[M].北京：清華大學出版社，.[12] [J].中國食品, 2008,(06): 4243.[13] Adomavicius, G., amp。 Tuzhilin, A. (2005). Toward the Next Generation of Remender Systems: A Survey of the StateoftheArt and Possible Extensions. IEEE Transactions on Knowledge and Data Engineering , 17 (6), 734749.[14] Boutilier, C., Brafman, R. I., Domshlak, C., Hoos, H. H., amp。 Poole, D. (2004). PreferenceBased Constrained Optimization with CPNets. Computational Intelligence , 20 (2), 137157.[15] Candillier, L., Meyer, F., amp。 Boull233。, M. (2007). Comparing StateoftheArt Collaborative Filtering Systems. In P. Perner (Ed.), Proceedings of the 5th International Conference on Machine Learning and Data Mining in Pattern Recognition (MLDM 2007). 4571, pp. 548562. Springer.The design of the Hotel Manager SistemZhang Ping(Department of Physics ,Dezhou University,Dezhou,253023)Abstract The paper only against simple functional of the hotel management system makes some designs to achieve the simple management of the hotel. It is divided into three I expounds on the main designing ideas of the application system,including system design sense, functional objectives, functional modular design and the development tools of this application system。Chapter II mainly describes the designing process of database,including the need analysis of database,conceptual structure design and logic structure design。Chapter III is the main body of this paper, and it introduces achievement of all the main functions of the modules and the procedure this paper, use the graphics interface application development environment Power Builder and SQL Server 7 database support as a background. In the design process of this paper, through the connections of and database, plete the operation of the existing data in database, thus achieve management system for the entire hotel.Key words Hotel management system。 functional module。 database Power Builder 。 SQL Server 7致 謝 在這次做畢業(yè)設計的過程中我學到了很多。從一開始的設計選題到論文的最終截稿，我親身感受到了要做好一個畢業(yè)設計其中的知識含量光靠我們原先的學習是不夠的，因此，我查閱了許多與該選題相關的文獻并且通過互聯(lián)網(wǎng)也查詢了該選題的發(fā)展情況，但由于我的能力有限，本系統(tǒng)在功能設計方面還是有些不足之處，還有就是在信息排版方面做得還不夠。但是通過這次的實踐我自身的能力確實得到了一定程度的提升，同時也了解了寫論文的格式，所以說這次的經(jīng)驗是很值得我牢記于心的。 感謝我的指導老師，從我的論文選題到論文的撰寫完成老師細心、嚴謹?shù)囊蠛椭笇?，給了我非常大的幫助與支持。我還要向所有教過我的老師和幫助我的同學致以深深的感謝，是他們的孜孜不倦的教誨和無私的幫助才使得我今天的工作得以順利的進行。24