畢業(yè)論文網(wǎng)上二手商品交易管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)27745

1、網(wǎng)上二手商品交易管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)網(wǎng)上二手商品交易管理系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn)摘摘 要要 在現(xiàn)實(shí)生活中，越來(lái)越多的人對(duì)自己的二手物品具有出售的愿望，利用傳統(tǒng)的方式進(jìn)行出售存在一定的局限性。利用網(wǎng)絡(luò)這個(gè)巨大的資源可以構(gòu)建出一個(gè)廉價(jià)方便的交易平臺(tái)，并找到廣泛的顧客群，以此來(lái)達(dá)到出售目的。伴隨電子商務(wù)的迅猛發(fā)展，網(wǎng)上二手商品交易管理系統(tǒng)應(yīng)運(yùn)而生。網(wǎng)上二手商品交易管理系統(tǒng)主要完成對(duì)用戶(hù)權(quán)限進(jìn)行劃分，使不同用戶(hù)具有不同的操作功能；實(shí)現(xiàn)二手商品信息的錄入和對(duì)商品的查詢(xún)，使賣(mài)家可以對(duì)出售商品進(jìn)行實(shí)時(shí)發(fā)布，同時(shí)方便買(mǎi)家對(duì)二手商品進(jìn)行選擇性購(gòu)買(mǎi)；實(shí)現(xiàn)了對(duì)用戶(hù)和商品的管理，能對(duì)信息出錯(cuò)的商品和用戶(hù)進(jìn)行相應(yīng)處理，從而保障

2、交易正常有效進(jìn)行。論文共分為 6 個(gè)章節(jié)，第一章對(duì)當(dāng)前背景與國(guó)內(nèi)外現(xiàn)狀進(jìn)行分析：第二章對(duì)數(shù)據(jù)庫(kù)技術(shù)等進(jìn)行簡(jiǎn)單介紹；第三章對(duì)需求進(jìn)行分析并提出解決方案；第四章是系統(tǒng)的設(shè)計(jì)過(guò)程介紹；第五章對(duì)本系統(tǒng)進(jìn)行測(cè)試并得出結(jié)果。關(guān)鍵詞關(guān)鍵詞：二手商品；交易管理；用戶(hù)管理；商品管理；用戶(hù)權(quán)限the design and implementation of second-hand commodity exchange management system onlineabstractin reality, more and more people have desires to sale goods what th

3、ey have been used. but there 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 mana

4、gement system of secondhand 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 m

5、ake sellers immediately issue 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 in

6、formation with user. so that, 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

7、 structure web programming 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.

8、key words：secondhand commodity; transaction management; user management; commodity management; user privilege目目 錄錄 論文頁(yè)數(shù)：25 頁(yè)1引言.11.1課題背景.11.2開(kāi)發(fā)現(xiàn)狀分析.11.3課題開(kāi)發(fā)意義.12理論基礎(chǔ).22.1數(shù)據(jù)庫(kù)技術(shù).22.2b/s 架構(gòu)的 web 程序設(shè)計(jì)技術(shù) .32.2.1b/s 模式 .32.2.2asp 簡(jiǎn)介 .42.2.3iis 簡(jiǎn)介 .43需求分析.53.1現(xiàn)行業(yè)務(wù)系統(tǒng)描述.53.2現(xiàn)行系統(tǒng)存在的主要問(wèn)題的分析.53.3提出解決方案.54系統(tǒng)總體設(shè)計(jì)

9、.64.1設(shè)計(jì)思路.64.2系統(tǒng)功能結(jié)構(gòu).64.3e-r 圖 .84.4數(shù)據(jù)庫(kù)設(shè)計(jì).85系統(tǒng)功能設(shè)計(jì)與實(shí)現(xiàn).105.1注冊(cè).105.2登錄.125.3修改密碼.135.4查詢(xún).145.5添加、刪除商品.155.6用戶(hù)管理.166系統(tǒng)測(cè)試.176.1測(cè)試方法.176.2測(cè)試環(huán)境.176.3測(cè)試過(guò)程.176.4測(cè)試結(jié)果.22結(jié) 論.23參考資料.23致 謝.24聲 明.251 1系統(tǒng)總體設(shè)計(jì)系統(tǒng)總體設(shè)計(jì)1.11.1 設(shè)計(jì)思路設(shè)計(jì)思路從系統(tǒng)需要實(shí)現(xiàn)的功能上來(lái)分析，本設(shè)計(jì)是基于 web 的二手商品交易管理系統(tǒng)，其核心是提供一個(gè)賣(mài)家發(fā)布、管理商品，買(mǎi)家查詢(xún)購(gòu)買(mǎi)商品的交易平臺(tái)，本設(shè)計(jì)著重點(diǎn)是商品信息的發(fā)布

10、、查詢(xún)以及訂購(gòu)。重點(diǎn)關(guān)注的并非付款和交易過(guò)程。設(shè)計(jì)目的是希望能通過(guò)平臺(tái)，買(mǎi)賣(mài)雙方進(jìn)行互動(dòng)的了解并最終促成交易。對(duì)于系統(tǒng)設(shè)計(jì)來(lái)講，必須要有它設(shè)計(jì)規(guī)則。本次設(shè)計(jì)規(guī)則主要有：簡(jiǎn)單性：在實(shí)現(xiàn)平臺(tái)的功能的同時(shí)，盡量讓平臺(tái)操作簡(jiǎn)單易懂，這對(duì)于一個(gè)網(wǎng)站來(lái)說(shuō)是非常重要的。針對(duì)性：該系統(tǒng)是交易及后臺(tái)管理的定向開(kāi)發(fā)設(shè)計(jì)，所以具有專(zhuān)業(yè)針對(duì)性。實(shí)用性：系統(tǒng)能完成商品展示和管理員對(duì)信息的處理，具有良好的實(shí)用性。1.21.2系統(tǒng)功能系統(tǒng)功能結(jié)構(gòu)結(jié)構(gòu)此次設(shè)計(jì)的名稱(chēng)為網(wǎng)上二手交易管理系統(tǒng)，此系統(tǒng)應(yīng)該具有的功能進(jìn)行分析：整個(gè)系統(tǒng)應(yīng)該有三個(gè)操作用戶(hù)角色，即賣(mài)家，買(mǎi)家和系統(tǒng)管理員。賣(mài)家根據(jù)自己的情況通過(guò)系統(tǒng)發(fā)布自己需要出售的商品及

11、其信息；買(mǎi)家根據(jù)需要對(duì)商品進(jìn)行瀏覽和購(gòu)買(mǎi)；系統(tǒng)管理員在后臺(tái)對(duì)系統(tǒng)進(jìn)行用戶(hù)管理，對(duì)資料進(jìn)行統(tǒng)計(jì)分析，并開(kāi)展系統(tǒng)的正常運(yùn)行維護(hù)工作。每個(gè)角色操作的共性是通過(guò)密碼驗(yàn)證后登錄，工作完成后，退出登錄狀態(tài)。系統(tǒng)功能模塊如圖（4-1）所示：圖 4-1 功能模塊圖本系統(tǒng)分為前臺(tái)用戶(hù)操作和后臺(tái)管理員管理。后臺(tái)管理功能描述如下：1、商品管理：商品的分類(lèi)以及商品的信息管理。2、用戶(hù)管理：查看用戶(hù)信息，以及刪除無(wú)效的用戶(hù)帳戶(hù)。3、訂單管理：查看所有的訂單，刪除無(wú)效的訂單。4、管理員管理：修改管理員密碼。刪除管理員帳戶(hù)。后臺(tái)管理功能流程如圖（4-2）所示：圖 4-2 管理員功能流程圖前臺(tái)用戶(hù)操作功能描述如下：1、注冊(cè)：

12、用戶(hù)可進(jìn)行區(qū)別注冊(cè)，劃分不同權(quán)限。2、買(mǎi)家模塊：查詢(xún)商品信息，選購(gòu)商品下訂單，修改個(gè)人密碼。3、賣(mài)家模塊：發(fā)布并可刪除所屬商品，查閱和刪除訂單，修改個(gè)人密碼。前臺(tái)用戶(hù)操作功能流程如圖（4-3）所示：圖 4-3 用戶(hù)功能流程圖1.31.3 注冊(cè)注冊(cè) 注冊(cè)頁(yè)面設(shè)計(jì)如圖（5-1）所示：圖 5-1 注冊(cè)圖登錄頁(yè)面設(shè)計(jì)如圖（5-2）所示：1.41.4 修改密碼修改密碼密碼修改頁(yè)面設(shè)計(jì)如圖（5-3）所示：圖 5-3 密碼修改圖1.51.5 查詢(xún)查詢(xún)查詢(xún)頁(yè)面設(shè)計(jì)如圖（5-4）所示圖 5-4 查詢(xún)圖作為一個(gè)商品交易系統(tǒng)，用戶(hù)能對(duì)商品進(jìn)行特定查詢(xún)是不可缺少的功能。其主要代碼如下：1.61.6 添加、刪除商品添加

13、、刪除商品圖 5-5 添加商品圖在賣(mài)家登錄后，可行使發(fā)布商品的權(quán)限。其主要代碼如下：刪除商品（圖 5-6）：圖 5-6 商品刪除圖刪除自己發(fā)布的商品也是賣(mài)家對(duì)商品進(jìn)行管理的功能中不可缺少的。其主要代碼如下：1.71.7 用戶(hù)管理用戶(hù)管理用戶(hù)管理頁(yè)面設(shè)計(jì)如圖（5-7）所示：圖 5-7 用戶(hù)管理圖后臺(tái)管理中最主要的功能之一便是對(duì)所有用戶(hù)進(jìn)行管理，管理員有刪除用戶(hù)等權(quán)限。部分代碼如下： /操作結(jié)束后回到當(dāng)前頁(yè)面2 2系統(tǒng)測(cè)試系統(tǒng)測(cè)試2.12.1測(cè)試方法測(cè)試方法經(jīng)過(guò)系統(tǒng)的分折與設(shè)計(jì)后，就可以根據(jù)設(shè)計(jì)模型在具體的環(huán)境中實(shí)現(xiàn)系統(tǒng)，生成系統(tǒng)的源代碼、可執(zhí)行程序和相應(yīng)的軟件和文件，建立一個(gè)可執(zhí)行的系統(tǒng)。然后需

14、要對(duì)系統(tǒng)送行測(cè)試和排錯(cuò)，保證系統(tǒng)符合預(yù)定的要求。獲得一個(gè)無(wú)錯(cuò)的系統(tǒng)實(shí)現(xiàn)，調(diào)試的結(jié)果將確認(rèn)所完成的系統(tǒng)可以真正使用。測(cè)試方法上使用以界面為基礎(chǔ)的測(cè)試。以界面為基礎(chǔ)的測(cè)試僅僅依靠軟件與其運(yùn)行環(huán)境之間的接口來(lái)選擇和產(chǎn)生測(cè)試資料，而不管軟件的具體需求和具體實(shí)現(xiàn)細(xì)節(jié)。2.22.2測(cè)試環(huán)境測(cè)試環(huán)境計(jì)算機(jī)配置：賽揚(yáng) 4 1g 256m 內(nèi)存操作系統(tǒng)：windows 2000/xp/2003服務(wù)器組件：iis 5.0 以上版本 數(shù)據(jù)庫(kù)類(lèi)型：microsoft sql server 20002.32.3測(cè)試過(guò)程測(cè)試過(guò)程為說(shuō)明本系統(tǒng)功能的完整性，在測(cè)試中模擬一次完整的交易過(guò)程來(lái)體現(xiàn)。注冊(cè)功能測(cè)試：系統(tǒng)對(duì)用戶(hù)進(jìn)行區(qū)

15、別注冊(cè)， 注冊(cè)過(guò)程中用戶(hù)名及密碼不能為空，且用戶(hù)名不能重復(fù)，否則將無(wú)法注冊(cè)。當(dāng)注冊(cè)用戶(hù)名為空時(shí)（圖 6-1）：圖 6-1 注冊(cè)圖 1當(dāng)輸入密碼為空時(shí)（圖 6-2）：圖 6-2 注冊(cè)圖 2密碼輸入不一致時(shí)（圖 6-3）：圖 6-3 注冊(cè)圖 3正確填寫(xiě)之后進(jìn)行注冊(cè)，注冊(cè)成功后顯示（圖 6-4）：圖 6-4 注冊(cè)圖 4登錄功能測(cè)試：該測(cè)試的目的是保證登錄窗口的正確性與在錯(cuò)誤發(fā)生時(shí)的容錯(cuò)與糾錯(cuò)性。通過(guò)在登錄框中輸入錯(cuò)誤的用戶(hù)密碼來(lái)檢測(cè)系統(tǒng)的出錯(cuò)運(yùn)行情況。要求系統(tǒng)在遇到這些情況時(shí)能給出正確的錯(cuò)誤提示。用戶(hù)在登錄成功后將根據(jù)不同的身份彈出不同的頁(yè)面。以賣(mài)家登錄為例，將比買(mǎi)家多一個(gè)管理功能，其中包括發(fā)布商品

16、，刪除商品及訂單管理。若輸入用戶(hù)名及密碼錯(cuò)誤則顯示（圖 6-5）：圖 6-5 登錄圖修改密碼功能測(cè)試：進(jìn)入修改密碼頁(yè)面，修改時(shí)若密碼輸入不同，則顯示（圖 6-6）：圖 6-6 密碼修改圖 1輸入一致則顯示（圖 6-7）：圖 6-7 密碼修改圖 2查詢(xún)功能測(cè)試：在搜索欄中輸入所要查詢(xún)商品的名稱(chēng)（圖 6-8） ，點(diǎn)擊快速搜索：圖 6-8 查詢(xún)圖 1查詢(xún)結(jié)果（圖 6-9）：圖 6-9 查詢(xún)圖 2若輸入不存在商品的名稱(chēng)則顯示（圖 6-10）：圖 6-10 查詢(xún)圖 3購(gòu)買(mǎi)功能測(cè)試：買(mǎi)家登錄成功后首先對(duì)商品進(jìn)行瀏覽或查詢(xún)，選定之后將進(jìn)行購(gòu)買(mǎi)。點(diǎn)擊購(gòu)買(mǎi)后顯示（圖 6-11）：圖 6-11 購(gòu)買(mǎi)圖 1購(gòu)物車(chē)測(cè)

17、試：買(mǎi)家在點(diǎn)擊購(gòu)買(mǎi)后查看購(gòu)物車(chē)出現(xiàn)如下界面（圖 6-12）：圖 6-12 購(gòu)買(mǎi)圖 2點(diǎn)擊“去結(jié)帳”后出現(xiàn)（圖 6-13）：圖 6-13 購(gòu)買(mǎi)圖 3買(mǎi)家點(diǎn)擊“確定購(gòu)買(mǎi)”后，訂單便自動(dòng)向系統(tǒng)提交上去。訂單管理測(cè)試：賣(mài)家登錄后查看屬于自己的訂單信息（圖 6-14）：圖 6-14 訂單圖 1點(diǎn)擊“刪除”后出現(xiàn)（圖 6-15）：圖 6-15 訂單圖 2管理員通過(guò)專(zhuān)門(mén)頁(yè)面使用管理員帳號(hào)和密碼進(jìn)入后臺(tái)管理首頁(yè)進(jìn)行系統(tǒng)的管理操作。由于管理員功能與用戶(hù)功能有部分重復(fù)，所以在這里就不再介紹。分類(lèi)管理測(cè)試：該功能為添加及刪除兩個(gè)部分。添加分類(lèi)（圖 6-16）：圖 6-16 分類(lèi)圖 1提交之后顯示（圖 6-17）：圖

18、 6-17 分類(lèi)圖 2用戶(hù)管理測(cè)試：點(diǎn)擊用戶(hù)管理可查看所有用戶(hù)并進(jìn)行刪除操作（圖 6-18）：圖 6-18 用戶(hù)管理圖 1點(diǎn)擊“刪除”對(duì)相應(yīng)對(duì)象進(jìn)行處理，如刪除用戶(hù)“劉暢宇” （圖 6-19）：圖 6-19 用戶(hù)管理圖 22.42.4測(cè)試結(jié)果測(cè)試結(jié)果本次測(cè)試通過(guò)模擬一次完整的交易過(guò)程，測(cè)試范圍包括用戶(hù)的注冊(cè)、登錄、密碼管理，商品的發(fā)布、查詢(xún)、刪除等，并且對(duì)了系統(tǒng)后臺(tái)的管理功能進(jìn)行了測(cè)試。測(cè)試結(jié)果顯示系統(tǒng)基本能夠?qū)崿F(xiàn)預(yù)期的功能，能夠提供用戶(hù)對(duì)商品信息的實(shí)時(shí)發(fā)布和查詢(xún)，提供了一個(gè)簡(jiǎn)單的網(wǎng)上二手商品交易管理系統(tǒng)。但是部分功能仍舊需要加強(qiáng)或者改進(jìn)，如商品的分類(lèi)管理不夠詳盡，沒(méi)有實(shí)現(xiàn)對(duì)訂單的高效率管理，

19、商品信息的內(nèi)容發(fā)布不夠規(guī)范等。emloyment tribunals sort out disagreements between employers and employees. you may need to make a claim to an employment tribunal if: you dont agree with the disciplinary action your employer has taken against you your employer dismisses you and you think that you have been dismissed

20、 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 under an oath or affirmation. most people find making a claim to an emplo

21、yment 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 dismissal, see dismissal. you can make a claim to an employment tribunal, even i

22、f you havent 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 to appeal. remember that in most cases you must make an application to an employment tribunal

23、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 how the time limits apply to you if you are being represented by a solicitor at the tribunal, the

24、y 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 cant charge you more than 35% of your compensation if you win the case. you are clear about the terms of the agree

25、ment. 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 on nearest cab. for more information about making a claim to an employment tribunal, see employment tribunals. the (

26、lack of) air up there watch m cay man islands-based webb, the head of fifas anti-racism taskforce, is in london for the football associations 150th anniversary celebrations and will attend citys premier league match at chelsea on sunday. i am going to be at the match tomorrow and i have asked to mee

27、t ya ya toure, he told bbc sport. for me its about how he felt and i would like to speak to him first to find out what his experience was. uefa has opened disciplinary proceedings against cska for the racist behaviour of their fans during citys 2-1 win. michel platini, president of european football

28、s governing body, has also ordered an immediate investigation into the referees actions. cska said they were surprised and disappointed by toures 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

29、 guilty in his seems to passing a lot of different life became 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 someth

30、ing. twenty years of life trajectory deeply shallow, suddenly feel something, do it.一字開(kāi)頭的年齡已經(jīng)到了尾聲?；蛟S是愧疚于自己似乎把轉(zhuǎn)瞬即逝的很多個(gè)不同的日子過(guò)成了同一天的樣子；或許是追溯過(guò)去，對(duì)自己那些近乎偏執(zhí)的怪異信念的醒悟，這些天以來(lái)，思緒一直很凌亂，在腦海中不斷糾纏?？傆X(jué)得自己似乎應(yīng)該去做點(diǎn)什么，或者寫(xiě)點(diǎn)什么。二十年的人生軌跡深深淺淺，突然就感覺(jué)到有些事情，非做不可了。the end of our life, and can meet many things really do?而窮盡我們的一生，又能

31、遇到多少事情是真正地非做不可？ during my childhood, think lucky money and 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

32、later, his writing of alumni in peace, suddenly found that isnt really grow up, it seems is not so important; then in high school, think dont 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

33、in the throat, later again stood on the pitch he has sweat profusely, looked at his thrown a basketball hoops, suddenly found himself has already cant remember his appearance. baumgartner the disappointing news: mission aborted. r plays an important role in this mission. starting at the ground, cond

34、itions have to be very calm - winds less than 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 eve

35、rest (5.5 miles/8.85 kilometers), drifting even 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, we let it drive us deeper into ourselves. we try to deflect the hurt and pain by pretending it doesnt exist, but although we can try this all we want, in the end, we cant hide