基于SQLServer和JSP学生实验室系统.docVIP

摘 要 随着高等教育改革的不断深化，教学规模不断扩大，高校用于实验教学的实验设备也不断增多。怎样对这些实验设备进行规范化、科学化、信息化管理已成为一个重要课题。而且面对现在高校实验室工作频繁，工作量大等困难的凸显，传统实验室的模式正进入信息化的变革时代而数字网络信息技术，尤其是Internet技术的成熟与发展，使得高校实验室管理信息化已成为一种趋势。 本系统基于JSP开发技术，采用B/S设计模式来实现实验室的管理。其中，前台页面为Dreamweaver8.0制作的静态网页，后台页面为My Eclipse制作的动态网页。数据库使用SQL Server 2005。整个系统采用MVC模式开发完成。 本系统主要有三个使用者包括管理员，教师和学生。管理员可以实现更新最新公告，修改信息，增删改查课表，增删改仪器设备，管理学生和教师信息，查看教师预约信息，管理站内信息。教师可以实现查看最新公告，修改信息，查看自己的课表，查看学生信息，进行课程的预约，发布站内信息。学生可以实现查看最新公告，修改信息，查看自己的课表，发布站内信息。通过本系统，可以提高实验室管理的工作效率。 关键词：实验室管理系统 JSP SQL SERVER数据库 Abstract With the deepening reform of higher education, the teaching scale expands inceasingly.And the number of laboratory equipment is also increasing in high school. It has become an important subject that how to manage the experiment equipment standardization, scientific, information. And facing university lab work frequently, as well as a large amount of difficult work, pattern of traditional laboratory is coming to the change of information era, information technology and digital network, especially the maturity and development of Internet technology that makes the university laboratory management informatization has become a trend. The system based on the JSP, used the B/S design pattern to achieve the laboratory management. Among them, the front pages are designed by Dreamweaver8.0, the background pages are designed by MyEclipse. The Database used the SQL SERVER 2005.The whole system adopted MVC model development. The system consists of three actors, including the administrator, the teacher and the student. The administrator can update the latest announcement, modify the information, add, delete, modify, search all schedules, add, delete, modify equipment information, manage students and teachers information, view the teachers appointment information and manage site information.The teacher can view the latest announcement, modify the information, check their own schedules, view students information, reserve the course and check site information