恒丰商务公司MP3销售系统的设计与实现.doc

恒丰商务公司MP3销售系统的设计与实现目录前言.................................................................................................................................................................31系统的可行性分析......................................................................................................................................22系统需求分析..............................................................................................................................................32.1系统需求调查以及数据流图...........................................................................................................32.2技术难点分析...................................................................................................................................53系统概要设计.............................................................................................................................................53.1系统的设计思想...............................................................................................................................53.2系统功能模块图...............................................................................................................................63.2.1系统的前台功能模块图....................................................................................................63.2.2系统的后台模块图................................................................................................................63.3数据库概念模型设计......................................................................................................................73.4开发平台.........................................................................................................................................114详细设计...................................................................................................................................................114.1数据库表的设计.............................................................................................................................114.2数据库物理设计.............................................................................................................................134.3系统运行环境.................................................................................................................................144.3.1服务器端..............................................................................................................................144.3.2客户端.................................................................................................................................145系统实现...................................................................................................................................................145.1数据库的连接.................................................................................................................................145.2前台功能模块.................................................................................................................................155.2.1.注册登录模块......................................................................................................................155.2.2修改会员个人资料..............................................................................................................165.2.3商品的查询..........................................................................................................................175.2.4订单的查询..........................................................................................................................185.2.5购物车的实现......................................................................................................................185.3后台管理功能模块.........................................................................................................................205.3.1厂商管理..............................................................................................................................215.3.2会员管理..............................................................................................................................215.3.3订单的维护管理..................................................................................................................225.3.4添加MP3.............................................................................................................................235.3.5管理员的维护管理..............................................................................................................245.3.6数据库管理..........................................................................................................................255.4程序的调试.....................................................................................................................................255.4.1链接测试..............................................................................................................................265.4.2检查布局的一致性..............................................................................................................266结束语.......................................................................................................................................................266.1系统实现的结论............................................................................................................................266.2系统的不足....................................................................................................................................26致谢.........................................................................................................................................................27参考文献.......................................................................................................................................................27摘要随着WEB技术以及电子商务的不断发展，网络技术的实际应用越来越广泛，研究和开发WEB应用系统有着越来越重要的意义。恒丰商务公司MP3销售系统是根据恒丰商务公司的实际需求，采用ASP和Access数据库技术开发的一套基于B/S结构的网络应用系统。该系统实现了用户登录注册、在线购买MP3、结账处理和帐户管理等功能，是一个具有实际应用价值的MP3销售系统。根据软件工程理论，本文从系统需求分析、可行性分析、后台数据库设计和前端功能模块开发、系统测试等方面阐述了恒丰商务公司MP3销售系统的设计与实现过程。关键词ASPAccessSQLMP3销售系统TheDesignandRealizationofSystemforMP3forHengFengBusinessCompanyLiuXinweiCollegeofMathematicsandComputerScienceofJishouUniversity,Jishou,Hunan416000AbstractWiththecontinuousdevelopmentofWEBtechnologyandElectronicCommerce,thepracticalapplicationofnetworktechnologyisbecomingmoreandmorewidely,soitismoreandmoresignificanttostudyanddevelopWEBApplicationSystem.AccordingtotheactualdemandofHengFengBusinessCompany,thisMP3salessystemiscompletedwhichcombinedASPandAccessdatabasetechnologyandisbasedonB/Sstructure.Thesystemhasrealizedthewholeprocess,includingtheloggingin,registry,purchasingonline,settlingaccountoftheconsumerandaccountmanagement.ItsapracticalandvaluableMP3salessystem.Accordingtothesoftwareengineeringtheory,thispaperdescribesthecourseofdevelopingthissystemrangingfromsystemanalysis,feasibilityanalysis,backgrounddatabasedesignandfrontendfunctionmodulesrealizingtosystemtestingandotheraspects.KeyWordsASPAccessAQLMP3salessystem1前言随着社会的发展，人们越来越期盼有一种简捷而省时的方法购买商品，电子商务（EBusiness或ECommerce）的出现，满足了人们的这种需求，它在短短几年里，已被人们广泛接受。伴随着电子商务的大量涌现，企业网络化成为一种营销捷径，这种方式节省了很多成本，也方便顾客的选择。电子商务被看作是一种现代化的商业和行政作业方法，这种方法改善产品和服务质量、提高服务传递速度，实现跨领域商业活动，满足政府组织、厂商和消费者降低成本的需求，通过计算机网络加快信息交流以支持决策。电子商务的内涵和外延也在不断充实和扩展。近年来，世界范围内Internet/Intranet网络环境的基本形成，使得基于Internet环境的系统的设计与开发成为重要方向，特别是B/S结构的应用越来越广泛。随着Internet和电子商务等应用的出现，动态网页技术也随着诞生了。除了早期的CGI以外，现在主流的动态网页技术有JSP、ASP、PHP等。制作一个性能卓越的动态销售系统，必须具备HTML、CGI、JavaScript/VBScript、ASP等基本技术。现将这几种技术介绍如下1CGI即CommonGatewayInterface（公共网关接口）。可以使用不同的语言编写合适的CGI程序，如VisualBasic、Delphi或C/C等。虽然CGI技术发展成熟而且功能强大，但由于编程困难、效率低下、修改复杂等缺陷，逐渐被新技术取代。2PHP（PersonalHomepageProgram）是一种HTML内嵌式的语言（类似于IIS上的ASP）。而PHP独特的语法混合了C、Java、Perl以及PHP式的新语法，它可以比CGI或者Perl更快速的执行动态网页。3JSP页面由HTML代码和嵌入其中的Java代码所组成。服务器在页面被客户端请求后对这些Java代码进行处理，然后将生成的HTML页面返回给客户端的浏览器。JSP具备了Java技术的简单易用、完全面向对象、具有平台无关性且安全可靠、主要面向Internet等所有特点。4HTML是HypertextMakeupLanguage超文本标记语言的缩写，是一种专门用于Internet进行信息传输的标记性语言。用于界面设计，但并不是Fortran、C、Basic这样的程序设计语言，它所定义的范围仅局限于如何表现文字、图片及如何建立文件之间的连接。利用HTML设计出所需的静态页面，再综合JavaScript、VBScript、ASP、PHP、CGI等技术，就可以设计出各种形式、功能各异的动态页面。