毕 业 设 计（论 文）
题目：光影视频平台
I
摘 要
使用旧方法对光影视频平台的信息进行系统化管理已经不再让人们信赖了，
把现在的网络信息技术运用在光影视频平台的管理上面可以解决许多信息管理
上面的难题，比如处理数据时间很长，数据存在错误不能及时纠正等问题。这次
开发的光影视频平台对字典管理、NBA 管理、NBA 收藏管理、NBA 留言管理、
新闻信息管理、papi 酱视频管理、papi 酱视频收藏管理、papi 酱视频留言管理、
体育管理、体育收藏管理、体育留言管理、艺术管理、艺术收藏管理、艺术留言
管理、用户管理、娱乐管理、娱乐收藏管理、娱乐留言管理、管理员表管理等进
行集中化处理。经过前面自己查阅的网络知识，加上自己在学校课堂上学习的知
识，决定开发系统选择 B/S 模式这种高效率的模式完成系统功能开发。这种模式
让操作员基于浏览器的方式进行网站访问，采用的主流的 Java 语言这种面向对
象的语言进行光影视频平台程序的开发，在数据库的选择上面，选择功能强大的
Mysql 数据库进行数据的存放操作。光影视频平台的开发让用户查看 NBA 视频
信息变得容易，让管理员高效管理 NBA 视频信息。
关键词：光影视频平台；NBA 视频信息；新闻；自助资讯
II
Abstract
Using the old method to systematically manage the tourist attraction information
no longer makes people trust. Applying the current network information technology to
the management of tourist attraction information can solve many problems in
information management, such as processing data for a long time, data There are
problems such as errors that cannot be corrected in time. The self-guided website
developed this time centralizes the city information of attractions, tourist attractions
information, comment information, and self-help information. After learning the
network knowledge I had previously consulted and the knowledge I learned in the
school classroom, I decided to develop the system to select the B/S mode, an efficient
mode to complete system function development. This mode allows the operator to
access the website based on the browser. The mainstream Java language is used in the
object-oriented language to develop the self-guided website program. In the database
selection, select the powerful Mysql database for data. Store operation. The
development of self-guided websites makes it easy for users to view information on
attractions, allowing administrators to efficiently manage information on attractions.
Key Words ： Self-guided tour website; tourist attractions; reviews; self-help
information
III
目 录
1 绪论 ...............................................1
1.1 研究背景 .........................................................................................................1
1.2 目的和意义 ......................................................................................................1
1.3 论文结构安排 .................................................................................................2
2 相关技术............................................3
2.1 B/S 架构介绍 ...................................................................................................3
2.2 MYSQL 数据库介绍..........................................................................................3
2.3 JAVA 语言介绍 ...............................................................................................5
3 系统分析............................................7
3.1 系统可行性分析 ..............................................................................................7
3.1.1 技术可行性分析 ..................................................................................7
3.1.2 经济可行性分析 ..................................................................................7
3.1.3 运行可行性分析 ..................................................................................7
3.2 系统性能分析 ..................................................................................................8
3.2.1 系统安全性 ..........................................................................................8
3.2.2 数据完整性 ..........................................................................................8
3.2.3 系统可扩展性 .......................................................................................9
3.3 系统流程分析 ..................................................................................................9
3.3.1 系统登录流程 .....................................................................................10
3.3.2 信息添加流程 .....................................................................................11
3.3.3 信息删除流程 .....................................................................................11
3.4 系统功能分析 ................................................................................................12
4 系统设计...........................................13
4.1 系统概要设计 ................................................................................................13
4.2 系统功能结构设计 ........................................................................................13
IV
4.3 数据库设计 ....................................................................................................13
4.3.1 数据库 E-R 图设计.............................................................................13
4.3.2 数据库表结构设计 ............................................................................14
5 系统实现...........................................15
5.1 管理员功能介绍 ............................................................................................15
5.1.1 管理员登录 .........................................................................................15
5.1.2 NBA 视频管理....................................................................................15
5.1.3 新闻信息管理 ....................................................................................16
5.1.4 新闻类型管理 .....................................................................................16
6 系统测试 ...........................................18
6.1 本系统测试 .................................................................................................18
6.1.1 登录功能测试 ....................................................................................18
6.1.2 注册功能测试 ....................................................................................19
6.2 测试结果分析 ................................................................................................19
结 论...............................................20
参考文献.............................................22
致 谢...............................................23
