摘要

《实验室预约管理系统》是采用JavaWeb开发的一个开放实验室预约系统。本系统是针对目前实验室手工管理效率低下，缺乏安全性、可控性等缺点，以校园网为依托，采用科学、高效的教学管理方式，使学校的教学资源得到充分的利用。本系统主要实现了教师根据实际教学情况预约实验室、查看预约结果，学生查询实验室教学安排，实验室管理员对实验室的管理、用户信息的管理和系统消息发布等功能，同时系统提供了简单友好的用户界面，并通过身份验证机制实现了系统的安全性。考虑到可能出现的教师同时预约实验室的情况，本系统采用了预约时避免冲突、受理时解决冲突的方法，尽最大努力实现实验室资源的优化配置。系统具有网络化、界面友好、操作简单、功能强大、管理方便等优点，能够完全按照用户的需要，稳定、安全快速地运行于校园局域网之上。该系统操作简单、界面良好、具有很好的使用价值。

关键词：实验室；预约和查询；信息管理

Abstract

The lab reservation management system was developed by using JavaWeb an open laboratory reservation system. This system is based on the current lab manual management inefficiency, lack of security, controllability and other defects, which is based on campus network, USES the scientific and efficient way of teaching management, so the school teaching resources can be fully utilized. This system mainly realizes the teacher appointment laboratory according to the actual teaching situation, to check the booking as a result, the students query laboratory teaching arrangement, the lab manager for laboratory management, user information management and system function such as news, at the same time, the system provides a simple and friendly user interface, and through the identity authentication mechanism to realize the security of the system. Considering the possible teacher appointment laboratory at the same time, this system is adopted to make an appointment to avoid conflict, at the time of acceptance method to solve conflicts, try your best to achieve the optimal allocation of lab resources. System has the network, friendly interface, simple operation, powerful function, convenient management, and can completely according to user needs, quickly run stably and safely on campus local area network (LAN). Operation is simple, the interface of the system is good, has the very good use value.

Keywords: Laboratory; Make an appointment and query; Information management

目录

1．引言 ........................................................................................................................................... 5 1.1研究背景及意义 ................................................................................................................... 5 1.2国内外发展现状 ................................................................................................................... 5 1.3开发环境 ............................................................................................................................. 5 2系统开发和环境介绍 .................................................................................................................. 7 2.1基本环境 ............................................................................................................................. 7 2.2设计模式选定 ....................................................................................................................... 7 2.3数据库介绍 ........................................................................................................................... 7 2.4安装TOMCAT ...................................................................................................................... 8 2.5 JSP简介 ............................................................................................................................. 8 3．需求分析 ................................................................................................................................. 10 3.1开发背景 ........................................................................................................................... 10 3.2开发目的 ........................................................................................................................... 10 3.3需要实现的功能及功能模块 ............................................................................................. 10 3.3.1 用户注册 .......................................................................................................................... 10 3.3.2主要的设计理念 .............................................................................................................. 10 3.3.3用户登录 ....................................................................................................................... 11 3.4模块功能需求分析 ............................................................................................................. 11 3.4.1 功能描述 ...................................................................................................................... 11 3.4.2系统功能图 ................................................................................................................... 11 3.4.3 流程分析 ...................................................................................................................... 12 3.4.4系统流程图（图3-2） ................................................................................................. 12 4．设计与实现 ............................................................................................................................. 14 4.1模块功能界面 ..................................................................................................................... 14 4.1.1 登录界面 ...................................................................................................................... 14 4.1.2 普通学生用户界面 ...................................................................................................... 15 4.1.3 预约空闲实验资源 ...................................................................................................... 15 4.1.4 管理员界面 .................................................................................................................. 18 5．系统设计与实现 ..................................................................................................................... 21 5.1 部分功能界面代码 ......................................................................................................... 21 5.1.1 数据库建表 .................................................................................................................. 21 5.1.2 用户注册 ...................................................................................................................... 21 5.1.3 权限判断 ...................................................................................................................... 23 5.1.4 预约功能 ...................................................................................................................... 23 5.1.5 删除预约信息 .................................................................................................................. 24 5.1.6 管理员修改实验资源信息 .......................................................................................... 25 6.总结 ............................................................................................................................................ 26 参考文献 ....................................................................................................................................... 27