中国大学生毕业设计(学院)
基于.NET的学生宿舍管理系统设计
专业
2012年3月16日
学生姓名 班学
级 号
指导教师 完成日期
II
摘 要
随着网络应用技术的飞速发展，基于网络的应用系统给人们带来了诸多便利。管理信息系统在现代社会已深入到各行各业，由于计算机技术的迅速发展和普及，信息管理系统MIS事实上已成为计算机管理信息系统，随着高校学生数量增加对高校学生宿舍管理也是越来越重要，大学生宿舍管理系统就是一个典型的管理信息系统，它可以让宿舍管理工作变的更轻松。本毕业设计的任务就是设计一个大学生宿舍管理系统。其开发过程主要包括前端应用程序的开发和后台数据库的建立和维护两个方面。主要任务就是建立基本数据，后台程序主要负责的都是管理上的功能。
经过分析，本系统运用了Microsoft SQL Server2000为后台数据库，以Visual studio.NET 2005为前端开发工具，系统实现了系统维护、宿舍管理、学生管理、宿舍分配、信息查询等必需的功能，其操作简单，界面友好，运行比较稳定，适用于大学院校大学生宿舍管理。
关键词：宿舍管理；信息；vs2005 ；SQL2000
III
Abstract
With the rapid development of network technology, web-based application systems to bring people a lot With the rapid development of network technology, web-based application systems to bring people a lot of convenience. Management information system in modern society has been deep into all walks of life, due to the rapid development of computer technology and universal, management information system MIS in fact has become a computer information management system, with the increase in the number of college students on the university student's dormitory management is becoming more and more important, dormitory management system is a typical management information system, it can let dormitory management become more relaxed. The task of this graduation design is to design a management system for college student's dormitory. The process of its development mainly includes the development of front application program and database background to the establishment and maintenance of two aspects. The main task is to set up the basic data, daemons are mainly responsible for the management of function.
After the analysis, the system used Microsoft SQL Server2000 as background database, using Visual studio.NET 2005 as the developing tool, system of system maintenance, dormitory management, student management, dormitory distribution, information and other necessary functions, simple operation, friendly interface, operation is more stable, applicable to university students dormitory management.
Key words: dormitory management; information; VS2005; SQL2000
IV
目 录
摘 要 ............................................................ III Abstract .......................................................... IV 第一章 绪 论 ....................................................... 1
1．1 选题背景及现状 ............................................ 1
1．2 研究目的和意义 ............................................ 1 1．3开发所用技术及特点 ........................................ 2
1.3.1 B/S开发模式 ......................................... 2 1.3.2 ASP.NET及Visual Studio介绍 ......................... 3 1.3.3 ADO.NET介绍 ......................................... 5 第二章 系统分析与总体设计 ......................................... 7
2．1 系统需求分析 .............................................. 7 2．2 系统功能分析 ............................................. 7
2.2.1调查用户需求 ......................................... 7 2.2.2系统功能的设计和划分 ................................. 9 2.3系统架构分析 ............................................... 9 2.4系统可行性分析 ............................................ 11 2.5系统总体设计 .............................................. 11
2.5.1系统设计目标 ........................................ 11 2.5.2系统总体功能设计 .................................... 12 2.5.2功能模块 ............................................ 12 2.6系统数据流图 .............................................. 15 第三章基本的理论 .................................................. 16
3.1数据库介绍 ................................................ 16 3.2数据库概念结构设计E-R图 .................................. 17
3.2.1概念结构设计 ........................................ 17 3.2.2数据库逻辑结构设计 .................................. 21 第四章 功能模块详细设计 ........................................... 26
4. 1登录模块设计 ............................................. 26 4. 2后台管理主界面设计 ....................................... 26 4. 2寝室长与室员模块设计 ..................................... 28 第五章 系统测试 .................................................. 33
5.1 测试的任务及目标 .......................................... 33
5.1.1测试的任务 .......................................... 33 5.1.2测试的目标 .......................................... 33 5.2测试方案 .................................................. 33
5.2.1模块测试 ............................................ 33
V
5.2.2集成测试 ............................................ 34 5.2.3验收测试 ............................................ 34 5.2.4平行运行 ............................................ 34
第六章 系统使用维护 .............................................. 35
6.1系统使用说明 .............................................. 35 6.2系统的维护 ................................................ 35 结 论 ............................................................ 37 致 谢 ............................................................. 38 参考文献 .......................................................... 39 附件程序清单 ...................................................... 40
VI