西安航空职业技术学院 毕业论文 学生宿舍管理系统
高校学生宿舍管理系统
【摘要】
高校学生宿舍管理系统是典型的信息管理系统(MIS)，其开发主要包括后台数据库的建立和维护以及前端程序的开发两个方面。对于后台数据库的建立和维护要求建立起数据一致性和完整性强、数据安全性好的库。而对于前端应用程序的开发则要求应用程序能提供强大的数据操纵功能，界面友好、使用简单方便等特点。
系统使用PHP和MYSQL数据库为开发工具，PHP对数据库有强大的处理功能，与MYSQL是公认最完美的组合。同时它也利用当今最流行的也很实用的PHP框架和模板引擎，以及根据实际设计出了最合适本项目开发的设计模式，提高了编程效率和可靠性。
旧的手工纪录的宿舍管理方式已经不能适应高速发展的信息化时代，新的宿舍管理系统开发出来之后，学校的现有的宿舍信息管理将有很大的改观，由过去的人工方式转变为计算机方式，由效率低、数据冗余、易产生错误转变为检索迅速、查找方便、可靠性高、存储量大。这些优点能够极大地提高效率,也是学校科学化、正规化管理的重要条件。
关键词：学生宿舍；管理信息系统； PHP；MySQL
西安航空职业技术学院 毕业论文 学生宿舍管理系统
Abstract:College students hostel management system is typical of the Information Management System (MIS), including development of its key database background to the establishment and maintenance of front-end procedures and the development of the two areas. Background database for the establishment and maintenance requirements to establish data consistency and integrity of strong data security for good. For front-end application development requires application procedures can provide powerful data manipulation functions, friendly interface, the use of simple and convenient features.
We use PHP and MYSQL database development tools, PHP is a powerful database processing functions, and MYSQL is recognized as the most perfect combination. Meanwhile it is also using the world's most popular is also very practical framework and PHP template engine based on the actual design of the most appropriate development of the project designed to improve the efficiency of programming and reliability.
The old manual records management hostels can no longer accommodate the rapid growth of the information age. The new hostel management system developed after the existing school hostel information management will be greatly improved, from the artificial changes to the computer by way of low efficiency, data redundancy, prone to errors into rapid retrieval, Search convenient, high reliability and large memory capacity. These advantages can greatly improve efficiency, as well as schools scientific, standardized management of important conditions.
Key words：Students' dormitory；Management information system； PHP； MYSQL
西安航空职业技术学院 毕业论文 学生宿舍管理系统
目 录
引 言 ........................................................................................................................................................ 1 1 相关知识点介绍 ................................................................................................................................ 2 1.1 PHP知识介绍 ............................................................................................................................... 2 1.2 MYSQL知识介绍............................................................................................................................ 3 1.3 PHPNOW的安装和配置 .................................................................................................................. 4 1.4进入DOS环境下MYSQL数据库的方法以及部分操作 ................................................................ 6 2 系统需求分析 .................................................................................................................................... 8 2.1 功能需求 ...................................................................................................................................... 8
2.1.1基本功能需求 ....................................................................................................................... 8 2.1.2报表需求 ............................................................................................................................... 8 2.1.3用户界面需求 ....................................................................................................................... 8 2.2 性能需求 ...................................................................................................................................... 8 2.2.1系统可行性 ........................................................................................................................... 8 2.2.2系统安全性 ........................................................................................................................... 9 2.3 数据库选择 .................................................................................................................................. 9 2.4 环境 .............................................................................................................................................. 9
3 详细设计 .......................................................................................................................................... 11 3.1 系统功能模块 ............................................................................................................................ 11 3.2 系统前台部分 ............................................................................................................................ 11 3.2.1系统管理模块 ....................................................................................................................... 12 3.2.2信息查询模块 ....................................................................................................................... 12 3.2.3出入登记模块 ....................................................................................................................... 12 3.3 系统后台部分 ............................................................................................................................ 12 3.3.1公寓管理模块 ....................................................................................................................... 12 3.3.2学生管理模块 ....................................................................................................................... 13 3.3.3信息修改模块 ....................................................................................................................... 13 3.3.4报表管理模块 ....................................................................................................................... 13 3.4系统E-R图 ................................................................................................................................. 13 3.5 数据库结构设计 ........................................................................................................................ 14 3.5.1数据字典 ............................................................................................................................... 14 3.5.2数据表 ................................................................................................................................... 15 3.5.3表的说明 ............................................................................................................................... 19 4 模块的具体实现与代码 .................................................................................................................. 20 4.1 登录模块 .................................................................................................................................... 20 4.2前台主界面模块 ......................................................................................................................... 24 4.3后台主界面代码 ......................................................................................................................... 29 5系统测试和维护 ................................................................................................................................. 34 5.1系统测试 ..................................................................................................................................... 34
西安航空职业技术学院 毕业论文 学生宿舍管理系统
5.2系统维护 ..................................................................................................................................... 36 结 束 语 ................................................................................................................................................ 37 谢 辞 ...................................................................................................................................................... 38 参考文献 ................................................................................................................................................ 39