毕 业 设 计（论 文）
题目：实验室管理与排课系统设计与实现
摘 要
如今社会上各行各业，都在用属于自己专用的软件来进行工作，互联网发展
到这个时候，人们已经发现离不开了互联网。互联网的发展，离不开一些新的技
术，而新技术的产生往往是为了解决现有问题而产生的。针对于实验室信息与排
课信息管理方面的不规范，容错率低，管理人员处理数据费工费时，采用新开发
的实验室管理与排课系统可以从根源上规范整个数据处理流程的正规性和合法
性。
实验室管理与排课系统能够实现学生出勤管理，实验室管理，设备管理，成
绩管理，实验台管理等功能。该系统采用了 Mysql 数据库，Java 语言，Spring Boot
框架等技术进行编程实现。
实验室管理与排课系统可以提高实验室信息与排课信息管理问题的解决效
率，优化实验室信息与排课信息处理流程，并且能够保证存储数据的安全，它是
一个非常可靠，非常安全的应用程序。
关键词：实验室管理与排课系统；Mysql 数据库；Java 语言
Abstract
Nowadays, all walks of life in society are using their own dedicated software for
work. At this point in the development of the Internet, people have found that they
cannot do without the Internet. The development of the Internet is inseparable from
some new technologies, and the emergence of new technologies is often produced to
solve existing problems. In view of the non-standard management of laboratory
information and course scheduling information, the low fault tolerance rate, and the
time-consuming and labor-intensive processing of data by managers, the newly
developed laboratory management and course scheduling system can standardize the
formality of the entire data processing process from the root. and legality.
The laboratory management and class scheduling system can realize the
functions of student attendance management, laboratory management, equipment
management, achievement management, and laboratory bench management. The
system uses Mysql database, Java language, Spring Boot framework and other
technologies for programming.
The laboratory management and course scheduling system can improve the
efficiency of solving laboratory information and course scheduling information
management problems, optimize the processing flow of laboratory information and
course scheduling information, and ensure the safety of stored data. It is a very
reliable and safe system. application.
Key Words：Laboratory management and course scheduling system; Mysql database;
Java language
目 录
第 1 章 绪论 ..................................................................................................................1
1.1 课题背景 .........................................................................................................1
1.2 课题意义 .........................................................................................................1
1.3 研究内容 .........................................................................................................2
第 2 章 开发环境与技术 ..............................................................................................3
2.1 JAVA 语言 .........................................................................................................3
2.2 MYSQL 数据库 ...............................................................................................3
2.3 IDEA 开发工具................................................................................................4
2.4 SPRING BOOT 框架............................................................................................4
第 3 章 系统分析 ..........................................................................................................5
3.1 可行性分析 .....................................................................................................5
3.1.1 技术可行性 ..........................................................................................5
3.1.2 经济可行性 ..........................................................................................5
3.1.3 操作可行性 ..........................................................................................5
3.2 系统流程 .........................................................................................................5
3.2.1 操作流程 ..............................................................................................6
3.2.2 登录流程 ..............................................................................................6
3.2.3 删除信息流程 ......................................................................................7
3.2.4 添加信息流程 ......................................................................................7
3.3 性能需求 .........................................................................................................8
3.4 功能需求 .........................................................................................................9
第 4 章 系统设计 ........................................................................................................12
4.1 功能结构设计 ...............................................................................................12
4.2 数据库设计 ...................................................................................................14
4.2.1 数据库概念设计 ................................................................................14
4.2.2 数据库物理设计 ................................................................................17
第 5 章 系统实现 ........................................................................................................23
5.1 管理员功能实现 ...........................................................................................23
5.1.1 老师管理 ............................................................................................23
5.1.2 学生管理 ............................................................................................23
5.1.3 实验室排课管理 ................................................................................24
5.1.4 设备借出管理 ....................................................................................24
5.2 老师功能实现 ...............................................................................................25
5.2.1 成绩管理 ............................................................................................25
5.2.2 学生出勤管理 ....................................................................................25
5.2.3 设备损坏管理 ....................................................................................26
5.3 学生功能实现 ...............................................................................................26
5.3.1 实验室排课查看 ................................................................................26
5.3.2 成绩查看 ............................................................................................27
5.3.3 学生出勤管理 ....................................................................................27
第 6 章 系统测试 ........................................................................................................29
6.1 功能测试 .......................................................................................................29
6.1.1 登录功能测试 ....................................................................................29
6.1.2 修改密码功能测试 ............................................................................30
6.2 系统测试结果 ...............................................................................................31
结 论 ..........................................................................................................................32
参考文献 ......................................................................................................................34
致 谢 ..........................................................................................................................35
