学生宿舍管理系统
学 院
计算机学院
专 业
计算机科学与技术
班 级
学 号
姓 名
指导教师
负责教师
************大学
2011 年 2 月
摘 要
随着电脑的普及与使用，现在的管理也提升了一个档次，渐渐实现了无纸化办公，即从原来
的人工记录管理模式转变为电脑一体化管理。高校是科研的阵地，后勤的宿舍管理也应该一改传
统的人工管理，更加信息化，时代化，节省人力物力，提高效率。学生宿舍是每一位在校学生生
活、学习、相互交流的主要场所，如何提供一个良好的学生宿舍的管理体系，对学校和同学而言
至关重要。以往的学生宿舍管理基本上还处于人工操作的阶段，随着计算机技术和网络技术的日
益广泛应用，采用计算机以及网络来管理学生宿舍，有着很好的前景。基于这一点，开发此学生
宿舍管理软件。
论文将设计一个学生宿舍管理系统的 Web 应用解决方案并予以实现。学生宿舍管理系统是
一个安全和高效的专用系统,。这个系统使用了很多技术，比如 JSP,JDBC 等。专用系统使用的数
据库是 SQL Server 2005 数据库。基于 JSP 学生宿舍管理系统的主要功能包括：可以实现对学生
宿舍信息的录入功能,修改功能,删除功能。通过系统上述功能实现宿舍管理部门对于学生宿舍信
息的日常管理，即方便宿舍管理人员及时全面地掌握学生住宿情况及宿舍分配情况；为用户（管
理用户和一般用户，如学生）提供了一些简单的数据查询并输出各种信息等；在实现检索迅速和
查找方便的同时,对新入校学生很快地进行宿舍安排等日常管理。
关键字：宿舍管理，学生宿舍信息，B/S 模式；SQL Server 2005
Abstract
With the popularity of computers and use, current management has improved a notch, and
gradually achieve a paperless office, from the original manual records management into the integrated
management of the computer. Colleges and universities are research positions, dormitory management
of logistics should also be changed the traditional manual management, more information, times of,
saving manpower and resources and improve efficiency. Each dormitory is the student life in school,
learning, the main place to communicate with each other, how to provide a good student hostel
management system is critical for schools and students. Dormitory Management is basically the
previous manual operation is still in the stage, with the computer technology and network technology
becomes more widely used, the use of computers and networks to manage the student hostel, with good
prospects. Based on this, developing the student dormitory management software.
Thesis, a student hostel management system solutions and Web applications to be realized. Student
hostel management system is a safe and efficient dedicated system. The system uses a number of
technologies such as JSP, JDBC and so on. Dedicated system using the database is SQL Server 2005
database. Dormitory Management System based on JSP main features include: can the student
dormitories information input function, modify the function, delete function. Through the system to
achieve the above functions for the student hostel dormitory management information, daily
management, the management staff to facilitate timely accommodation of students fully grasp the
allocation of accommodation and hostels; for the user (management of users and general users, such as
students) to provide some simple data query and export all kinds of information; in achieving rapid and
find easy to retrieve the same time, new students quickly into the arrangements for the daily
management of the hostel.
Keywords: dormitory management, information on student hostels, B / S mode; SQL Server 2005
目 录
摘 要................................................................................................................................1
Abstract ..................................................................................................................................2
1 引言.....................................................................................................................................1
1.1 选题背景 ......................................................................................................................1
1.2 研究意义 ......................................................................................................................1
1.3 研究思路和方法 ..........................................................................................................2
1.4 预期结果 ......................................................................................................................2
2 开发平台及语言介绍.........................................................................................................3
2.1 基于 B/S 结构开发 ......................................................................................................3
2.2 JAVA 语言简介 ...........................................................................................................3
2.3 JSP 技术 .......................................................................................................................3
2.4 Tomcat .......................................................................................................................5
2.5 SQL Server 2005 ..........................................................................................................6
2.6 Eclipse...........................................................................................................................7
3 需求分析.............................................................................................................................9
3.1 基本要求分析 ..............................................................................................................9
3.2 设计条件分析 ..............................................................................................................9
3.3 系统技术分析 ..............................................................................................................9
3.4 可行性分析 ................................................................................................................10
3.4.1 管理上的可行性..................................................................................................10
3.4.2 技术上的可行性..................................................................................................10
3.4.3 经济上的可行性..................................................................................................10
3.4.4 分析结论..............................................................................................................10
3.5 系统功能分析 ............................................................................................................11
4 总体设计...........................................................................................................................12
4.1 系统功能模块的设计 ................................................................................................12
4.2 数据库设计 ................................................................................................................12
4.3 物理结构设计 ............................................................................................................14
4.4 出错设计 ....................................................................................................................14
5 详细设计...........................................................................................................................15
5.1 登入界面 ....................................................................................................................15
5.2 管理登录主界面 ........................................................................................................15
5.2.1 录入学生信息......................................................................................................16
