内容发布更新时间 : 2025/1/10 4:56:34星期一 下面是文章的全部内容请认真阅读。

摘 要

当今大学校园内的学生宿舍，其数据量大，各种信息管理内容复杂，查询和管理学生信息和校园内的宿舍信息等工作由人工完成将是很累的，不仅浪费了许多人力物力资源，而且还很容易出现差错，有一个软件对学生宿舍管理不仅节省了人力物力，而且对各种信息的把握和操作也更加方便。

该学生宿舍管理系统主要包括前台用户界面的开发和后台数据库的开发，对于后台数据库要求建立起数据一致性和完整性强、数据安全性好的数据库。而对于前端应用程序的开发则要求应用程序能提供强大的数据操纵功能，界面友好、使用简单方便等特点。管理人员需要做的就是将数据输入到系统的数据库中去。经过分析，本系统运用了SQL Server为后台数据库，以Microsoft Visual Studio 2010为前端开发工具，系统实现了房间管理、宿舍管理、信息维护、宿舍分配、信息查询等必需的功能，其操作简单，界面友好，运行比较稳定。

关键词： 学生宿舍管理；SQL Server 数据库；B/S

Abstract

Student dormitory university campus today , the large amount of data , a variety of information management complexity , query and manage student information and information on campus dormitories and other work will be completed by hand tired , not only wasting a lot of human and material resources , and very prone to error , there is a student dormitory management software not only saves manpower and resources, but also to grasp and manipulate a variety of information is also more convenient.

The student hostel management system includes back-end database development and the development of the user interface front , the back-end database required consistency and integrity, data security database . As for the front-end application development requires applications to provide powerful data manipulation capabilities, user-friendly, easy to use features. Managers need to do is to enter data into a database system to go. After analysis, the system uses the SQL Server as the back-end database to Microsoft Visual Studio 2010 as a front-end development tools, system management realized the room , dormitory management, information maintenance, dorm assignments, information and other necessary functions , simple operation , the interface Friendly, run relatively stable.

Keywords: Student hostel management; SQL Server database; B / S

目 录

1 绪论 ......................................................................................................................................................... 1 1.1 课题开发背景和意义 .......................................................................................................................... 1 1.2 课题研究现状 ...................................................................................................................................... 1 1.3本课题的研究内容 ............................................................................................................................... 2 1.4 本论文组织结构介绍 .......................................................................................................................... 2 2 开发环境介绍 ....................................................................................................................................... 4 2.1 .NET Framework与ASP.NET................................................................................................................. 4

2.1.1 .NET Framework ......................................................................................................................... 4 2.1.2 ASP.NET ...................................................................................................................................... 4 2.2 SQL Server 数据库 ................................................................................................................................ 6 3 宿舍管理系统分析 ............................................................................................................................... 8 3.1系统可行性分析 ................................................................................................................................... 8 3.2系统用例分析 ....................................................................................................................................... 9 3.3 功能需求 .......................................................................................................................................... 10

3.3.1 基本功能需求 ......................................................................................................................... 10 3.3.2 功能模块 ................................................................................................................................. 11 3.4 性能需求 .......................................................................................................................................... 11

3.4.1系统安全性 .............................................................................................................................. 11 3.4.2 数据库选择 ............................................................................................................................. 11 4 宿舍管理系统设计 ............................................................................................................................. 12 4.1 数据库设计 ...................................................................................................................................... 12

4.1.1 物理设计 ............................................................................................................................... 12 4.1.2 E-R模型设计 ......................................................................................................................... 12 4.1.3 表/字段及表间关系设计 ..................................................................................................... 15 4.2 模块设计 .......................................................................................................................................... 17

4.2.1 登录管理模块 ....................................................................................................................... 17 4.2.2 房间管理模块 ....................................................................................................................... 18 4.2.3 信息维护模块 ....................................................................................................................... 18 5 系统实现 ............................................................................................................................................. 20 5.1 系统环境 .......................................................................................................................................... 20 5.2 子系统功能模块的实现 .................................................................................................................. 20

5.2.1 用户登录模块 ....................................................................................................................... 20 5.2.2 学生管理模块 ....................................................................................................................... 21 5.2.3 楼房信息管理模块 ............................................................................................................... 21 5.2.4 房间管理模块 ....................................................................................................................... 22 5.2.5 班级管理模块 ....................................................................................................................... 22