KTV电脑点歌系统软件开发 - 图文

毕业设计（论文）

题 目 KTV电脑点歌系统软件开发 专 业 计算机科学与技术 班 级 计094 学 生 指导教师

2013 年

2013届计算机科学与技术专业毕业设计论文

摘 要

随着互联网和宽带上网的普及，Internet音乐网站在中国异军突起，并日益渗透到人们的日常生活中。音乐网站是运用现代通信技术、计算机和网络技术进行的一种社会形态，其目的是通过互联网满足人们对音乐的需求。本课题所研究的音乐网站主要是为个人提供搜索，欣赏和下载的一个平台，从而给个人带来方便。

课题目标是设计并实现一个B/S体系结构的KTV电脑点歌系统。结合实践，理解网页开发技术和数据库的基本知识，学习相关开发工具和应用软件，熟悉网站系统建设的过程，熟练掌握网络数据库编程方法。本系统用JSP语言来编写本系统，数据库用MYSQL来连接系统。本论文主要涉及软件，数据库与网络技术等。系统采用人机交互的方式，界面美观友好，信息查询灵活、方便，数据存储安全可靠。歌星点歌，根据演唱歌星的名字来查询选择歌曲。歌曲名点歌，按照歌曲名称编号进行查询选择歌曲。拼音点歌，根据歌曲名称的拼音名点歌等，系统最大限度地实现了易维护性和易操作性。

关键词：音乐，查询，系统，JSP，系统设计

I

：KTV电脑点歌系统软件开发

ABSTRACT

Along with the Internet and the wide band surfer's popularization, the Internet music website is sudden appearance in China, and seeps day by day to people's daily life. Music website is one kind of form of society which using the Modern Communication Technology, the computer and the networking carries on, its goal is satisfies the people through the Internet to music demand. This topic studies music website is mainly to provide the search personally, the appreciation and a downloading platform, thus for brings conveniently personally.

The topic goal is designs and realizes a B/S architecture music website. The union practice, understood that the homepage development technology and the database elementary knowledge, the study related development kit and the application software, the familiar website construction's process, masters the network database programming method skilled. This system with JSP language compilation society this system, the database uses the MYSQL connected systems. The present paper mainly involves the software, the database and the networking and so on. system is the way human-computer interaction, interface, beautiful and friendly, information inquiry and flexible, convenient, safe and reliable data storage. Singer song, concert singer under the name, to obtain the song. Digital song, according to the song name to select a song number for inquiries. Alphabet song, every song under the song title song, according to the song name to retrieve the songs. System to maximize the ease of maintenance and easy to operate.

KEY WORDS: music，JSP， system ，design

II

2013届计算机科学与技术专业毕业设计论文

目 录

前 言 ................................................................................................................................................. 1 第一章 概述 ..................................................................................................................................... 2

1.1 选题背景及设计意义 ........................................................................................................ 2 1.2 目前点歌系统的主流方式及特点 .................................................................................... 2 1.3 本课题主要设计内容 ........................................................................................................ 4 第二章 系统分析 ............................................................................................................................. 5

2.1 功能需求分析 .................................................................................................................... 5 2.2 本系统采用的关键技术 .................................................................................................... 7

2.2.1 JSP技术 ................................................................................................................ 7 2.2.2 JavaBean技术 ...................................................................................................... 8 2.2.3 JDBC技术 .............................................................................................................. 9 2.2.4 Java Servlet技术 ............................................................................................ 11 2.3 可行性分析 ..................................................................................................................... 13 第三章 系统设计与实现 ............................................................................................................... 14

3.1 系统总体功能设计 .......................................................................................................... 14 3.2 后台数据库设计 .............................................................................................................. 15

3.2.1 MYSQL 介绍 ......................................................................................................... 15 3.2.2用JDBC访问数据库 ............................................................................................ 15 3.2.3数据库表结构设计 .............................................................................................. 18 3.3系统处理流程设计 ........................................................................................................... 21

3.3.1系统操作流程 ...................................................................................................... 21 3.3.2数据增加流程 ...................................................................................................... 21 3.3.3数据修改流程 ...................................................................................................... 22 3.3.4数据删除流程 ...................................................................................................... 24 3.4系统模块详细设计与实现 ...................................................................................... 25 3.4.1首页 ...................................................................................................................... 25 3.4.2注册会员 .............................................................................................................. 27 3.4.3歌曲搜索 .............................................................................................................. 30 3.4.4会员登陆 .............................................................................................................. 31 3.4.5 管理员登陆 ......................................................................................................... 33 3.4.6 歌曲信息模块 ..................................................................................................... 37

第四章 系统调试与测试 ............................................................................................................... 40

4.1 程序调试 ......................................................................................................................... 40 4.2程序调试所用到的方法 .................................................................................................. 40 4.3 程序的测试 ..................................................................................................................... 40

4.3.1 测试的重要性及目的 ......................................................................................... 40

III

：KTV电脑点歌系统软件开发

4.3.2 测试的步骤 ........................................................................................................ 41 4.3.3 测试的主要内容 ................................................................................................ 42

第五章 总论 .................................................................................................................................. 44

5.1 系统评价 ........................................................................................................................ 44 5.2 安全性问题 .................................................................................................................... 45 第六章 小结 .................................................................................................................................. 46 致谢 ................................................................................................................................................ 48 参考文献 ........................................................................................................................................ 49

IV

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库KTV电脑点歌系统软件开发 - 图文在线全文阅读。