在线点歌系统的设计与实现【毕业论文】.doc

本科毕业论文 （20 届） 在线点歌系统的设计与实现 专业：计算机科学与技术 摘 要 随着计算机以及网络技术的发展，网友们对网络的要求也日益长高，平常在网上听歌需要用一大堆下载软件，下载下来也要管理，同时又占空间。本系统的设计，旨在改变这一状况。它本身就是一个的音乐网站，用户通过主界面就能查看歌曲，并能在线点播，并可以将自己喜爱的歌曲加入收藏，相当方便。 本系统主要有JSP与SQL Server 2000来开发，主要包括用户登陆，歌曲列表，歌手列表，歌曲查询等功能。此外，本论文详细介绍系统开发所用的主要技术，还介绍了本软件的系统结构，系统各个功能模块的详细设计。最后对该在线点歌系统做了总结，指出了系统的采用技术和经验，且分析并解决实现中的若干技术问题。本系统界面简洁，操作简单，可实用性强，适合广大人群使用。 【关键词】SQL Server 2000，JSP，在线点歌系统，JDBC Design and Implementation of Online Music Demand System Abstract With the development of computer and network technology, users are demanding the network more taller day by day, they need a lot of download tools to listen songs on the Internet usually, download them and have managed them, and the songs account the space at the same time. The system is being designed to change this situation.It is a music site, users can look over the songs through the main interface, and can demand the songs online, and also can add to their favorite songs in the bookmark, it is very convenient. The system uses JSP and SQL Server 2000 to develop, including the login of user, the list of songs, the list of artists, inquiring the songs and so on. In addition, the paper introduces the main technology to develop of the system, and also introduces the system strucyure and the detailed design of each module in the system. Finally, do the summary of the system, point out that the system of technology and experience, analyze and solve some technical problems in implementation, the interface of system is simple and easy to operate,it is very appropriate to use in implementation, it suits the majority of people to use. 【Keywords】 SQL Server 2000, JSP, nline music demand System, JDBC 目录 摘 要 I Abstract II 1前言 1 2开发工具及环境简介 3 2.1 JSP简介与技术 3 2.2.1 JSP技术 3 2.2.2 ASP 、PHP、 JSP之间的比较 5 2.2 JSP运行环境 6 2.3 Eclipse简介 7 2.4 SQL技术的介绍 8 2.5 浏览器/服务器模型 9 2.6 JDBC技术 9 3需求分析与可行性研究 10 3.1 用户需求分析 10 3.2 可行性研究 10 4总体设计 12 4.1系统功能模块介绍 12 4.2数据库需求分析 13 4.2.1 数据库设计与分析 13 4.2.2 E-R图设计 13 4.2.3 数据库逻辑设计 14 5系统详细设计 15 5.1系统