英语毕业论文-电子商务网站的设计与实现.doc

overseas chinese collegeundergraduate thesisthe design and implementation of shopping site students name ： hu jing wen students id ： 2007142125 college ： overseas chinese college major ： information and management instructor ： jean lee march 30, 20091abstractthe design and implementation of shopping sitehu jing wenwith the development of the internet technology, peoples daily life has been inseparable from the network. in the future society peoples life will be increasingly relying on digital technology, more and more on digital, internet, electronic, virtual. the e-commerce is also increasingly closer to peoples life because of the development of the internet.during the developing process, current applicative status and the developing trends of the internet, we have enough faith in that the internet technology will greatly change the way we live and work, and even some changes may occur to our social values.the design attempts to use asp structure a dynamic e-commerce site on the network, the article introduces the background first, comprehensive analyses the current developing status of e-commerce, and receives the demand for online shopping system in accordance with these data and the analysis on all aspects. then the structure and function modules had been designed to achieve by the author according to the demand for online shopping system. the system structure can be divided into web application layer, business logic, data access layer, data access basic, connection layer and the business entity layer support; according to the function, it can be divided into two modules: general users and system administrators, so every customer could shop easily through the internet without walking out.keywords: internet; asp; e-commerce; online shopping;33购物平台的设计与实现摘 要随着internet技术的发展，人们的日常生活已经离不开网络。未来社会人们的生活和工作将越来越依赖于数字技术的发展，越来越数字化、网络化、电子化、虚拟化。电子商务也随着网络的发展日益和人们的生活贴近。internet的发展历程以及目前的应用状况和发展趋势，可以充分地相信网络技术将极大的改变我们的生活和工作方式，甚至社会的价值观也会发生某种变化。本设计尝试用asp在网络上架构一个动态的电子商务网站，文章首先介绍了相关背景，同时综合分析了电子商务的发展现状，并且根据这些资料和其他各方面情况分析得到网络购物系统的相关需求。然后笔者根据需求对网络购物系统的系统结构和功能模块进行了设计实现。该系统结构上可分为web应用层、业务逻辑层，数据访问层、数据访问基层、连接支持层和业务实体层；若按照功能则可划分为普通用户和系统管理员两大模块，以使每一位顾客不用出门在家里就能够通过上网来轻松购物。关键词：internet；asp；电子商务；网络购物；contents1. introduction12 feasibility analysis12.1 feasibility study11.1.1 technical feasibility21.1.2 economic feasibility32.2 design method32.3 c / s model description42. system requirements analysis42.1 requirements analysis42.2 flowchart52.3 1.1 the creation of data dictionary73. system concept design83.1 system design83.2 system design of e-r diagram93.3 the design of the database153.4 create the database table164. application design system204.1 system features modular design204.2 the detailed design of system214.2.1 user module home page214.2.2 new user registration22conclusions24references261. introduction1.1 backgroundwith the development of time, information technology, internet / intranet technology, constant development and improvement of database technology, network acceleration of the process, the traditional way of shopping was increasingly unable to meet the needs of peoples fast-paced life, making the companys it department recognize the advantage of the internet, e-commerce is developed in such a context . with the continually maturation of the e-commerce technology, e-commerce functions become more and more powerful, registered users can search and buy all the goods that they want , this made people initial experience the pleasure of free shopping without walking out. my graduation design is also a development of e-commerce systems - zippo lighters e-commerce site.1.2 the main function of the sitethe user can do registration, browsing commodity, search and query commodity, making order, dealing the order and some other things;the administrator can maintain and update the system by doing the user management, order management, product management, comment management and some other functions.1.3 development tool and databasethe development of this site is by using asp and microsoft access.2 feasibility of analysis2.1 feasibility studythe task of this phase is not solving the problem, but analysing the scope of questions, and exploring whether it is worth solving this problem, is there a viable solution. at this stage, system analysts should let the high-level logic model, and on this basis, determining the project scope and objectives more accurate and more detailed. then the analyst estimates the cost and the effectiveness more accurately, analysis the cost and the benefit carefully for this proposed system, this is one of the main tasks of this phase. the result of the feasibility study is the important basic to make sure whether continue the project or not by the heads of department. the purpose of the feasibility study is to use the smallest cost in the shortest possible time to determine whether the problem could be solved. the purpose of the feasibility study is not to solve the problem, but to make sure whether it is worth to solve the problem.2.1.1 technical feasibilitythe research for the technical feasibility is according to features, performance and the constraints by implementing the system, accomplish the feasibility of this system from the point of technical. the technical feasibility is the most difficult and important work in the process of development, which includes risk analysis, resource analysis and technical analysis. in risk analysis, which is asked to determine whether if it is able to design or implement the functionality and performance of system under the given constraints. to this online shopping system, there is no risk, because this is a design for our graduation, there is no special requirements by each customer, so there is no risk. analysis of resources is to demonstrate that whether there is enough clerks, software ,hardware working environment for developing the system, this is a simple shopping system, no much need for clerks, one person can accomplish all the development of this system , by the hand of software , it is also supporting the platform, development tools have been introduced in front, and hardware resource is a general disposing computer, the working environment is where they live, so the resource is also not a problem; technical analysis is whether the current technology support the system development. involved in e-commerce web design technology and database technology has become more mature, and after various types of dynamic web design comprehensive comparison of the language, the design of this task chose the asp technologies. asp is a technology launched by microsoft to replace the cgi, based on windows platform, currently used in most websites, asp is a server-side scripting in the windows operating environment, through such an environment, users can create and run dynamic interaction. type of web server applications, enabling dynamic web sites so that the systems technology is also feasible.2.1.2 economic feasibilitythe purpose of the research for economic feasibility was to achieve the best economic benefits by using the minimal developing cost, which is necessary to analysis the economic situation and investment. now online shopping has been accepted and loved by people, because it has many advantages, for example, fast and convenient, so it must have access to bring more economic benefit.2.1.3 operational feasibilitythe interface of the system is easy to be understand and simple to be used.1.1 软、硬件配置及结构1.1.1 硬件配置服务器：pentium4 2.4ghz cpu以上,内存至少256 mb，硬盘空间50m,1024*768或更高分辨率。客户端：pentium4 2.4ghz cpu以上,内存至少256 mb，硬盘空间50m,1024*768或更高分辨率。1.1.2 软件配置windows xp/2000/2003操作系统,access数据库，dreamweaver cs3，internet信息服务器，internet explorer 或其他web浏览器。1.使用工具介绍本系统采用bs结构，即browserserver(浏览器服务器)结构，就是指安装维护一个服务器(server)，而客户端采用浏览器(browse)运行软件。它是随着internet技术的兴起，对cs结构的一种变化和改进。主要利用了不断成熟的www浏览器技术，结合多种script语言(vbscript、javascript)和activex技术，是一种全新的软件系统构造技术。macromedia dreamweaver mx是 建立 web 站点和应用程序的专业工具。它将可视布局工具、应用程序开发功能和代码编辑支持组合为一个功能强大的工具，使每个级别的开发人员和设计人员都可利用它快速创建界面吸引人并且基于标准的站点和应用程序。从对基于 css 的设计提供领先的支持到手动编码功能，dreamweaver 在一个集成和高效的环境中为专业人员提供了所需的工具。开发人员可以将其选择的服务器技术与 dreamweaver 配合使用，建立将用户连接到数据库、web 服务和旧式系统的强大 internet 应用程序。dreamweavermx是一款专业的 html 编辑器，用于对 web 站点、web 页和web 应用程序进行设计、编码和开发。无论您喜欢直接编写 html 代码的驾驭感还是偏爱在可视化编辑环境中工作，dreamweaver 都会为您提供帮助良多的工具，丰富您的 web 创作体验。利用 dreamweaver 中的可视化编辑功能，您可以快速地创建页面而无需编写任何代码。不过，如果您更喜欢用手工直接编码，dreamweaver 还包括许多与编码相关的工具和功能。并且，借助 dreamweaver，您还可以使用服务器语言（例如 asp、asp.net、coldfusion 标记语言 （cfml）、jsp 和 php）生成支持动态数据库的 web 应用程序。2.后台数据库的介绍本系统后台使用access作为后台的数据管理系统，使用asp技术，使用iis作为web服务器，而在前台使用dreamweaver cs3设计页面、利用asp动态网页技术它可以直接嵌入到hmtl代码中，与hmtl/script等达到完美的结合。通过ado组件访问后台数据库，轻松实现数据库的存取，从而实现动态网站。2.2 design method 1. the systems overall design is the overall framework for the construction of the whole system, without this step, the latter will not be continued, so this part must be taken seriously. 2. on the design of the database1) create a database2) design the table structure: the system uses access as the background database, the database table to build a 8, respectively: administrators table, a large classification of goods, payment information form, the customer order table, a small classification of goods, commodities for more information table, the user information table, product reviews table.3. on the main interface of each module and system designthe system is designed for online shopping, web front, including: membership functions, the member center, query products, shopping cart, and admin. the requirement is to analysis and design the online shopping system as they are the core, detailed system design work to complete the purchase, preparation, testing member functions, member center functions, check product features, shopping cart and back office management functions corresponding procedures.1.2 系统结构本系统采用b/s结构，即browser/server(浏览器/服务器)结构。2.3 c / s model descriptionb / s (browser / server, browser / server) mode, also called b / s structure，which is with the rise of internet technology on the c / s model application expansion. in this structure, the user work through the ie browser interface is implemented. b / s mode of operation and maintenance is the biggest benefit relatively simple and can achieve different people, from different locations, different access methods (such as lan, wan, internet / intranet, etc.) to access and manipulate shared data.3. system requirements analysis2.1 requirements analysisthe main task of requirements analysis is to make sure which work should be completed by the system, which is also made conditions to target system, complete, accurate, specific, clear requirements, determine the system must have the functionality and performance, system requirements, operating environment, and prediction the development prospects, and analysis the data in the system carefully, in order to complete a good software environment. in the stage of requirement analysis, systems analysts will study the specific functions of the software needs to be done carefully. requirements analysis is the basis for software development, we must verify its correctness carefully, developers and users must be made exactly the same views, analysis of the needs document should be confirmed by the user.when a customer offers his vision to build the mall or the terminology used is called the user offer his needs, how should it be? is it should be understood that what the mall do? do you want to understand how the mall to do, how it services customers? whether we should have a real understanding of the worlds mall first, what the mall likes in the real world? how to accomplish the function? if you are the management of this mall, what should you do, what to do? if you are a customer so that how you can complete your shopping process? what is the different between real-world store and online store? so before we construct a mall, we should know that what a mall do and how to provide an environment to customers, how to provide services to users. from purchase to the counter to buy goods every time ,from the customer take goods to the checkout, there is a corresponding process, each step must complete the corresponding work, to know how these work is arranged and implemented, and how these work is arranged and implemented in the electronic mall. in fact, all of these are the requirements and planning for system, and by understanding these, the next step is to design, as how to plan and design the mall. when we begin to construct a mall, it must be planned and designed systematically, to clean out the requirements and the overall arrangement, the only way is the next step, which is a prerequisite of any system development.1.3 系统数据流图的创建 根据上面所描述的系统需求、流程，以流程的形式画出系统功能模块图，并将这些流程图分为客户端和服务端。客户端流程图与服务端模块流程图，如图3.1所示。2.2 flowchartdemand for the manager is reflecting to provide various kinds of information, save, update and query, which requires that the database structure is fully meet all kinds of information input and output. collect the basic data, data structure and data handling processing, composed a detailed data dictionary, to lay the foundation for subsequent detailed design. at the time of dealing the data, allow managers to query and modify easily. it is able to set the institutions and organizations, and there is the relationship between machine number and employee information, if the employees information is modified, the corresponding institution code will be changed too. on the other hand, payroll management, payment of wages, it should consider the personal income tax rate and employee rewards and punishments, make these data into the database.to accomplish the function, we need to write the main program modules and business processes, as shown in figure 3.2图3.2客户端流程图图3.3管理流程图buy carsubmit orderuser submitsubmit successdetail informationpay typedestination2.3 1.1 the creation of data dictionarydata dictionary is a collection of information about the data, its the data flow charts contains all the elements in the definition of the set. the main purpose of any dictionary are available for inspection entries do not understand the interpretation of the role of data dictionary is in the process of analysis and design software to give information on the description of the data. data flow charts and data dictionary together constitute the logical model of the system, data flow charts is not strict without the data dictionary, and however data dictionary is also difficult to functioning properly without the data flow charts. only the data flow charts and the precise definition of data flow are together, so that we can constitute the system specifications. we just illustrate the major elements because of there are so many elements.the main purpose of the data dictionary is as the primary tool of molecular stage. establish a strict definition is consistent help to improve communication between analysts and clients in the data dictionary; than it will eliminate many potential misunderstandings. control information for each data element is valuable in the data dictionary charts. because the use of a given list of data elements for all programs, it is easy to change one element to estimate the impact, and it also can affected programs or modules to make the appropriate changes.as there is no automatic process data dictionary yet, we write data dictionary by using a card, each card describing a data element stored information. this approach has better required the implementation above, in particular, to modify and updated easily and deal each data element information separately. the information contained in each card: name, aliases, description, definition, location.the following are the main elements of the data flow charts of the data dictionary card.名字：商品大分类表别名：描述：是储存一级商品分类的表。定义：商品大分类表= categoryid+category+first+categoryorder位置：数据库名字：管理员表别名：描述：是储存管理员帐号、密码、权限的表。定义：管理员表= id+admin+password + rank位置：数据库名字：商品评论表别名：描述：是储存客户对关注商品的评论的表。定义：商品评论表= reviewid+id+title+reviewdtm+reviewcontent+audit位置：数据库名字：付款信息表别名：描述：是储存付款方式、账号、收款人姓名的表。定义：付款信息表=deliveryid+subject+fee+methord+deliveryidorder位置：数据库名字：商品小分类表别名：描述：是储存在大分类下一级的小分类商品的信息。定义：商品小分类表= sortsid+sorts+sortsorder+categoryid+first位置：数据库名字：商品详细信息表别名：描述：是储存商品相关信息的表。定义：商品详细信息表= id+name+author+introduce+productdate+score+detail+content+rank+price1+price2+recommend+solded+viewnum+discount+sortsid+categoryid位置：数据库名字：用户表别名：描述：是储存用户相关信息的表。定义：用户表= broadcast + userid + username + useremail + password+ identify+ mobile+ userqq+ adddate+ question+ answer+ loginnum+ lastvst+ recepit+ city+ address+ postcode+ usertel+ deliverymethord+ paymethord+ sex+ realname+ vip位置：数据库名字：客户订单表别名：描述：是储存客户姓名、购买物品、付款信息、收货地址等的表。定义：客户订单表=actionid+username+actiondate+id+state+recepit+address+postcode+comments+paymethord+deliverymethord+sex+paid+realname+useremail+usertel+userid位置：数据库4. system structure design3.1 system structure designthe most important thing of the conceptual design is the systems modular, modular means to since the system under the layer is divided into several modules of the process when you solve a complex problem. each module complete a specific function, all the modules are organized in s