摘  要：随着现代社会精神文明的发展以及B2C电子商务的成熟，吉他电子网站作为乐器营销领域一种新的营销渠道，必将成为需要。本文从研究吉他电子商务的政策背景、行业市场状况入手，结合实践调研的结果，对网站建设的可行性做出了分析。在网站设计可行的基础上，本文从网站设计者的角度对网站做了需求分析。根据网站规划所提出的需求，本文基于JSP技术和SQL语言，对网站进行了总体设计和详细设计，并且最终通过用例测试检验了设计成果，得出以下结论：（1）国内的乐器类电子商务网站发展尚不成熟，专业化程度有待进一步考量，市场推广多基于吉他论坛与同类乐器论坛，客户群开发尚不充分；（2）本设计基于市场背景，致力于打造专业的垂直性吉他电子商务网站，只把吉他一类乐器作为网站的核心商品；（3）本设计目前已实现的功能有注册、登录、浏览、添加到购物车以及管理员管理，支付功能有待依据今后的发展状况进行完善。
关键字： 吉他；电子商务；网站设计；JSP；SQL,4098
Analysis and design of e-commerce site of Guitar
Abstract: With the development of modern social spiritual civilization and B2C e-commerce is very mature, guitar electronics web site as a new marketing instrument marketing channels, will be needed. The paper begins from the policy background and e-commerce industry market conditions, combined with the practice of research results, analyzes the feasibility of the website construction. On the basis of web design is feasible, this article from the perspective of web designers did demand analysis on site. According to the website planning requirements proposed by the authors, this article is based on JSP and SQL language, I made the overall design and detailed design, and through the cases to test the final design results, draw the following conclusions: (1) Domestic instruments e-commerce development is not mature yet, professional degree needs further consideration, and marketing is based on the guitar more the same instrument BBS, so the customer base is not yet fully development; (2) This design is based on the market background, to create professional vertical guitar e-commerce sites, only the guitar type of musical instrument, which is the core of the website commodity; (3) This design has the functions have ‘register’, ‘login’, ‘browsing’, ‘add to shopping cart ’ and admin management, payment function on the basis of future development remains to be perfect.

Keywords: Guitar; E-commerce; Website design; JSP; SQL
目录
一、绪论    1
（一）课题研究的目的与意义    1
（二）课题研究的背景    1
二、吉他电子商务网站的规划    4
（一）市场状况    4
（二）可行性分析    5
（三）开发技术与工具    10
三、系统需求分析    11
（一）功能简介    11
（二）系统流程图    12
（三）数据流程图    13
（四）数据字典    14
（五）E-R图    20
四、系统设计    22
（一）系统框架结构图    22
（二）模块设计    23
（三）数据库设计    24
（四）编码设计    25
五、网站测试    29
（一）网站测试计划    29
（二）测试结果    29
（三）测试评价    32
751、归结与展望    34
（一）结论    34
（二）网站前景与展望    34 JSP吉他电子商务网站的分析与设计+数据流程图+ER图:http://www.751com.cn/jisuanji/lunwen_599.html