摘要
        
高校学生宿舍管理系统是典型的信息管理系统(MIS),其开发主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。对于后台数据库的建立和维护要求建立起数据一致性和完整性强、数据安全性好的库。而对于前端应用程序的开发则要求应用程序能提供强大的数据操纵功能，界面友好、使用简单方便等特点。我们使用Microsoft公司的SQL SERVER 2005数据库为开发工具,JAVA是比较完备的面向数据库开发工具,同时它也利用其提供的各种面向对象的开发工具,尤其是数据窗口这一能方便而简洁操纵数据库的智能化对象,提供了强大的数据环境,更有利于对数据库和数据表的直接操作和处理，提高了编程效率和可靠性。旧的手工纪录的宿舍管理方式已经不能适应高速发展的信息化时代，新的宿舍管理系统开发出来之后，学校的现有的宿舍信息管理将有很大的改观，由过去的人工方式转变为计算机方式，由效率低、数据冗余、易产生错误转变为检索迅速、查找方便、可靠性高、存储量大。这些优点能够极大地提高效率,也是学校科学化、正规化管理的重要条件。

关键词：学生宿舍管理系统；JSP 服务器；MyEclipse平台；SQL SERVER 2005

Abstract

College dormitory management system is a typical management information system (MIS), its development include the establishment and maintenance of back-end database and front-end application development aspects.For the background database creation and maintenance requirements to establish a strong data consistency and integrity, data security, a good library.As for the front-end application development application is required to provide powerful data manipulation capabilities, user-friendly, easy to use and so on.We use Microsoft's SQL SERVER 2005 database development tools, JAVA is more complete for database development tool, but it also offers a variety of its object-oriented development tools, especially data that can be convenient and simple windowintelligent manipulation of database objects, the data provides a powerful environment more conducive to the database and data tables for the direct operation and handling, to improve the programming efficiency and reliability.The old manual records management quarters has been the rapid development of information technology can not meet the age, the new dormitory management system developed, the school's existing accommodation information management will be a great change from the past into the computer manuallyway, the efficiency is low, data redundancy, easy to retrieve the error into a fast, easy to find, high reliability, large memory capacity.These advantages can greatly improve efficiency, but also the scientific school, standardized management of important conditions.
 
Keywords: Student accommodation management system; JSP server; MyEclipse platform; SQL SERVER 2005

 
目录
 
摘    要................................................................. X
Abstract................................................................ XI
1 绪    论............................................................... 1
1.1 研究背景........................................................... 1
1.2 国内外发展现状..................................................... 1
1.3出现的问题.......................................................... 3
2 系统设计使用技术介绍................................................. 4
2.1 JAVA技术........................................................... 4
2.2 JAVABEAN........................................................... 4
2.3 JDBC............................................................... 4
2.4 JSP技术............................................................ 5
2.5 MYECLIPSE简介...................................................... 7
2.6 SQL SERVER 2005简介................................................ 7
3 系统分析............................................................... 9
3.1 可行性分析......................................................... 9
3.2 系统需求分析....................................................... 9
3.3 系统数据流图...................................................... 11
4 系统总体设计.......................................................... 12
4.1 系统设计目标...................................................... 12
4.2 系统总体功能...................................................... 12
4.3 系统结构图........................................................ 13
5 详细设计及实现........................................................ 15
5.1.1 数据库的引入................................................... 15
5.1.2数据库概念结构设计E-R图....................................... 16
5.1.3 数据库逻辑结构设计............................................. 20
5.2.1 管理员模块设计................................................. 25
5.2.2 寝室长与室员模块设计........................................... 30
6 系统测试.............................................................. 35
结    论................................................................ 37
致    谢................................................................ 38
参考文献................................................................ 39
附    录................................................................ 40