毕 业 设 计（论 文）
视频点播系统设计与实现
I
摘 要
传统办法管理信息首先需要花费的时间比较多，其次数据出错率比较高，而
且对错误的数据进行更改也比较困难，最后，检索数据费事费力。因此，在计算
机上安装视频点播系统软件来发挥其高效地信息处理的作用，可以规范信息管理
流程，让管理工作可以系统化和程序化，同时，视频点播系统的有效运用可以帮
助管理人员准确快速地处理信息。
视频点播系统在对开发工具的选择上也很慎重，为了便于开发实现，选择的
开发工具为 Eclipse，选择的数据库工具为 Mysql。以此搭建开发环境实现视频点
播系统的功能。其中管理员管理用户，新闻公告。
视频点播系统是一款运用软件开发技术设计实现的应用系统，在信息处理上
可以达到快速的目的，不管是针对数据添加，数据维护和统计，以及数据查询等
处理要求，视频点播系统都可以轻松应对。
关键词：视频点播系统；SpringBoot 框架，系统分析，数据库设计
II
Abstract
The traditional method of managing public transportation information first takes
more time, and secondly, the data error rate is relatively high, and it is more difficult
to modify the wrong data, and finally, it is laborious and laborious to retrieve the data.
Therefore, installing the public transportation query website software on the computer
to play its role in efficient information processing can standardize the public
transportation information management process, so that the management work can be
systematized and programmed. At the same time, the effective use of the public
transportation query website can help managers accurately Process information
quickly.
The public transportation query website is also very cautious in the selection of
development tools. In order to facilitate the development and realization, the selected
development tool is Eclipse, and the selected database tool is Mysql. In this way, the
development environment is built to realize the functions of the public transport query
website. Among them, the administrator manages users, drivers, news announcements,
manages vehicles, stations, and trip information in the route management module, and
responds to users' suggested messages in the message suggestion management module.
Users inquire about the site, inquire about transfer information, post message
suggestions, and check news announcements.
The bus query website is an application system designed and implemented using
software development technology. It can achieve rapid information processing.
Whether it is for data addition, data maintenance and statistics, and data query
processing requirements, the bus query website can easily response.
Key Words：Public transport query website; bus number information; suggestion to
leave a message; query site
III
目 录
目 录 ..........................................................................................................................III
第 1 章 绪论 ..................................................................................................................1
1.1 选题动因 ..........................................................................................................1
1.2 目的和意义 ......................................................................................................1
1.3 论文结构安排 ..................................................................................................2
第 2 章 开发环境与技术 ..............................................................................................3
2.1 MYSQL 数据库................................................................................................3
2.2 JAVA 语言技术 .................................................................................................3
2.3 SPRINGBOOT 框架.............................................................................................4
2.4 B/S 模式框架 ...................................................................................................4
第 3 章 系统分析 ..........................................................................................................5
3.1 系统可行性分析 .............................................................................................5
3.1.1 技术可行性分析 ...................................................................................5
3.1.2 经济可行性分析 ...................................................................................5
3.1.3 运行可行性分析 ...................................................................................5
3.2 系统流程 .........................................................................................................5
3.2.1 操作信息流程 ......................................................................................5
3.2.2 登录信息流程 ......................................................................................6
3.2.3 删除信息流程 ......................................................................................6
3.3 性能需求分析 .................................................................................................7
第 4 章 系统设计 ..........................................................................................................8
4.1 界面设计原则 ..................................................................................................8
4.2 功能结构设计 ..................................................................................................9
4.3 数据库设计 ......................................................................................................9
4.3.2 数据库物理设计 ................................................................................12
第 5 章 系统实现 ........................................................................................................15
IV
5.1 用户信息管理 ........................................................................................15
5.2 视频信息管理 .......................................................................................16
5.3 论坛信息管理 ........................................................................................17
5.1 公告信息管理 ........................................................................................17
第 6 章 系统测试 ........................................................................................................19
6.1 软件测试 ...............................................................................................19
6.2 测试环境 ...............................................................................................19
6.3 测试测试用例 .......................................................................................19
6.4 测试结果 ...............................................................................................20
结 论 ..........................................................................................................................21
参考文献 ......................................................................................................................23
致 谢 ..........................................................................................................................24
