目 录
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 功能需求..........................................................................................................................................11
3.3.1 基本功能需求.........................................................................................................................11
3.3.2 功能模块.................................................................................................................................11
3.4 性能需求..........................................................................................................................................12
3.4.1 系统安全性..............................................................................................................................12
3.4.2 数据库选择.............................................................................................................................12
4 宿舍管理系统设计 .............................................................................................................................13
4.1 数据库设计......................................................................................................................................13
4.1.1 物理设计...............................................................................................................................13
4.1.2 E-R 模型设计.........................................................................................................................13
4.1.3 表/字段及表间关系设计......................................................................................................16
4.2 模块设计..........................................................................................................................................17
4.2.1 登录管理模块 .......................................................................................................................18
4.2.2 房间管理模块 .......................................................................................................................19
4.2.3 信息维护模块 .......................................................................................................................19
5 系统实现.............................................................................................................................................21
5.1 系统环境..........................................................................................................................................21
5.2 子系统功能模块的实现 ..................................................................................................................21
5.2.1 用户登录模块 .......................................................................................................................21
5.2.2 学生管理模块 .......................................................................................................................22
5.2.3 楼房信息管理模块 ...............................................................................................................22
5.2.4 房间管理模块 .......................................................................................................................23
5.2.5 班级管理模块 .......................................................................................................................23