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

2、交易正常有效進(jìn)行。論文共分為 6 個(gè)章節(jié)，第一章對(duì)當(dāng)前背景與國內(nèi)外現(xiàn)狀進(jìn)行分析：第二章對(duì)數(shù)據(jù)庫技術(shù)等進(jìn)行簡單介紹；第三章對(duì)需求進(jìn)行分析并提出解決方案；第四章是系統(tǒng)的設(shè)計(jì)過程介紹；第五章對(duì)本系統(tǒng)進(jìn)行測試并得出結(jié)果。關(guān)鍵詞關(guān)鍵詞：二手商品；交易管理；用戶管理；商品管理；用戶權(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目目 錄錄 論文頁數(shù)：25 頁1引言.11.1課題背景.11.2開發(fā)現(xiàn)狀分析.11.3課題開發(fā)意義.12理論基礎(chǔ).22.1數(shù)據(jù)庫技術(shù).22.2b/s 架構(gòu)的 web 程序設(shè)計(jì)技術(shù) .32.2.1b/s 模式 .32.2.2asp 簡介 .42.2.3iis 簡介 .43需求分析.53.1現(xiàn)行業(yè)務(wù)系統(tǒng)描述.53.2現(xiàn)行系統(tǒng)存在的主要問題的分析.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ù)庫設(shè)計(jì).85系統(tǒng)功能設(shè)計(jì)與實(shí)現(xiàn).105.1注冊(cè).105.2登錄.125.3修改密碼.135.4查詢.145.5添加、刪除商品.155.6用戶管理.166系統(tǒng)測試.176.1測試方法.176.2測試環(huán)境.176.3測試過程.176.4測試結(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)的功能上來分析，本設(shè)計(jì)是基于 web 的二手商品交易管理系統(tǒng)，其核心是提供一個(gè)賣家發(fā)布、管理商品，買家查詢購買商品的交易平臺(tái)，本設(shè)計(jì)著重點(diǎn)是商品信息的發(fā)布

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

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

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

13、、刪除商品圖 5-5 添加商品圖在賣家登錄后，可行使發(fā)布商品的權(quán)限。其主要代碼如下：刪除商品（圖 5-6）：圖 5-6 商品刪除圖刪除自己發(fā)布的商品也是賣家對(duì)商品進(jìn)行管理的功能中不可缺少的。其主要代碼如下：1.71.7 用戶管理用戶管理用戶管理頁面設(shè)計(jì)如圖（5-7）所示：圖 5-7 用戶管理圖后臺(tái)管理中最主要的功能之一便是對(duì)所有用戶進(jìn)行管理，管理員有刪除用戶等權(quán)限。部分代碼如下： /操作結(jié)束后回到當(dāng)前頁面2 2系統(tǒng)測試系統(tǒng)測試2.12.1測試方法測試方法經(jīng)過系統(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)送行測試和排錯(cuò)，保證系統(tǒng)符合預(yù)定的要求。獲得一個(gè)無錯(cuò)的系統(tǒng)實(shí)現(xiàn)，調(diào)試的結(jié)果將確認(rèn)所完成的系統(tǒng)可以真正使用。測試方法上使用以界面為基礎(chǔ)的測試。以界面為基礎(chǔ)的測試僅僅依靠軟件與其運(yùn)行環(huán)境之間的接口來選擇和產(chǎn)生測試資料，而不管軟件的具體需求和具體實(shí)現(xiàn)細(xì)節(jié)。2.22.2測試環(huán)境測試環(huán)境計(jì)算機(jī)配置：賽揚(yáng) 4 1g 256m 內(nèi)存操作系統(tǒng)：windows 2000/xp/2003服務(wù)器組件：iis 5.0 以上版本 數(shù)據(jù)庫類型：microsoft sql server 20002.32.3測試過程測試過程為說明本系統(tǒng)功能的完整性，在測試中模擬一次完整的交易過程來體現(xiàn)。注冊(cè)功能測試：系統(tǒng)對(duì)用戶進(jìn)行區(qū)

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

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

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

18、 6-17 分類圖 2用戶管理測試：點(diǎn)擊用戶管理可查看所有用戶并進(jìn)行刪除操作（圖 6-18）：圖 6-18 用戶管理圖 1點(diǎn)擊“刪除”對(duì)相應(yīng)對(duì)象進(jìn)行處理，如刪除用戶“劉暢宇” （圖 6-19）：圖 6-19 用戶管理圖 22.42.4測試結(jié)果測試結(jié)果本次測試通過模擬一次完整的交易過程，測試范圍包括用戶的注冊(cè)、登錄、密碼管理，商品的發(fā)布、查詢、刪除等，并且對(duì)了系統(tǒng)后臺(tái)的管理功能進(jìn)行了測試。測試結(jié)果顯示系統(tǒng)基本能夠?qū)崿F(xiàn)預(yù)期的功能，能夠提供用戶對(duì)商品信息的實(shí)時(shí)發(fā)布和查詢，提供了一個(gè)簡單的網(wǎng)上二手商品交易管理系統(tǒng)。但是部分功能仍舊需要加強(qiáng)或者改進(jìn)，如商品的分類管理不夠詳盡，沒有實(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.一字開頭的年齡已經(jīng)到了尾聲?；蛟S是愧疚于自己似乎把轉(zhuǎn)瞬即逝的很多個(gè)不同的日子過成了同一天的樣子；或許是追溯過去，對(duì)自己那些近乎偏執(zhí)的怪異信念的醒悟，這些天以來，思緒一直很凌亂，在腦海中不斷糾纏?？傆X得自己似乎應(yīng)該去做點(diǎn)什么，或者寫點(diǎn)什么。二十年的人生軌跡深深淺淺，突然就感覺到有些事情，非做不可了。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