XXXX 学院
（论文）
基于 JSP 的音乐网站管理系统
学 院:
专 业:
班 级:
学 号:
乘客姓名:
指导管理员:
2011 年 4 月
- 1 -
摘 要
随着 Internet 技术的发展，人们的日常生活、学习已经离不开网络。未来社会人
们的生活和工作将越来越依赖于数字技术的发展，越来越数字化、网络化、电子化、虚
拟化。Internet 的发展历程以及目前的应用状况和发展趋势，可以充分地相信网络技术
将极大的改变我们的生活和工作方式，甚至社会的价值观也会发生某种变化。
本设计尝试用 JSP 在网络上架构一个网上音乐网站管理系统，以推进音乐网站信息
管理无纸化，过程电子化，管理智能化的发展。本文从理论和实践两个角度出发，对一
个具有数据分析功能的音乐网站管理系统进行设计与实现分析。论文首先较为详尽地介
绍了面向对象分析与设计的有关概念与技术，特别深入介绍了在本系统中运用到的知识，
如：面向对象的分析设计流程；系统中所用到的开发技术 JSP 以及 ADO.NET 的特点、结
构框架以及使用方法。接着对音乐网站管理系统的可行性进行了分析，然后对系统的设
计思想、设计目标与系统的整体结构进行了明确的规划。最后对系统的主要页面、数据
库、应用程序的设计与实现作了较为详细的讲解。
本音乐网站管理系统是在 MyEclipse 平台上运用 JSP 技术来实现的。其主要功能有：
站内新闻，音乐在线，MTV 欣赏，用户注册，留言板等。论文在撰写过程中，力求将理
论与实践应用相结合，对各种理论进行阐述的同时配合系统从实际应用和操作技巧上加
以说明，希望能够更充分地体现到这些知识与技术在本系统中的应用与实现。
【关键词】面向对象分析与设计，JSP，ADO.NET
- 2 -
Abstract
Along with the development of Internet technology, daily life can not already
do without the network. The life and work of the social people of future will
depend on the development of digital technology more and more ,Digitize more
and more, the networking, electronic, virtual. Development course and present
application state and development trend of Internet, can believe network
technology great change life and working way of us fully, Even a certain change
will take place in the values of the society.
This procedure tries to build up a bookshop in the network with JSP, So that
every customer needn't go out and can do shopping easily through surfing the
Net at home .this article is analyzing the design and realization of an online
bookshop with Data Mining function, from the views of theory and practice.
Starting with introducing concepts and techniques of OOA and OOP in detail,
especially introducing the knowledge which apply for this system, such as: the
feature and flow of OOA and OOP; analyzing the feature、structure and using method
of developing techniques JSP and ADO.NET which using in my system. And then,
this article analyses the feasibility of the system, then minutely layouts the
design thoughts, goals and the system holistic framework. At last, this article
minutely explains the design and realization of Web page layout, data base and
application program of our system.
This online bookstore system uses JSP technology to realize on MyEclipse
platform. Its main function has: manage users, new books on sale, look for
classified books, search books, collect favorite book, process of purchase,
sales list, the comment of the books, website's management, etc.
During the course of writing this article, I strive to integrate theory and
practice. While expatiating the different kind of theories, I illuminate the
application and operation skill combining the system so as to fully incarnate
the application of these theories and techniques to this system.
[KEYWORD]：OOA,OOD,JSP,ADO.NET
英文请自行校对，
- 1 -
目 录
XXXX 学院......................................................................................................................................................0
（论文） ..........................................................................................................................................................0
基于 JSP 的音乐网站管理系统 ......................................................................................................................0
一、前言 ..........................................................................................................................................................1
1．课题研究的意义；国内外研究现状和发展趋势 ............................................................................1
1.1 意义 ...........................................................................................................................................1
1.2 国内外研究现状 ................................................................................................................................1
1.3 发展趋势 ............................................................................................................................................1
2．课题的研究目标、内容和拟解决的关键问题 ................................................................................2
2.1 课题的研究目标 ................................................................................................................................2
3．设计方案的确定 ................................................................................................................................2
3．1 方案的原理、特点与选择依据 .....................................................................................................2
4 任务概述 ..............................................................................................................................................4
4.1 目标：建立完善的音乐网站管理系统系统 ...........................................................................4
4.2 音乐网站管理系统特点 ...........................................................................................................4
第 2 章 解决方案的选择 ................................................................................................................................5
2.1 系统说明 ..........................................................................................................................................5
2.1.1.硬.软件环境 ........................................................................................................................5
2.2 开发计划 ..........................................................................................................................................6
2.3 可行性分析 .......................................................................................................................................6
2.3.1 风险分析 ..............................................................................................................................6
2.3.2 技术可行性 ..........................................................................................................................6
2.3.3 操作可行性 ..........................................................................................................................7
2.4 设计方案：对涉及工具和技术的相关说明 ..................................................................................7
2.4.1 B/S 体系结构 .......................................................................................................................7
2.4.3 Mysql ....................................................................................................................................8
2.4.4 HTML(Hyper Text Markup Language) ..............................................................................8
2.4.5 JSP ........................................................................................................................................9
第 3 章 需求分析 ..........................................................................................................................................10
3.1 系统分析的任务与步骤 .................................................................................................................10
3.1.1 系统分析的任务 ................................................................................................................10
3.1.2 系统分析的步骤 ................................................................................................................10
3.2 系统项目范围 .................................................................................................................................10
3.4 系统实体分析 .................................................................................................................................11
3.5 系统的数据库设计 .........................................................................................................................11
3.5.1 概念设计 ............................................................................................................................11
第 4 章 总体设计 ........................................................................................................................................15
4.1 系统系统功能说明 ........................................................................................................................15
4.1.1 总体功能 .............................................................................................................................15
4.1.2 非功能性需求 .....................................................................................................................15
4.2 建立数据库模型 ............................................................................................................................16
第 5 章 详细设计 ..........................................................................................................................................20
5. 1 网站首页 .........................................................................................................................................20
5.1 后台系统登录界面 ........................................................................................................................22
5.2 后台主界面 ....................................................................................................................................24
5.3 管理员信息管理界面 .....................................................................................................................25
5.4 音乐类别添加界面 .........................................................................................................................26
5.5 音乐类别查询界面 .........................................................................................................................27
- 2 -
5.6 音乐信息添加界面 .........................................................................................................................28
5.7 音乐信息查询界面 .........................................................................................................................30
第 6 章 系统测试 ............................................................................................................................32
6.1 系统测试的目的 .....................................................................................................................32
6.2 面向对象系统测试方案 .........................................................................................................32
第 7 章 软件布署 ..........................................................................................................................................34
7.1 安装环境要求 .................................................................................................................................34
7.2 系统使用说明 .................................................................................................................................34
总结 ................................................................................................................................................................35
致 谢 ..............................................................................................................................................................36
参考文献 ........................................................................................................................................................37
