摘  要：随着经济发展，社会进步和人民生活水平的提高，以及计算机的迅速发展,计算机逐渐进入我们生活的学习、生活、工作等各个方面，人们在工作之余也常常进行各种娱乐活动,到KTV放松唱歌也越来越成为人们喜欢的娱乐方式，传统的管理KTV点歌系统存在着管理效率低，劳动强度大，信息处理速度低而且准确率也不够令人满意等缺点。基于此，该设计采用目前主流的开发工具Visual Studio作为前端开发工具，采用C#技术选用SQL Server 作为后台数据库支撑平台。通过计算机实现对歌曲进行海量的存储和更加优化的信息管理，并能在一定程度上实现自动化。满足了人们娱乐生活的需要。56354

毕业论文关键词: KTV系统，数据库，C#，SQL Server

Abstract: With the development of economy, the progress of the society and improvement of people’s living standards, besides the rapid development of the computer, computer has entered into different aspects of our learning, living and working and so on. People often take more and more amusement activities after their work; singing in KTV has become the favorite entertainment among them. However, the traditional system of KTV management has many shortcomings as well, such as the inefficiency of management, the intensive laboring, and low speed of operating with unsatisfied accuracy. Based on these, this program adopts the mainstream tool Visual Studio as the front-end development tool, which uses the SQL Server  as a support platform for the database to exploit the KTV ordering system. This program satisfies the needs of people’s entertainment, through accomplishing storing a mount of songs and managing information more optimal, meanwhile it achieves automation to some extent.

Keywords: KTV system, database, c #, SQL Server

目    录

1 引言 4

2 开发工具简介 4

2.1 C#语言简介 4

2.2 SQL语言基础简介和SQL语句介绍 4

2.3 C/S架构介绍 5

3 系统需求分析 6

4 系统设计 6

4.1 系统功能结构 6

4.2实体关系E-R图设计 7

4.3数据库设计 8

4.4数据库关系图 9

5 系统详细设计 10

5.1登录模块设计 10

5.2点歌模块设计 11

5.3歌曲播放模块设计 13

5.4歌曲信息维护模块设计 14

5.5用户信息维护模块设计 16

6软件测试 17

6.1软件测试的必要性 17

6.2调试 19

结 论 20

参考文献 21

致谢 22

1 引言

随着人们生活水平的不断提高，人们的生活质量和消费质量也在不断提高，去KTV等娱乐场所消费唱歌已经成为人们尤其是年轻人的业余娱乐方式，而传统的点歌方式还停留在DVD播放机的层面，而人们的消费方式已更趋智能化，因此开发一种更加方便的智能的点歌系统更能满足人们的消费需求，而且有广阔的市场[1]。

2 开发工具简介源'自:优尔-'论/文'网"www.youerw.com C#+SQLServer的KTV点歌系统的设计:http://www.youerw.com/jisuanji/lunwen_60867.html