1摘要随着网络技术的发展,人们在利用网络学习的同时,也在享受着网络带来的各种附带产品所产生的效应,如网络游戏,网络歌曲。音乐网站正是在这样的需求前提下应运而生,给人们的日常生活带来了极大的乐趣,让人们在繁忙疲惫的工作之后可以进行休闲。本论文介绍了音乐网站的分析、设计和开发的全部过程。系统从两种用户(管理员、用户)出发进行设计,以管理员身份登录时有“歌曲管理、专辑管理、歌手管理、会员信息管理、订单管理”等功能模块;以考生身份登录时有“下载歌曲、购买专辑、发送评论”等达到音乐网站功能实现的目的。本网站采用JSP技术,SQLServer2000数据库管理系统,Tomcat6.0服务器,Eclipse集成开发环境进行开发。音乐网站的管理者和用户可以通过该网站发布、管理、欣赏歌曲,优化了音乐的管理流程。关键字:SQLServer2000JSPTomcat音乐数据库2ABSTRACTWiththedevelopmentoftheinternet,peoplemakeuseofthewebonallkindfieldsmoreandmore.Atthesametime,theycanenjoythedelightofthemusicthatisonline,suchasnetworkgameandnetworksong.Atthissituation,musicwebcomeintobeing,itgivespeoplefun,andpeoplecouldrelaxthemselvesdeeplybylisteningmusic.Thisstudypresentsmusicweb’swholeprocessofanalysis,designandexploitation.Thissystemisdesignedfromtwousers(administratorsandusers).Whenloggingonasthefigureofadministrators,manyfunctionmoduleswillappearincludingmusicmanagement,specialmanagement,singermanagement,consumermanagement,ordermanagementetc.Whenloggingonasthefigureofuser,manyfunctionmoduleswillappearincludingdownloadmusic,buyspecial,sendoutmessageetc.ThiswebisdevelopedwithJSPtechnology,SQLServer2000DBMS,Tomcat6.0ServerandEclipseintegrateddevelopmentenvironment.Themusicweb’sadministratorsanduserscanpublish,manageandappreciatemusicthroughituniformly,optimizemusic’smanagement.KEYWORDS:SQLServer2000JSPTomcatMusicDatabase0目录第一章音乐网站的概述...................................................................................11.1课题的来源及意义.....................................................................................11.2开发工具及相关技术简介.........................................................................21.2.1开发工具..............................................................................................21.2.2相关技术简介......................................................................................2第二章音乐网站的需求分析...........................................................................42.1可行性研究.................................................................................................42.2需求分析.....................................................................................................42.2.1系统概述..............................................................................................52.2.2系统运行环境......................................................................................52.2.3功能需求描述......................................................................................52.2.4系统用例图..........................................................................................7第三章音乐网站的总体设计...........................................................................93.1开发与设计的总体思想.............................................................................93.2系统模块结构图.........................................................................................93.3模块设计...................................................................................................103.3.1歌手管理模块....................................................................................103.3.2专辑管理模块....................................................................................103.3.3歌曲管理模块....................................................................................103.3.5会员管理模块....................................................................................113.3.6用户登录模块....................................................................................113.5系统主要界面设计...................................................................................123.6数据库设计...............................................................................................133.6.1概念结构设计....................................................................................133.6.2逻辑结构设计......................................................................................163.6.3数据库表的设计..................................................................................16第四章音乐网站的详细设计...........................................................................204.1前台用户页面的详细设计.......................................................................204.1.1用户注册模块....................................................................................204.1.2用户下载模块....................................................................................2014.1.3购物模块............................................................................................204.1.4投票模块............................................................................................204.1.5评论模块............................................................................................214.2后台管理员页面的详细设计...................................................................214.2.1歌手管理模块....................................................................................214.2.2专辑管理模块....................................................................................214.2.3歌曲管理模块....................................................................................214.2.4会员管理模块................................