毕业论文-网上二手商品交易管理系统的设计与实现

1、网上二手商品交易管理系统的设计与实现摘 要 在现实生活中，越来越多的人对自己的二手物品具有出售的愿望，利用传统的方式进行出售存在一定的局限性。利用网络这个巨大的资源可以构建出一个廉价方便的交易平台，并找到广泛的顾客群，以此来达到出售目的。伴随电子商务的迅猛发展，网上二手商品交易管理系统应运而生。网上二手商品交易管理系统主要完成对用户权限进行划分，使不同用户具有不同的操作功能；实现二手商品信息的录入和对商品的查询，使卖家可以对出售商品进行实时发布，同时方便买家对二手商品进行选择性购买；实现了对用户和商品的管理，能对信息出错的商品和用户进行相应处理，从而保障交易正常有效进行。论文共分为6个章节，第

2、一章对当前背景与国内外现状进行分析：第二章对数据库技术等进行简单介绍；第三章对需求进行分析并提出解决方案；第四章是系统的设计过程介绍；第五章对本系统进行测试并得出结果。关键词：二手商品；交易管理；用户管理；商品管理；用户权限The Design and Implementation of Second-hand Commodity Exchange Management System OnlineAbstractIn reality, more and more people have desires to sale goods what they have been used. But th

3、ere is a limitation of sale for traditional methods. We can use internet which is of large resource to construct a cheap and convenient platform to exchange and find wide customers group to get the aim of selling. With the rapidly development of electronic commerce, the management system of secondha

4、nd commerce exchange on net comes into being.The management system of secondhand commerce exchange mainly divide powers of users to make different users own different operate factions. Realizing the input of the information of secondhand goods and finding out the goods can make sellers immediately i

5、ssue the good is that they have sold, and make things convenient for user to buy secondhand goods with selectivity. The management system of secondhand commerce exchange on net realize the management to user and goods, it makes it possible to tackle goods what is of fault information with user. So t

6、hat, there is a safeguard to exchange normally.This thesis divided into five main modules, respectively is: First, introduction selected topic background and significance and system development present situation; Second, introduction data bank technology, and the plan of B/S structure WEB programmin

7、g technique; Third, carries on the demand to the current enterprise to analyze and to propose the solution; Fourth, carries on the design according to the solution to the system; Fifth, carries onto the work plan statistical analysis system tests and obtains the test result.Key words：secondhand comm

8、odity; transaction management; user management; commodity management; user privilege目 录 论文页数：25页1引言11.1课题背景11.2开发现状分析11.3课题开发意义12理论基础22.1数据库技术22.2B/S架构的WEB程序设计技术32.2.1B/S模式32.2.2ASP简介42.2.3IIS简介43需求分析53.1现行业务系统描述53.2现行系统存在的主要问题的分析53.3提出解决方案54系统总体设计64.1设计思路64.2系统功能结构64.3E-R图84.4数据库设计85系统功能设计与实现105.1注

9、册105.2登录125.3修改密码135.4查询145.5添加、删除商品155.6用户管理166系统测试176.1测试方法176.2测试环境176.3测试过程176.4测试结果22结 论23参考资料23致 谢24声 明251 系统总体设计1.1 设计思路从系统需要实现的功能上来分析，本设计是基于WEB的二手商品交易管理系统，其核心是提供一个卖家发布、管理商品，买家查询购买商品的交易平台，本设计着重点是商品信息的发布、查询以及订购。重点关注的并非付款和交易过程。设计目的是希望能通过平台，买卖双方进行互动的了解并最终促成交易。对于系统设计来讲，必须要有它设计规则。本次设计规则主要有：简单性：在实现

10、平台的功能的同时，尽量让平台操作简单易懂，这对于一个网站来说是非常重要的。针对性：该系统是交易及后台管理的定向开发设计，所以具有专业针对性。实用性：系统能完成商品展示和管理员对信息的处理，具有良好的实用性。1.2 系统功能结构此次设计的名称为网上二手交易管理系统，此系统应该具有的功能进行分析：整个系统应该有三个操作用户角色，即卖家，买家和系统管理员。卖家根据自己的情况通过系统发布自己需要出售的商品及其信息；买家根据需要对商品进行浏览和购买；系统管理员在后台对系统进行用户管理，对资料进行统计分析，并开展系统的正常运行维护工作。每个角色操作的共性是通过密码验证后登录，工作完成后，退出登录状态。系统

11、功能模块如图（4-1）所示：图4-1 功能模块图本系统分为前台用户操作和后台管理员管理。后台管理功能描述如下：1、商品管理：商品的分类以及商品的信息管理。2、用户管理：查看用户信息，以及删除无效的用户帐户。3、订单管理：查看所有的订单，删除无效的订单。4、管理员管理：修改管理员密码。删除管理员帐户。后台管理功能流程如图（4-2）所示：图4-2 管理员功能流程图前台用户操作功能描述如下：1、注册：用户可进行区别注册，划分不同权限。2、买家模块：查询商品信息，选购商品下订单，修改个人密码。3、卖家模块：发布并可删除所属商品，查阅和删除订单，修改个人密码。前台用户操作功能流程如图（4-3）所示：图4

12、-3 用户功能流程图1.3 注册 注册页面设计如图（5-1）所示：图5-1 注册图登录页面设计如图（5-2）所示：1.4 修改密码密码修改页面设计如图（5-3）所示：图5-3 密码修改图1.5 查询查询页面设计如图（5-4）所示图5-4 查询图作为一个商品交易系统，用户能对商品进行特定查询是不可缺少的功能。其主要代码如下：<%set rs=server.createobject("adodb.recordset") /根据关键字进行模糊查询sql="select * from product wre title like '%"&k

13、eyword&"%' or content like '%"&keyword&"%' or class like '%"&keyword&"%'"rs.open sql,conn,1,1%>1.6 添加、删除商品图5-5 添加商品图在卖家登录后，可行使发布商品的权限。其主要代码如下：<%spclass=request.form("spclass") /提取文本框值赋给spclassspnew=request.form(&qu

14、ot;spnew") /提取文本框值赋给spnewtitle=request.form("title")jiage=request.form("jiage")num=request.form("num")content=request.form("content")money=request.Form("money")set rs=server.createobject("adodb.recordset")sql="select * from produc

15、t where id is null"rs.open sql,conn,1,3 /从product表中查找数据当编号为空时rs.addnew /把商品信息添加到product表中rs("title")=titlers("content")=contentrs("class")=spclassrs("pic")=session("picurl")num=rs("num")rs("num")=num+1rs("selluser")

16、=session("user")rs("money")=jiagers("tell")=session("tell")rs("address")=session("address")rs.update /更新数据库并关闭记录集rs.closeset rs=nothing%>删除商品（图5-6）：图5-6 商品删除图删除自己发布的商品也是卖家对商品进行管理的功能中不可缺少的。其主要代码如下：<%picid=request("picid") /根据

17、商品id进行商品的删除set rs=server.createobject("adodb.recordset") sql="delete from product where id='"&picid&"'"rs.open sql,conn,1,2 /从商品中删除数编号为PICID的商品response.redirect(request.serverVariables("Http_REFERER")%>1.7 用户管理用户管理页面设计如图（5-7）所示：图5-7 用户管理图后台管

18、理中最主要的功能之一便是对所有用户进行管理，管理员有删除用户等权限。部分代码如下：<%id=request("id")set rs=server.createobject("adodb.recordset") /根据用户id删除用户sql="delete from myuser where uid='"&id&"'"rs.open sql,conn,1,2response.redirect(request.serverVariables("Http_REFERER&q

19、uot;)%> /操作结束后回到当前页面2 系统测试2.1 测试方法经过系统的分折与设计后，就可以根据设计模型在具体的环境中实现系统，生成系统的源代码、可执行程序和相应的软件和文件，建立一个可执行的系统。然后需要对系统送行测试和排错，保证系统符合预定的要求。获得一个无错的系统实现，调试的结果将确认所完成的系统可以真正使用。测试方法上使用以界面为基础的测试。以界面为基础的测试仅仅依靠软件与其运行环境之间的接口来选择和产生测试资料，而不管软件的具体需求和具体实现细节。2.2 测试环境计算机配置：赛扬4 1G 256M内存操作系统：Windows 2000/XP/2003服务器组件：IIS 5

20、.0 以上版本 数据库类型：Microsoft SQL Server 20002.3 测试过程为说明本系统功能的完整性，在测试中模拟一次完整的交易过程来体现。注册功能测试：系统对用户进行区别注册， 注册过程中用户名及密码不能为空，且用户名不能重复，否则将无法注册。当注册用户名为空时（图6-1）：图6-1 注册图1当输入密码为空时（图6-2）：图6-2 注册图2密码输入不一致时（图6-3）：图6-3 注册图3正确填写之后进行注册，注册成功后显示（图6-4）：图6-4 注册图4登录功能测试：该测试的目的是保证登录窗口的正确性与在错误发生时的容错与纠错性。通过在登录框中输入错误的用户密码来检测系统的

21、出错运行情况。要求系统在遇到这些情况时能给出正确的错误提示。用户在登录成功后将根据不同的身份弹出不同的页面。以卖家登录为例，将比买家多一个管理功能，其中包括发布商品，删除商品及订单管理。若输入用户名及密码错误则显示（图6-5）：图6-5 登录图修改密码功能测试：进入修改密码页面，修改时若密码输入不同，则显示（图6-6）：图6-6密码修改图1输入一致则显示（图6-7）：图6-7 密码修改图2查询功能测试：在搜索栏中输入所要查询商品的名称（图6-8），点击快速搜索：图6-8 查询图1查询结果（图6-9）：图6-9 查询图2若输入不存在商品的名称则显示（图6-10）：图6-10 查询图3购买功能测试

22、：买家登录成功后首先对商品进行浏览或查询，选定之后将进行购买。点击购买后显示（图6-11）：图6-11 购买图1购物车测试：买家在点击购买后查看购物车出现如下界面（图6-12）：图6-12 购买图2点击“去结帐”后出现（图6-13）：图6-13 购买图3买家点击“确定购买”后，订单便自动向系统提交上去。订单管理测试：卖家登录后查看属于自己的订单信息（图6-14）：图6-14 订单图1点击“删除”后出现（图6-15）：图6-15 订单图2管理员通过专门页面使用管理员帐号和密码进入后台管理首页进行系统的管理操作。由于管理员功能与用户功能有部分重复，所以在这里就不再介绍。分类管理测试：该功能为添加及

23、删除两个部分。添加分类（图6-16）：图6-16 分类图1提交之后显示（图6-17）：图6-17 分类图2用户管理测试：点击用户管理可查看所有用户并进行删除操作（图6-18）：图6-18 用户管理图1点击“删除”对相应对象进行处理，如删除用户“刘畅宇”（图6-19）：图6-19 用户管理图22.4 测试结果本次测试通过模拟一次完整的交易过程，测试范围包括用户的注册、登录、密码管理，商品的发布、查询、删除等，并且对了系统后台的管理功能进行了测试。测试结果显示系统基本能够实现预期的功能，能够提供用户对商品信息的实时发布和查询，提供了一个简单的网上二手商品交易管理系统。但是部分功能仍旧需要加强或者改

24、进，如商品的分类管理不够详尽，没有实现对订单的高效率管理，商品信息的内容发布不够规范等。ag an employment tribunal clai Emloyment tribunals sort out disagreements between employers and employees. You may need to make a claim to an employment tribunal if: you don't agree with the disciplinary action your employer has taken against you your

25、employer dismisses you and you think that you have been dismissed unfairly. For more informu, take advice from one of the organisations listed under Fur ther help. Employment tribunals are less formal than some other courts, but it is still a legal process and you will need to give evidence und

26、er an oath or affirmation. Most people find making a claim to an employment tribunal challenging. If you are thinking about making a claim to an employment tribunal, you should get help straight away from one of the organisations listed under Further help. ation about dismissal and unfair dismi

27、ssal, see Dismissal. You can make a claim to an employment tribunal, even if you haven't appealed against the disciplinary action your employer has taken against you. However, if you win your case, the tribunal may reduce any compensation awarded to you as a result of your failure

28、 to appeal. Remember that in most cases you must make an application to an employment tribunal within three months of the date when the event you are complaining about happened. If your application is received after this time limit, the tribunal will not usually accept i. If you are worried about ho

29、w the time limits apply to you If you are being represented by a solicitor at the tribunal, they may ask you to sign an agreement where you pay their fee out of your compensation if you win the case. This is known as a damages-based agreement. In England and Wales, your solicitor can't char

30、ge you more than 35% of your compensation if you win the case. You are clear about the terms of the agreement. It might be best to get advice from an experienced adviser, for example, at a Citizens Advice Bureau.  To find your nearest CAB, including those that give advice by e-mail, click

31、on nearest CAB. For more information about making a claim to an employment tribunal, see Employment tribunals. The (lack of) air up there Watch m Cay man Islands-based Webb, the head of Fifa's anti-racism taskforce, is in London for the Football Association's 150th anniversary cele

32、brations and will attend City's Premier League match at Chelsea on Sunday. "I am going to be at the match tomorrow and I have asked to meet Ya ya Toure," he told BBC Sport. "For me it's about how he felt and I would like to speak to him first to find out what his experience wa

33、s." Uefa has opened disciplinary proceedings against CSKA for the "racist behaviour of their fans" during City's 2-1 win. Michel Platini, president of European football's governing body, has also ordered an immediate investigation into the referee's actions.

34、 CSKA said they were "surprised and disappointed" by Toure's complaint. In a statement the Russian side added: "We found no racist insults from fans of CSKA." Age has reached the end of the beginning of a word. May be guilty in his seems to passing a lot of different life bec

35、ame the appearance of the same day; May be back in the past, to oneself the paranoid weird belief disillusionment, these days, my mind has been very messy, in my mind constantly. Always feel oneself should go to do something, or write something. Twenty years of life trajectory deeply shallow, sudden

36、ly feel something, do it.一字开头的年龄已经到了尾声。或许是愧疚于自己似乎把转瞬即逝的很多个不同的日子过成了同一天的样子；或许是追溯过去，对自己那些近乎偏执的怪异信念的醒悟，这些天以来，思绪一直很凌乱，在脑海中不断纠缠。总觉得自己似乎应该去做点什么，或者写点什么。二十年的人生轨迹深深浅浅，突然就感觉到有些事情，非做不可了。The end of our life, and can meet many things really do?而穷尽我们的一生，又能遇到多少事情是真正地非做不可？ During my childhood, think lucky money and

37、new clothes are necessary for New Year, but as the advance of the age, will be more and more found that those things are optional; Junior high school, thought to have a crush on just means that the real growth, but over the past three years later, his writing of alumni in peace, suddenly found that

38、isn't really grow up, it seems is not so important; Then in high school, think don't want to give vent to out your inner voice can be in the high school children of the feelings in a period, but was eventually infarction when graduation party in the throat, later again stood on the pitch he

39、has sweat profusely, looked at his thrown a basketball hoops, suddenly found himself has already can't remember his appearance. Baumgartner the disappointing news: Mission aborted. r plays an important role in this mission. Starting at the ground, conditions have to be very calm - winds less tha

40、n 2 mph, with no precipitation or humidity and limited cloud cover. The balloon, with capsule attached, will move through the lower level of the atmosphere (the troposphere) where our day-to-day weather lives. It will climb higher than the tip of Mount Everest (5.5 miles/8.85 kilometers), drifting e

41、ven higher than the cruising altitude of commercial airliners (5.6 miles/9.17 kilometers) and into the stratosphere. As he crosses the boundary layer (called the tropopause),e can expect a lot of turbulence. We often close ourselves off when traumatic events happen in our lives; instead of letting the world soften us,