基于BS结构的房屋出租管理系统的设计与实现JSP+SQL.doc

摘要:二十一世纪，随着计算机科学的飞速发展，数据库技术在Internet 中的应用越来越广泛，为广大网络用户提供了更加周到和人性化的服务。个性化已逐渐成为当今Wed应用的潮流。如何通过网络有效进行交流是摆在我们面前的一个新的领域。

　　本文阐述了如何构造一个B/S结构的房屋出租管理系统，对B/S结构、JSP技术以及SQL Server原理进行了较深入的论述。阐述了对房屋出租管理系统的需求分析、功能模块划分、数据库模式分析，功能模块的实现过程。在此基础上，对所应用的关键技术进行描述。最后，对程序调试与调试结果进行论述。

　　本文在研究目前国内外房屋出租管理系统情况的基础上，从实际需求出发，采用当前较为流行的B/S结构和JSP动态网页开发技术，基于Windows XP操作系统和SQL Server 2005数据库，采用JSP技术，设计并实现了一个功能较为完善的房屋出租管理系统。通过对系统进行一系列的需求分析、设计、编码、测试等工作，该系统普通用户可以浏览、查看房屋信息，可以注册成为网站会员、登陆网站，然后发布个人房屋信息等，管理员可以对网站会员、房屋信息以及网站进行管理。重点对系统设计过程作了相应描述，同时也对系统需要改进的地方做了总结。

关键词  B/S结构；JDBC连接；SQL Server 2005

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 research is based on management of renting houses in China and in foreign countries and start realistically. Besides, according to the usage of popular B/S(explorer,/severer)structure and carrying-out technology of DHTML, SQL Server 2005 database of Windows XP operating system technology，it designs and realizes a perfect renting houses system. After a series necessity of analyzing needs, designing, coding, testing, and surfing conveniently for users, looking for information of houses. Users can register and be members to surf the websites and upload personal houses information. This system united the development of internet, current situation by using three-floor structure, which is based on web explorer-web application server-database server. The system analyzes accurate needs of working process, building structural model and function of data transfer. 

Key Words   B/S Structure； JDBC； SQL Server 2005