摘 要

本系统是根据XXX大学的具体情况设计的宿舍管理系统，意在达到对XX学生宿舍的管理。学生宿舍管理系统对于一个学校来说是必不可少的组成部分，同时该系统的开发仍然采用典型的C/S架构，系统整体的开发就可以概括为前台界面开发和后台功能实现开发。学生宿舍管理系统采用的是计算机化管理，系统做的尽量人性化，使用者会感到操作非常方便，管理人员需要做的就是将数据输入到系统的数据库中去。由于数据库存储容量相当大，而且比较稳定，适合较长时间的保存，也不容易丢失。这无疑是为信息存储量比较大的学校提供了一个方便、快捷的操作方式。系统共分为九大模块：基本资料设置模块、学生信息管理模块、信息查询模块、学生社区管理模块、水电费管理模块、来访管理模块、物品出楼管理模块、报修管理模块、账户管理模块，每个模块将实现不同功能。本系统具有运行速度快、安全性高、稳定性好的优点，并且具备完善的查询、修改功能，能够快速的查询学校所需的住宿信息。

本系统采用.NET技术，开发工具为Visual Studio 2010，数据库为Microsoft SQL Server 2008。

关键词：XX宿舍管理系统；C/S；SQL Server 2008；Visual Studio 2010

I

Abstract

This system is designed according to the actual circumstances of the qiqihar university dormitory management system, to achieve alignment of college students' dormitory management. For a school dormitory management system is an essential part of the development of the system is still at the same time using a typical C/S structure, web site overall development can be summarized as the front desk page development and backend functionality implementation. Student dormitory management system USES a computerized management system of human nature as far as possible, users will feel very convenient operation, management needs to do is to input data into the database of the system. Because the database storage is quite big, and relatively stable, save for a long time, is not easy to lost. This is for information storage capacity is large school provides a convenient and fast operation mode. System is divided into nine big modules: basic data setup module, student information management module, information query module, the student community management module, management module, management module, visit the utilities management module, the items out of the building management module, report management module, accounts management module, every module to realize different functions. This system has quick speed, high security, good stability, and have perfect query generation, modify function, can quickly query the school accommodation information needed.

The system uses .NET technology, development tools for Visual Studio 2010, for Microsoft SQL Server 2008 database.

Key Words: Qiqihar university dormitory management system; C/S; SQL Server 2008; Visual Studio 2010

II

目 录

摘要 ................................................................................................................................................................. I Abstract ........................................................................................................................................................ II

第1章 绪论 ............................................................................................................................................. 1

1.1 网站开发背景 ......................................................................................................................... 1 1.2 系统实现目的和意义 ............................................................................................................ 1 1.3 系统开发要求 .......................................................................................................................... 2 1.4 系统开发环境 .......................................................................................................................... 3

1.4.1 ASP.NET简介 ............................................................................................................... 3 1.4.2 数据库简介 .................................................................................................................. 3 1.5 本章小结 ................................................................................................................................... 4 第2章 系统可行性分析 ....................................................................................................................... 5

2.1 系统设计流程及可行性分析 ............................................................................................... 5 2.2 本章小结 ................................................................................................................................... 6 第３章 系统的需求分析 ....................................................................................................................... 7

3.1 需求概述 ................................................................................................................................... 7 3.2 功能需求 ................................................................................................................................... 7

3.2.1 基本功能需求 .............................................................................................................. 7 3.2.2 系统用例图 .................................................................................................................. 8 3.3 系统的非功能需求 ................................................................................................................. 8 3.4 本章总结 ................................................................................................................................... 9 第４章 系统的总体设计 ..................................................................................................................... 10

4.1 网站体系结构设计 ............................................................................................................... 10 4.2 功能设计 ................................................................................................................................. 10 4.3 数据库结构设计 .................................................................................................................... 11

4.3.1 概念结构设计 ............................................................................................................ 11 4.3.2 数据实现 ..................................................................................................................... 15 4.4 本章小结 ................................................................................................................................. 18 第５章 系统详细设计与实施 ............................................................................................................ 19

5.1 系统模块设计 ........................................................................................................................ 19 5.2 管理员登录模块的设计与实现 ........................................................................................ 19

5.2.1 实现目标 ..................................................................................................................... 19 5.2.2 实现过程 ..................................................................................................................... 20 5.3 学生信息管理模块 ............................................................................................................... 21

5.3.1 各部分实现的功能................................................................................................... 21 5.3.2 实现过程 ..................................................................................................................... 22 5.4 水电费管理模块 .................................................................................................................... 23

5.4.1 各部分实现的功能................................................................................................... 23 5.4.2 实现过程 ..................................................................................................................... 23 5.5 来访管理功能图 .................................................................................................................... 24

III