学生宿舍管理系统设计与实现

本科毕业设计(论

文)

学院

专业信息管理与信息系统

学生

班级学号

指导教师

二零壹壹年五月

科技大学本科毕业论文

学生宿舍管理系统设计与实现

ChongQing Creation Vocational College Students’ bedroom

Management System

科技大学成人高等教育届毕业设计任务书学院：专业：信息管理与信息系统班级：

摘要

学生宿舍管理是学校的一项重要工作，使用计算机来管理学生宿舍，不但可以节省时间和人力，更能全面、有效地掌握学生基本情况，及时获取最新的准确资料和信息。本学生宿舍管理系统是以C#2005为前台开发工具，以Microsoft SQL Server 2000为后台数据库开发工具的一套完整的基于C/S (Client/ Server)管理信息系统。C# 2005语言是一种面向对象的开发工具，具有组件丰富、语言简单、功能强大的优点。

论文主要介绍了本系统的开发背景，所要完成的功能和开发的过程。重点的说明了系统设计的重点、设计思想、难点技术和解决方案。本系统为用户提供强大的数据操纵功能，界面友好、使用简单方便，同时基于客户机/服务器模式，可实现通过网络对数据进行远程管理。采用审计的方式详细的记载每个用户的登陆信息，并且对数据库进得完全备份或差异备份，能够对数据库进行还原。在对系统在设计过程中进行白盒测试和对完成阶段进行黑盒测试。该设计基本合理，功能比较完备，经过测试运行稳定，能够满足工作中的基本需要。

关键词：学生宿舍管理系统；SQL Server 2000数据库； C# . NET

Abstract

Bedroom management is a important work of school,We use the computer to manage the students’ scores, which can not only save time and manpower, but also know well the students’ condition completely and o btain the latest accurate data and information. This Students’ scores management system is take C#2005 as the developing instrument of front desk, a set of intact ones which regard Microsoft SQL Server 2000 as the database developing instrument of backstage supporter are because of C/S (Client/ Server ) the management information system. C# language is one kind of object-oriented development kit, has the module richly, the language is simple, the function formidable merit.

The paper mainly introduced this topic development background, must complete function and development process. Key explanation system design key point, design thought, difficult technology and solution. This system provides the formidable data operation function for the user, the contact surface is friendly simply, simultaneously based on the Client / Server pattern, may realize through the network logarithm according to carries on the long-distance management. Uses the audit way detailed record each user to register the information, with according to different need, to user assignment different jurisdiction, and enters the complete backup

or the difference backup to the database,Can carry on the return to original state to the database.And carries on Bai He to the system in the design process to test and to completes the stage to carry on the black box test. The design is reasonable, the function is completely right through experiment, the running is stable and it can meet the need of the work.

Key words:The students’bedroom manage system ; SQL Server 2000 Database ;C#.NET

目录

第一章绪论---------------------------------------- 1 1.1项目开发背景-------------------------------------------------- 1 1.2项目开发目标-------------------------------------------------- 1 1.3项目提出的意义------------------------------------------------ 2 1.4开发工具的选择------------------------------------------------ 2第二章需求分析------------------------------------ 3 2.1用户界面需求-------------------------------------------------- 3 2.2基本功能需求-------------------------------------------------- 4 2.3建立功能模型-------------------------------------------------- 4第三章总体设计------------------------------------ 7 3.1功能模块设计-------------------------------------------------- 7 3.2系统控制结构------------------------------------------------- 10 第四章数据库设计----------------------------------------------------- 12 4.1概念结构设计------------------------------------------------- 12 4.2逻辑结构设计------------------------------------------------- 17 4.3数据库物理结构设计------------------------------------------- 20

4.3.1确定数据库的物理结构------------------------------------- 21

4.3.2评价物理结构--------------------------------------------- 22 第五章详细设计------------------------------------ 23

5.1登陆界面设计------------------------------------------------- 23