毕 业 设 计（论 文）
题目：智慧城市实验室主页系统的设计与实现
I
摘 要
互联网发展至今，无论是其理论还是技术都已经成熟，而且它广泛参与在社
会中的方方面面。它让信息都可以通过网络传播，搭配信息管理工具可以很好地
为人们提供服务。针对实验室信息管理混乱，出错率高，信息安全性差，劳动强
度大，费时费力等问题，采用智慧城市实验室主页系统可以有效管理，使信息管
理能够更加科学和规范。
智慧城市实验室主页系统在 Eclipse 环境中，使用 Java 语言进行编码，使用
Mysql 创建数据表保存本系统产生的数据。系统可以提供信息显示和相应服务，
本系统管理员管理电子期刊，国际会议，学术团队以及实验动态，管理奖项和活
动以及设备信息。教师管理科研报告，管理科研成果，下载国际会议资源，参与
学术交流。学生下载科研成果，会议资源，电子期刊文件，查看学术交流里面的
帖子并发布评论，查看学术团队，实验动态等信息。
总之，智慧城市实验室主页系统集中管理信息，有着保密性强，效率高，存
储空间大，成本低等诸多优点。它可以降低信息管理成本，实现信息管理计算机
化。
关键词：智慧城市实验室主页系统；Java 语言；Mysql
II
Abstract
Since the development of the Internet, both its theory and technology have
matured, and it has been widely involved in all aspects of society. It allows
information to be disseminated through the Internet, and it can serve people well with
information management tools. In view of the chaotic laboratory information
management, high error rate, poor information security, high labor intensity, and
time-consuming and laborious problems, the smart city laboratory homepage system
can be used for effective management, making information management more
scientific and standardized.
The smart city laboratory homepage system is coded in Java language in the
Eclipse environment, and MySQL is used to create a data table to save the data
generated by the system. The system can provide information display and
corresponding services. The system administrator manages electronic journals,
international conferences, academic teams and experimental dynamics, manages
awards and activities, and equipment information. Teachers manage scientific
research reports, manage scientific research results, download international
conference resources, and participate in academic exchanges. Students download
scientific research results, conference resources, electronic journal files, view posts in
academic exchanges and post comments, view academic teams, experimental
dynamics and other information.
In short, the smart city laboratory homepage system centralized management
information, has many advantages such as strong confidentiality, high efficiency,
large storage space, and low cost. It can reduce the cost of information management
and realize the computerization of information management.
Key Words：Smart City Laboratory Homepage System; Java Language; Mysql
III
目 录
第 1 章 绪论...........................................1
1.1 课题背景 .........................................................................................................1
1.2 课题意义 .........................................................................................................1
1.3 研究内容 .........................................................................................................2
第 2 章 开发环境与技术.................................3
2.1 MYSQL 数据库 ...............................................................................................3
2.2 JSP 技术 ...........................................................................................................3
2.3 SSM 框架 .........................................................................................................4
第 3 章 系统分析.......................................5
3.1 可行性分析 .....................................................................................................5
3.1.1 技术可行性 ..........................................................................................5
3.1.2 经济可行性 ..........................................................................................5
3.1.3 操作可行性 ..........................................................................................5
3.2 系统流程 .........................................................................................................6
3.2.1 操作流程 ..............................................................................................6
3.2.2 登录流程 ..............................................................................................6
3.2.3 删除信息流程 ......................................................................................7
3.2.4 添加信息流程 ......................................................................................8
3.3 性能需求 .........................................................................................................8
3.4 功能需求 .........................................................................................................9
第 4 章 系统设计......................................12
4.1 设计原则 .......................................................................................................12
4.2 功能结构设计 ...............................................................................................12
4.3 数据库设计 ...................................................................................................14
4.3.1 数据库概念设计 ................................................................................14
IV
4.3.2 数据库物理设计 ................................................................................17
第 5 章 系统实现......................................22
5.1 管理员功能实现 ...........................................................................................22
5.1.1 教师管理 ............................................................................................22
5.1.2 学生管理 ............................................................................................22
5.1.3 设备信息管理 ....................................................................................23
5.1.4 奖项信息管理 ....................................................................................23
5.1.5 国际会议管理 ....................................................................................24
5.1.6 电子期刊管理 ....................................................................................24
5.2 教师功能实现 ...............................................................................................25
5.2.1 科研报告管理 ....................................................................................25
5.2.2 科研成果管理 ....................................................................................25
5.3 学生功能实现 ...............................................................................................26
5.3.1 电子期刊 ............................................................................................26
5.3.2 国际会议 ............................................................................................26
5.3.3 科研成果 ............................................................................................27
5.3.4 学术交流 ............................................................................................27
第 6 章 系统测试......................................29
6.1 功能测试 .......................................................................................................29
6.1.1 登录功能测试 ....................................................................................29
6.1.2 修改密码功能测试 ............................................................................30
6.2 测试结果 .......................................................................................................30
结 论...............................................31
致 谢...............................................32
参考文献.............................................33
