基于B/S結(jié)構(gòu)的房屋出租管理系統(tǒng)

目  錄
摘   要 I
Abstract II
第1章 緒論 1
　　1.1 課題研究的背景介紹 1
　　1.2系統(tǒng)開發(fā)環(huán)境及開發(fā)平臺介紹 2
　　　1.2.1 系統(tǒng)開發(fā)環(huán)境 2
　　　1.2.2 系統(tǒng)開發(fā)平臺簡介 2
第2章 系統(tǒng)開發(fā)技術(shù)介紹 5
　　2.1 系統(tǒng)的B/S結(jié)構(gòu) 5
　　　2.1.1 B/S結(jié)構(gòu)簡介 5
　　　2.1.2 B/S架構(gòu)軟件的優(yōu)勢與劣勢 6
　　　2.1.3 B/S框架與C/S框架的聯(lián)系與區(qū)別 7
　　2.2 JSP技術(shù)概述 8
　　　2.2.1 JSP簡介 8
　　　2.2.2 JSP技術(shù)的強勢與弱勢分析 9
　　　2.2.3 JSP動態(tài)網(wǎng)站開發(fā)技術(shù) 10
　　2.3 MVC及Struts介紹 12
　　　2.3.1 MVC介紹 12
　　　2.3.2 Struts介紹 12
第3章 系統(tǒng)分析 15
　　3.1任務(wù)描述 15
　　3.2用UML用例圖描述系統(tǒng)需求 15
　　　3.2.1用例圖簡介 15
　　　3.2.2系統(tǒng)用例分析 16
　　3.3功能分析 16
第4章 系統(tǒng)的設(shè)計與實現(xiàn) 18
　　4.1數(shù)據(jù)庫的設(shè)計與實現(xiàn) 18
　　　4.1.1數(shù)據(jù)庫SQL Server 2000簡介 18
　　　4.1.2數(shù)據(jù)庫結(jié)構(gòu)設(shè)計 19
　　　4.2.3數(shù)據(jù)庫加載和調(diào)試 21
　　　4.2.4操作數(shù)據(jù)庫 22
　　4.2功能模塊的設(shè)計與實現(xiàn) 23
　　　4.2.1系統(tǒng)注冊模塊 23
　　　4.2.2系統(tǒng)登錄模塊 24
　　　4.2.3普通用戶功能模塊 24
　　　4.2.4管理員功能模塊 25
　　　4.2.5信息發(fā)布模塊 26
　　　4.2.6信息查詢模塊 27
第5章 系統(tǒng)測試與維護 28
　　5.1系統(tǒng)測試 28
　　5.2  網(wǎng)站維護 30
　　　5.2.1維護內(nèi)容 30
　　　5.2.2維護方案 31
結(jié)束語 32
致謝 33
參考資料 34

摘   要
　　　21世紀(jì)，隨著計算機科學(xué)的發(fā)展，數(shù)據(jù)庫技術(shù)在Internet 中的應(yīng)用越來越廣泛，為廣大網(wǎng)絡(luò)用戶提供了更加周到和人性化的服務(wù)。個性化已逐漸成為當(dāng)今Wed應(yīng)用的潮流。如何通過網(wǎng)絡(luò)有效進行交流是擺在我們面前的一個新的領(lǐng)域。
　　　本文闡述了如何構(gòu)造一個B/S結(jié)構(gòu)的房屋出租管理系統(tǒng)，對B/S結(jié)構(gòu)、JSP技術(shù)以及SQL Server原理進行了較深入的論述。闡述了對房屋出租管理系統(tǒng)的需求分析、功能模塊劃分、數(shù)據(jù)庫模式分析，功能模塊的實現(xiàn)過程。在此基礎(chǔ)上，對所應(yīng)用的關(guān)鍵技術(shù)進行描述。最后，對程序調(diào)試與調(diào)試結(jié)果進行論述。
　　　本文在研究目前國內(nèi)外房屋出租管理系統(tǒng)情況的基礎(chǔ)上，從實際需求出發(fā)，采用當(dāng)前較為流行的B/S（Browser/Server瀏覽器/服務(wù)器）結(jié)構(gòu)和JSP動態(tài)網(wǎng)頁開發(fā)技術(shù)，基于Windows XP Professional操作系統(tǒng)和SQL Server 2000數(shù)據(jù)庫，采用JSP技術(shù)，設(shè)計并實現(xiàn)了一個功能較為完善的房屋出租管理系統(tǒng)。通過對系統(tǒng)進行一系列的需求分析、設(shè)計、編碼、測試等工作，該系統(tǒng)普通用戶可以瀏覽、查看房屋信息，可以注冊成為網(wǎng)站會員、登陸網(wǎng)站，然后發(fā)布個人房屋信息，還可以查看該網(wǎng)站的新聞公告等，管理員可以對網(wǎng)站會員、房屋信息以及網(wǎng)站的新聞公告進行管理。重點對系統(tǒng)設(shè)計過程作了相應(yīng)描述，同時也對系統(tǒng)需要改進的地方做了總結(jié)。
　　　本系統(tǒng)結(jié)合因特網(wǎng)的發(fā)展、應(yīng)用現(xiàn)狀，采用了基于WEB的三層體系架構(gòu)，即瀏覽器——WEB應(yīng)用服務(wù)器——數(shù)據(jù)庫服務(wù)器。通過對系統(tǒng)工作流程進行詳細(xì)需求分析，建立了系統(tǒng)的功能模型和數(shù)據(jù)流模型。確定系統(tǒng)的數(shù)據(jù)模型為關(guān)系數(shù)據(jù)模型，進行了分析、設(shè)計、畫出了E-R圖。后臺數(shù)據(jù)庫選用了SQL Server 2000來實現(xiàn)。WEB開發(fā)采用當(dāng)前流行的JSP(Java Server Pages，動態(tài)網(wǎng)頁技術(shù))技術(shù)，JSP頁面通過JDBC(Java Database Connectivity，Java數(shù)據(jù)庫連接)接口連接SQL Server 2000數(shù)據(jù)庫，實現(xiàn)了瀏覽器端和服務(wù)器端的程序。系統(tǒng)經(jīng)過測試，運行效果穩(wěn)定、操作方便、快捷。能較好的為該系統(tǒng)的房屋出租、求租用戶服務(wù)。

關(guān)鍵詞  B/S結(jié)構(gòu)；JDBC連接；SQL Server 2000；

Abstract
　　　Along with the development of the computer science in 21 centuries, the database technique is more and more extensive in the application in the Internet, providing the more thoughtful and humanized service for the large network customer. Characteristic have already become gradually the current as the application of Wed nowadays. How to communicate on the web is a new topic facing us.
　　　This paper describes how to struct a system to have set forth house to Let management adopt B/S structure's, the paper describes the B/S structure and SQL Server, JSP technology principles. The article complete the needs analysis of an system for the management applications for communication which on the web, functional modules division and database model analysis. The technology is in progress here to what be applied key on the basis, describe that. Final, comment that to procedure debugging with testing result being in progress.
　　　The discourse according to the practical demand of some users, which is on the base of the situation of the domestic and international recorded at present. adopt currently comparatively popular B/S (Browser/Server) structure and JSP development Web page to develop a technology, 2000 data bases, adopt the JSP technology owing to Windows XP Professional OS and SQL Server, the function having designed and realizing one is comparatively perfect house to Let management system. Through a series of preparation such as requirement analization,design,coding,test through set forth house to Let management system. That is the system domestic consumer's turn to be able to register becoming the website member, landing website, browse,check building information,announce and then individual building information, can look up the press release that website waiting, administrative person can carry out administration on the website member, building information and the website press release. The small advantages having designed process work to system describes priority, requires that the place improving has done a summary at the same time also to system.
　　　Internet, application status, using a Web-based three-tier system structure, the browser Web application servers database servers. Through the teacher eva luation process needs to conduct a detailed analysis, establish a system of the model and data model. Identify the data model for relational data model for the analysis, design, which depicts the E-R charts. Selection of the background database SQL Server 2000 is to be achieved. Web develops using current popular JSP (Java Server Pages, Dynamic web technology) technology, JSP pages through JDBC (Java Database Connectivity) interface to SQL Server 2000 database. It has realized a browser holding the procedure really with the server. Through the testing, the operation result of the system is steady .It is easy to operate and the speed is fast. It can give a good service for the users who use the system.
　　　
Key Words   B/S Structure； JDBC； SQL Server 2000