四川理工学院毕业设计（论文）
高校学生公寓管理系统的设计与实现
学 生: 任迎春 学 号: 07101010218 专 业: 计算机科学与技术 班 级: 2007级2班 指导教师: 刘小芳
四川理工学院计算机学院
二O一一年六月
高校学生公寓管理系统的设计与实现
摘 要
本论文主要阐述了高校学生公寓管理系统的设计与实现。用ASP.NET作为前台开发工具和SQL Server 2005作为后台数据库开发的一个管理系统。论文详细介绍了系统需求分析、系统框架及功能模块设计、数据库设计、安全保密设计。系统具有员工管理、学生管理、公寓管理等功能，包括了员工管理模块、学生管理模块、公寓管理模块、查询统计模块和系统管理模块设计。员工管理模块主要完成了员工基本信息查看、岗位职责描述、值班记录和员工培训；学生管理模块主要完成了学生基本信息录入和学生基本信息查询；公寓管理模块主要完成了学生入住管理、物品管理、水电管理、维修管理等；查询统计模块主要完成了查询住宿、来访查询、水电查询等；系统管理模块主要完成了管理员添加、数据库备份、数据库还原等；该系统不仅提高了学生公寓管理的效率，而且还具有操作的简便性，良好的实用性。
关键词：学生公寓管理，员工管理，查询
I
College students' apartments management system design
and implementation
Abstract
This paper mainly expounds the college students' apartments management system design and implementation. With asp.net as a receptionist development tools and SQL Server 2005 as the backend database development of a management system. Paper introduces system requirement analysis, system framework and function module design, database design, the security design. System has staff management, student management, apartments management, and other functions, including the employee management module, the student management module, apartments management module, inquires the statistical modules and systems management module design. The staff management module mainly completed employee basic information view, responsibilities description, on-duty records and staff training; Student management module mainly completed students basic information recorded and students' basic information query; Apartments management module mainly completed student check-in management, item management, water management, maintenance, etc.; The inquiry statistics module mainly completed inquires the accommodation, visiting, inquiry, hydropower query etc; Systems management module mainly completed administrator add, database backup, database reduction etc; This system not only improves students' apartments management efficiency, but also has the simplicity of operation, good practicability.
Keywords : Students' apartments management, Employee management, Information
II
目 录
第1章 绪 论 ........................................................................................................... 1 1.1 开发背景 .............................................................................................................. 1 1.2 目的和意义 .......................................................................................................... 1 1.3 国内外进展 .......................................................................................................... 1 1.3.1 国外进展 ....................................................................................................... 1 1.3.2 国内进展 ....................................................................................................... 1 1.4 本文工作的主要内容 ......................................................................................... 2 第2章 需求分析 ........................................................................................................... 4 2.1 系统需求简介 ...................................................................................................... 4 2.1.1 系统目标 ....................................................................................................... 4 2.1.2 功能需求分析 .............................................................................................. 4 2.1.3 性能需求分析 .............................................................................................. 4 2.2 可行性分析 .......................................................................................................... 5 2.2.1 经济可行性分析 .......................................................................................... 5 2.2.2 技术可行性分析 .......................................................................................... 5 2.2.3 操作可行性分析 .......................................................................................... 5 第3章 总体设计 ........................................................................................................... 6 3.1 设计概述 .............................................................................................................. 6 3.2 系统总体结构及功能模块划分 ......................................................................... 6 3.2.1 员工管理模块 .............................................................................................. 6 3.2.2 学生管理模块 .............................................................................................. 7 3.2.3 公寓管理模块 ............................................................................................ 7 3.2.4 查询统计模块 .............................................................................................. 8 3.2.5 系统管理模块 .............................................................................................. 9 3.3 系统数据库概念结构设计 ................................................................................. 9 3.3.1 系统E-R图 .................................................................................................. 9 3.3.2 系统数据库的设计 .................................................................................... 10 3.4 安全保密设计 .................................................................................................... 16 3.4.1 用户登陆安全性 ........................................................................................ 16
III