毕 业 设 计（论 文）
音乐播放器设计与实现
I
摘 要
当下，如果还依然使用纸质文档来记录并且管理相关信息，可能会出现很多
问题，比如原始文件的丢失，因为采用纸质文档，很容易受潮或者怕火，不容易
备份，需要花费大量的人员和资金来管理用纸质文档存储的信息，最重要的是数
据出现问题寻找起来很麻烦，并且修改也困难，如果还这样操作会造成很大的资
源浪费和经济损失。所以，对于本课题研究的音乐信息的管理就需要有一款软件
来代替手工操作，因此音乐播放器就应运而生。
音乐播放器运用的工具包括 Eclipse，Tomcat 以及 Navicat 等。该系统可以实
现音乐信息管理，论坛信息管理，公告信息管理，音乐留言管理，音乐收藏管理，
用户管理等功能。
音乐播放器就是采用目前最流行的互联网应用思维，让信息处理变得更加高
效，并且处理结果更加的符合预期，只要是关于数据管理方面，不管是添加还是
修改，以及数据维护甚至是数据迁移，都可以达到更快更安全的要求。
关键词：音乐播放器；音乐信息；音乐留言；音乐收藏
II
Abstract
At present, if paper documents are still used to record and manage related
information, there may be many problems, such as the loss of original documents,
because paper documents are easily damped or afraid of fire, not easy to back up, and
require a lot of personnel. and funds to manage the information stored in paper
documents, the most important thing is that it is very troublesome to find data
problems, and it is also difficult to modify, if you continue to do this, it will cause
great waste of resources and economic losses. Therefore, for the management of
music information studied in this subject, there is a need for a software to replace
manual operation, so the music player came into being.
The tools used by the music player include Eclipse, Tomcat, and Navicat. The
system can realize music information management, forum information management,
announcement information management, music message management, music
collection management, user management and other functions.
The music player adopts the most popular Internet application thinking to make
information processing more efficient, and the processing results are more in line with
expectations. As long as it is about data management, whether it is adding or
modifying, and data maintenance or even data migration, All can achieve faster and
safer requirements.
Key Words：music player; music information; music message; music collection
III
目 录
第 1 章 绪论 ..................................................................................................................1
1.1 选题动因 .........................................................................................................1
1.2 目的和意义 .....................................................................................................1
1.3 论文结构安排 .................................................................................................2
第 2 章 开发环境与技术 ..............................................................................................3
2.1 TOMCAT 简介...................................................................................................3
2.2 ECLIPSE 简介 ....................................................................................................3
2.3 NAVICAT 简介...................................................................................................4
第 3 章 系统分析 ..........................................................................................................5
3.1 可行性分析 .....................................................................................................5
3.1.1 经济可行性 ..........................................................................................5
3.1.2 技术可行性 ..........................................................................................5
3.1.3 操作可行性 ..........................................................................................5
3.2 系统流程分析 .................................................................................................6
3.3 系统性能分析 .................................................................................................7
3.4 系统功能分析 .................................................................................................8
第 4 章 系统设计 ........................................................................................................11
4.1 布局设计原则 ...............................................................................................11
4.2 功能结构设计 ...............................................................................................12
4.3 数据库设计 ...................................................................................................13
4.3.1 数据库 E-R 图设计............................................................................13
4.3.2 数据库表结构设计 ............................................................................16
第 5 章 系统实现 ........................................................................................................20
5.1 管理员功能实现 ...........................................................................................20
5.1.1 论坛管理 ............................................................................................20
5.1.2 音乐信息管理 ....................................................................................20
IV
5.1.3 音乐留言管理 ....................................................................................21
5.1.4 用户管理 ............................................................................................21
5.1.5 公告信息管理 ....................................................................................22
5.2 用户功能实现 ...............................................................................................22
5.2.1 公告信息 ............................................................................................22
5.2.2 在线论坛 ............................................................................................23
5.2.3 音乐信息 ............................................................................................23
第 6 章 系统测试 ........................................................................................................25
6.1 系统测试方法 ...............................................................................................25
6.2 功能测试 .......................................................................................................25
6.2.1 登录功能测试 ....................................................................................25
6.2.2 音乐查询功能测试 ............................................................................26
6.3 测试结果分析 ...............................................................................................26
结 论 ..........................................................................................................................27
参考文献 ......................................................................................................................28
致 谢 ..........................................................................................................................29
