分类号：TP315 U D C：D10621-408-(2007)6012-0
密 级：公 开 编 号：2003215034
成 都 信 息 工 程 学 院
学 位 论 文
基于 WEB 的房屋出租管理系统的设计与实现
论 文 作 者 姓 名 ：
xx
申 请 学 位 专 业 ：
网络工程
申 请 学 位 类 别 ：
工学学士
指导教师姓名（职称）：
xxx（副研究员）
论 文 提 交 日 期 ：
20xx 年 6 月 10 日
基于 WEB 的房屋出租管理系统的设计与实现
摘 要
随着互联网技术的迅猛发展，越来越多的商业活动都从传统的现实社会中发
展到了网络上。房屋的出租业务也从现实生活中走上了网络空间。伴随着这类业
务的开展，如何对出租房屋进行高效，合理的管理这个问题越来越凸现出来。针
对这一需求，本文设计并实现了一套基于 Web 的房屋出租管理系统，力求能简
洁高效地解决房屋出租管理方面的问题。
本 系 统 采 用 B/S 模 式 ， 基 于 ASP.net 平 台 开 发 , 后 台 数 据 库 采 用 SQL
Server,WEB 服务器采用 IIS 6.0。系统主要由以下几个模块组成：数据发布模块，
数据查询模块，数据管理模块，身份验证模块，系统管理模块，数据计算模块。
系统实现了用户登录，信息发布，信息修改，房屋收费项设置，房屋收费计算，
信息查询，用户留言，管理员发布公告等功能。使用本系统，客户端用户只需要
通过浏览器访问就可以实现对房屋出租信息管理的操作。
关键词：基于 Web 的房屋出租；管理系统；数据库
Design and Implementation of Web-based House
Renting Management System
Abstract
With rapidly developing of the Internet technology, commercial activities are
developing from the traditional society to the network. For example, the house renting
business is dealing online, which used to appear in real life. With such business
developing, how to manage the house renting efficiently and rationally become
important. In response to this demand, the paper designed and implemented a
Web-based house renting management system; it strives to solve problems of house
renting management simply and efficiently.
The system uses B/S model, based on the ASP.net development platform,
database server is SQL Server 2000, Web server is IIS 5.0. System is mainly
composed of the following modules: information publication module, data query
module, data management module, authentication module, system management
module, and data counting module. System achieves the following functions: users’
login, information publication, information modification, setting up charges on
housing, calculating house renting fees, information inquiries, user messages, and
administrators issued a public notice, etc. By using this system, the client users can
achieve the house renting information management operation through the browser.
Key words: web-based house renting; management system; Database
目 录
论文总页数：22 页
1 引言 ................................................................................................................................................1
1.1 课题背景 .................................................................................................................................1
1.2 国内外研究现状 ....................................................................................................................1
1.3 本课题研究的意义 ................................................................................................................1
1.4 本课题的研究方法 ................................................................................................................1
2 开发工具和采用技术介绍 ...........................................................................................................2
2.1 开发工具简介 ........................................................................................................................2
2.1.1 Sql Server2000 .................................................................................................................2
2.1.2 Dreamweaver 8.................................................................................................................2
2.1.3 IIS 5.0 ...............................................................................................................................2
2.2 采用技术简介 ........................................................................................................................3
2.2.1 ASP 技术简介..................................................................................................................3
2.2.2 B/S(Browser/Server)结构 ................................................................................................3
2.2.3 Web 数据库访问原理......................................................................................................3
3 系统总体设计 ...............................................................................................................................4
3.1 系统概要 .................................................................................................................................4
3.2 系统构成 ................................................................................................................................4
3.3 身份验证模块 .........................................................................................................................5
3.3.1 会员登陆 ..........................................................................................................................5
3.3.2 管理员登陆 .....................................................................................................................5
3.4 信息发布 .................................................................................................................................5
3.4.1 游客留言发布 .................................................................................................................5
3.4.2 会员发布信息 .................................................................................................................5
3.4.3 管理员发布公告消息 .....................................................................................................5
3.5 数据查询 ................................................................................................................................5
3.5.1 查看所有房屋信息和留言信息 .....................................................................................5
3.5.2 模糊查询房屋信息 .........................................................................................................5
3.5.3 会员查看自己发布的信息 .............................................................................................6
3.6 数据管理 ................................................................................................................................6
3.6.1 密码修改 .........................................................................................................................6
3.6.2 删除留言 .........................................................................................................................6
3.6.3 编辑房屋信息 .................................................................................................................6
3.7 数据计算 ................................................................................................................................6
3.7.1 会员设定收费标准 .........................................................................................................6
3.7.2 计算所有收费项目并详细显示 .....................................................................................6
3.8 数据库设计 ............................................................................................................................7
3.8.1 管理员信息表 admin ......................................................................................................7
3.8.2 房屋管理表 house_manage ...........................................................................................7
3.8.3 房屋留言表 house_note .................................................................................................7
3.8.4 房屋信息表 info.............................................................................................................8
3.8.5 新闻表 news ...................................................................................................................8
3.8.6 留言表 note ....................................................................................................................9
3.8.7 用户表 user.....................................................................................................................9
3.8.8 房屋推荐表 tuijian .........................................................................................................9
3.9 系统工作流程 ........................................................................................................................9
3.9.1 用户工作流程 .................................................................................................................9
3.9.2 管理员工作流程 ...........................................................................................................10
4 系统详细设计与实现 .................................................................................................................11
4.1 数据库访问的实现 ...............................................................................................................11
4.1.1 WEB 数据库连接代码 ..................................................................................................11
4.2 登陆模块代码实现 ..............................................................................................................12
4.2.1 会员登陆实现 ...............................................................................................................12
4.3 查询模块的实现 ...................................................................................................................14
4.4 数据插入更新删除 ..............................................................................................................16
4.4.1 数据插入 .......................................................................................................................16
4.4.2 数据更新 ........................................................................................................................17
4.4.3 数据删除 .......................................................................................................................17
4.4.4 数据计算 .......................................................................................................................17
4.5 开发中所遇到的问题及解决办法 ......................................................................................19
4.5.1 开发中遇到的问题 .......................................................................................................19
4.5.2 解决办法 .......................................................................................................................19
5 系统测试 ......................................................................................................................................19
5.1 测试内容 ...............................................................................................................................19
5.2 测试结果和分析 ...................................................................................................................19
结 论 .............................................................................................................................................20
参考文献 .........................................................................................................................................20
