摘 要

随着越来越广泛的信息化，越来越广泛的任务由原来的人力被现在的机器取代。在以前，各种各样的账单，账册记录都需要人来手写完成。很多事务都需要人工来完成。在这种情况下，人力资源耗费的很多，而且也容易出现各种各样的问题。从上个世纪计算机发明以来，人们就开始将其用于各种各样的信息管理交给计算机完成，直到今天，绝大部分的机械的重复的对各种记录进行维护的任务，已经是完全交由计算机来完成了。当然，这也是信息化时代所必然会产生的情况。科学技术发展日新月异，计算机技术在当今发展是极快的，新的网络技术层出不穷，传统的实验室管理系统已经不能满足要求，因此设计一个基于WEB的实验室管理系统很有必要。

本论文设计的基于WEB的实验室管理系统，是基于B/S架构的，采用了CSS、Bootstrap，jQuery，ajax等多项前端技术，以及JSP，Servlet等多项后端技术。通过前后端相互协作，可以将整个系统运作起来。学生可以通过该系统上机、下机、预约次日机器等，该系统同时也会将学生的上机时长、上机次数、违约次数等多项数据保存下来。而管理员亦可通过该系统调控整个实验室。此外，该系统对于用户而言，是界面友好的。注册页面上机页面均符合年轻人的审美观。

关键词：B/S架构；JSP技术；jQuery技术；实验室管理系统

Laboratory management system based on Web

ABSTRACT

With more and more extensive informatization, more and more extensive tasks have been replaced by the original manpower by current machines. In ancient times, all sorts of bills and books and records needed to be completed by hand. Many things need to be completed manually. In this situation, human resources are expensive and prone to various problems. Since the invention of computers in the last century, people have begun to use computers for various kinds of information management to complete them. Until today, the vast majority of mechanical tasks for maintaining various records have been completely completed. Handed over to the computer. Of course, this is also an inevitable situation in the information age. With the rapid development of science and technology, the development of computer technology is extremely fast. New technologies emerge one after another. In today's computers, Internet products have the most extensive network structure model.Therefore, it is necessary to design a laboratory management system based on Web.

The system is based on the B/S architecture, using a number of front-end technologies such as CSS, Bootstrap, jQuery, and AJAX, and a number of back-end technologies such as JSP and Servlet. Through the cooperation of the front and back ends, the entire system operates. Students can use the system to get on and off the machine and make appointments for the next day. The system also saves students’ data such as the number of hours on board, the number of visits, and the number of defaults. The administrator can also regulate the entire laboratory through this system. In addition, the system is user-friendly. Registration page on the machine page are in line with the aesthetics of young people.

Key words：B/S architecture；JSP technology；jQuery technology；Laboratory Management System

目 录

第一章 概述………………………………………………………………………1

1 研究背景……………………………………………………………………1

2 研究意义……………………………………………………………………1

3 国内外研究概况……………………………………………………………………2

4 系统设计目标……………………………………………………………………3

第二章 系统需求分析和解决方案…………………………………………………4

1 南林教五楼实验室考察………………………………………………………………4

1.1 教五楼实验室介绍……………………………………………………………4

1.2 实验室上机系统介绍…………………………………………………………………4

1.2.1 系统基本情况………………………………………………………………4

1.2.2 系统优点缺点………………………………………………………………4

2 两处实验室对比………………………………………………………………………5

2.1对比情况…………………………………………………………………5

3 实验室上机产生的问题………………………………………………………6

3.1与学生相关的问题……………………………………………………………6

3.2与管理员相关的问题……………………………………………………………6

4 系统解决方案……………………………………………………………7

4.1针对现存问题的基本解决方案……………………………………………………7

4.2进一步的解决方案……………………………………………………………………7

第三章 系统采用的关键技术分析…………………………………………………8

1 技术分析……………………………………………………………………………8

2 基本设计语言介绍……………………………………………………………………9

2．1 Java编程语言介绍…………………………………………………………………………9

2．2 HTML5介绍…………………………………………………………………………10

2．3 CSS3介绍……………………………………………………………………………………10

2．4 JavaScrpt介绍…………………………………………………………………11

2．5 sql介绍…………………………………………………………………………11

3 高级设计技术介绍……………………………………………………………………11

3．1 JSP技术介绍………………………………………………………………………11

3．2 jQuery技术介绍…………………………………………………………………11

3．3 Ajax技术介绍…………………………………………………………………12

3．4 Bootstrap介绍…………………………………………………………………13

4 设计工具介绍…………………………………………………………………13

4．1 Eclipse介绍…………………………………………………………………13

4．2 Tomcat介绍…………………………………………………………………………14

4．3 Microsoft SQL Server介绍………………………………………………14

第四章 系统设计……………………………………………………15

1 基本设计思想…………………………………………………………15

2 系统功能结构设计…………………………………………………………16

3 数据库设计…………………………………………………………16

3.1 数据库基本设计…………………………………………………………16

3.2 数据库详细信息…………………………………………………………17

4 E-R图设计……………………………………………………………21

5 JAVA类设计…………………………………………………………24

5.1 JAVA类概述…………………………………………………………24

5.2 JAVA类UML图………………………………………………………25

6 JSP设计……………………………………………………………25