摘要
本文参考了目前国内小区物业管理的发展情况以及管理模式，对小区物业管理系统进行了总体的设计，建立基于Web的运行平台，实现方便快捷的前端Web登陆和查询，采用Microsoft Access2003作为后台数据库，采用ASP技术对数据库进行操作和维护。本文讨论了访问Web数据库的五种方法，介绍每种方法的工作原理和优缺点。最后，本文对利用ASP技术访问数据进行了阐述和介绍。主要介绍了ASP的工作原理，页面结构，ASP提供的内置对象和组件以及使用ASP对Web数据库进行操作的方法。同时，对基于B/S的小区物业管理系统的设计和实现方法作了说明。
本系统要实现的总体功能是对房屋资料和住户信息进行统一的管理。房屋资料管理包括：管理员的房屋资料管理和房屋资料的查询；住户信息管理包括：住户信息管理，住户投诉及报修，小区公告及论坛。本人负责房屋资料管理模块，主要实现如下功能：管理员的房屋资料管理：包括房屋资料的添加,房屋资料的删除,房屋资料的编辑修改。管理员可以在网上对每个房屋的资料信息进行统一的管理。房屋资料查询：这个模块可以让管理员和普通用户进行关于房屋资料的查询。方便用户知道自己或别人的房屋信息。并对每个功能模块的设计思路和实现方法，具体的设计过程中所遇到的问题，设计难点以及具体的解决方案等作出了详细的阐述
关键字：B/S结构；Asp；小区物业管理系统；Access
Abstract
This text has consulted the development of the estate management of domestic district and management mode at present, carry on the total design to the property administrative system of the district, set up the operation platform based on Web, realize convenient and swift front Web login and searching, adopts Microsoft Access2003 as backstage supporter's database, adopt ASP technology to operate and maintain the database. This text discusses five kinds of methods to visit Web database, introduce operation principle and pluses and minuses of each kind of method. Finally, this text, to utilizing ASP technology and visiting the data and explaining and introducing. Introduce operation principle of ASP mainly, page structure, built-in target and package that ASP offer and use ASP go on method that operate to Web database. Meanwhile, doing the design based on district property administrative system of B/S and implementation method proves.
The overall function that this system should be realized is to carry on the management of the unity to the house materials and household's information. The materials management of the house includes: The administrator's house materials management and inquiry of house materials; Household's information management includes: Household's information management, the household complains and reports for repairing, district announcement and forum. I am responsible for the house materials and manage the module, mainly realize the following function: The administrator's house materials management: Including the adding of house materials, the deletion of the house materials, the editor of the house materials revises. The administrator can carry on unified management to the materials information of each house on the net. The house materials are inquired about: The module can let administrator and ordinary user go on about house inquiry of materials. Help users know oneself or others' house information. And to mentality of designing and implementation method of each function module, the question met in the concrete design process, design the difficult point and concrete solution, etc. to make detailed exposition
Key word: B/S structure; Asp; Property administrative system of the district; Access
目录
第1章 绪论... 1
1.1 开发背景及现状... 1
1.2 现行存在的问题及解决方法... 1
1.3 C/S体系结构与B/S体系结构的比较... 3
1.3.1客户机/服务器模式(C/S) 4
1.3.2 浏览器/服务器模式... 4
1.3.3 客户机/服务器和浏览器/服务器结构的比较... 5
1.4 系统的运行环境... 6
第2章 系统需求分析... 7
2.1 需求分析... 7
2.1.1 系统E-R图... 7
2.1.2 系统总体框架图... 7
2.1.3 数据字典... 8
2.2 系统设计目的... 8
2.3 系统特点... 9
第3章ASP技术... 10
3.1 ASP的工作原理... 10
3.2 ASP的页面结构... 10
3.3 ASP的特点... 11
3.4 ASP的内置对象... 11
3.4.1 ASP的内置对象... 11
3.4.1.1 Request对象... 12
3.4.1.2 Response对象... 13
3.4.1.3 Server对象... 14
3.4.1.4 Application对象... 15
3.4.1.5 Session对象... 15
3.4.1.6 ObjectContext对象... 16
3.5 动态服务器页面ASP(Active Server Page) 16
3.5.1 ADO对象... 16
3.5.1.1 基本 ADO 编程模型... 16
3.5.1.2 connection对象... 17
3.5.1.3 Recordset 对象... 18
3.5.1.4 Execute 方法 (ADO Connection) 19
3.5.1.5 Open 方法... 19
第4章 系统的设计和实现... 22
4.1主页的制作... 22
4.2登陆用户的验证... 22
4.2.1 建立数据库连接... 22
4.2.2 页面设计... 25
4.2.3 登陆判定... 29
4.2.3管理页面... 31
第5章 结束语... 41
致谢... 43
参考文献... 42
