分布式網(wǎng)吧銷售系統(tǒng) 任務(wù)書 開題報告

畢業(yè)設(shè)計任務(wù)書A1A0A2A3A6A4A5A7A10A8A12A9A11A15A5A16A13A14A17A20A18A19A21A20A18A19A21A22A23A24A25A26A27A28A29A30A31A32A33A34A35A29A36A37A38A39A27A40A30A31A41A42A43A44A45A46A47A48A49A50A51A43A44A52A53A54A55A49A56A43A57A58A59A60A27A40A61A62A63A64A65A66A42A67A64A68A69A70A62A63A64A60A71A72A73A74A75A76A77A73A74A75A77A78A79A66A42A67A64A70A80A81A82A83A75A84A85A73A74A86A87A69A88A89A75A88A89A82A83A90A91A92A93A94A70A87A69A62A63A64A65A66A42A67A64A49A82A83A95A96A97A75A98A99A100A101A102A103A104A67A95A80A66A42A67A64A105A106A107A108A46A109A110A111A112A49A50A113A43A44A60A114A115A116A117A118A119A120A121A122A123A122A124A125A126A119A123A127A128A129A130A125A127A131A119A122A132A133A133A134A112A135A136A137A138A139A140A92A93A94A141A117A123A142A129A132A133A133A133A143A132A115A116A117A138A139A136A137A75A144A145A146A107A147A148A149A143A150A115A151A152A153A30A31A75A144A145A109A117A97A154A45A143A155A156A157A158A159A46A101A160A161A162A65A43A44A60A163A164A45A60A114A114A165A134A166A167A114A165A114A168A166A169A170A30A31A75A87A69A171A172A47A48A163A164A108A60A114A165A114A168A166A167A114A114A165A132A173A166A87A69A136A31A174A175A163A164A159A60A114A114A165A132A173A166A167A114A132A165A114A176A166A87A69A30A31A49A47A48A138A112A163A164A177A60A114A132A165A114A176A166A167A114A132A165A150A114A166A87A69A54A55A178A179A163A164A180A60A114A132A165A150A114A166A167A114A165A114A150A166A87A69A54A55A181A182A88A163A164A183A60A132A165A132A114A166A167A150A165A155A166A184A185A171A172A186A187A188A189A190A191A192A193A194A188A189A190A56A41A52A195A196A59A197A165A166A27A198A191A192A193A194A34A199A27A56A41A52A195A196A59A197A165A166A200A201A188A202A52A195A196A59A197A165A166A203A204A205A206A207A208A209A210A211A209A212A213A214A215A210A211A209A216A217A218A219A220A210A211A209A221A222A223A224A225A226A227A228畢業(yè)設(shè)計開題報告專業(yè)計算機應(yīng)用姓名學(xué)號課題名稱分布式網(wǎng)吧銷售系統(tǒng)指導(dǎo)教師論文起止日期2010119至2011114一、引言11課題名稱分布式網(wǎng)吧銷售系統(tǒng)12開發(fā)目的現(xiàn)在的網(wǎng)吧已經(jīng)進入“毛利潤”時期，還是想靠每小時的上網(wǎng)費是不夠的，增值利潤已經(jīng)成為網(wǎng)吧不可缺少的收入，這就需要在網(wǎng)吧銷售商品來獲取利潤。用一句比較時髦的話來說，是開始做多元化經(jīng)營。多元化經(jīng)營原本是企業(yè)運營的一種戰(zhàn)略選擇，拿到網(wǎng)吧來講，就是為了方便上網(wǎng)顧客，為其提供點卡、充值、飲料、食品等方面的服務(wù)。13面向?qū)ο筢槍W(wǎng)吧商品銷售的難題，為網(wǎng)吧提供簡單便捷的銷售系統(tǒng)，增加網(wǎng)吧的利潤。14課題背景隨著網(wǎng)絡(luò)的發(fā)展和普及，上網(wǎng)已經(jīng)成為人們?nèi)粘Ｉ钪斜夭豢缮俚男蓍e活動，而網(wǎng)吧也隨G1055而G1147生。網(wǎng)吧G13485人們提供了一G1022開G6930而G14310G17878的上網(wǎng)G10627G3671，人們可G1209G19283時G19400的G2586在網(wǎng)吧G18336面G13854G3837，G1926G9022，G6183G9228G6115，G4410G1076。G12946G12082食G12930是G7389了，可是G10301G17148食G12930G2376G7509G5242缺G1059，G20281G13940G17772G17772G2460G5602G1052G14033G4445G5527上網(wǎng)G2614G731而G11458G2081G3835多G6980網(wǎng)吧G2494提供一G1135G11731G8861G8712，G5194不G14033G16311G1927顧客這方面的G19394題。G1516G14521網(wǎng)吧在提供上網(wǎng)的G2528時可G1209G7389一G1135食品和飲料銷售的話，不G1177可G1209G16765顧客上的G4445G5527，G10621的開G5527，還可G1209增加G6980G18339可G16278的G20081G3818收入，G2528時G14310G17878而G17160G5527的上網(wǎng)G10627G3671G2460可G1209G2572G5353G7368多的顧客，G11507是一G1042G1016G5483。分布式網(wǎng)吧商品銷售系統(tǒng)就是為了G18209G2524這一G5078G3342需G8726而開發(fā)的G17731G1226，簡單G7143用G1319G17160用G6155是本系統(tǒng)的G1039要G10317點。上網(wǎng)的顧客G2494需點一G991G5760G9026在G7712面上的G6365G19074就可G1209G6373選G14270G5061需要的商品，發(fā)G1998G16843G8726G2530服務(wù)G3132G2375可收到G1461G5699，G6238商品G17877到，G13489對方便G5567捷。G3二、項目概述21系統(tǒng)需求分析本系統(tǒng)G7389一G1022較G3921的展G12046G5191G2500，不G1177對網(wǎng)吧G2520G12879商品進G15904了分G12879，G5194G1000每一G1226商品G18129G7389G11468G5224的G3282G10267和較為G16826G13466的G1183G13473，方便客G6155了G16311G2520G12879商品G1461G5699和G1227G7696。如果客G6155G7389意購買我們的商品，可G1209通過系統(tǒng)發(fā)G17877G1461G5699購買。當(dāng)服務(wù)G3132端接收到G1461G5699G2530由網(wǎng)管遞G17877商品G5194收現(xiàn)金結(jié)賬。G322系統(tǒng)構(gòu)架圖本系統(tǒng)分為客G6155端和服務(wù)G3132端客G6155端可G1209查看商品G1461G5699選擇商品，加入購G10301車，購買商品；服務(wù)G3132端可G1209添加刪除商品，查看商品，紀錄銷售紀錄23主要功能本系統(tǒng)G1039要功G14033客G6155端點擊左面G3282標(biāo)G6183開客G6155系統(tǒng)，瀏覽商品，選擇商品，加入購G10301車，點擊購買。服務(wù)G3132端管理員登陸；添加商品分G12879，選著分G12879，添加商品G1461G5699?？虶6155機發(fā)G1998G1461G5699G2530，G1461G5699G9026動提G12046，由網(wǎng)管遞G17877商品，收取現(xiàn)金G2530，返回服務(wù)G3132端結(jié)算，銷售記錄紀錄進入G6980據(jù)庫，供查看；管理員表管理員表用來存儲管理員G1461G5699，用作服務(wù)G3132端登陸；添加修改刪除商品G1461G5699，管理服務(wù)G3132端G6980據(jù)；表11ADMIN字段名稱G3字段G12879型G3字段G3835小G3是否為空G3說明G3ADMINIDG3G14270動編號G3G19283整型G3否G3編號G3ADMINNAMEG3VARCHARG350G3否G3賬號G3ADMINPASSG3VARCHARG320G3否G3密碼G3ADMINXMG3文本G350G3否G3管理員姓名G3A229A230A231A232A233A234A235A236A237A238A239A240A241A242A243A240A244A245A246A247A248A249A248A249A250A246A247A248A249A251A252A253A254A248A249A244A245A255A1A248A249A244A245A246A247A0A2A16A3A4A5A6A4A7商品G1461G5699表商品G1461G5699表用來存儲商品G1461G5699，表12GOODS購G10301車表購G10301車表用來存儲添加進購G10301車的商品表13SHOP_CAR商品G12879別表商品G12879別表用來分G12879商品G12879別，方便顧客分G12879查看商品表15GOODS_LB銷售總表銷售總表用來存儲銷售過的商品G6980G18339G1227錢G1461G5699表14SELL字段名稱G3字段G12879型G3字段G3835小G3是否為空G3說明G3GOODSIDG3G14270動編號G3G19283整型G3否G3編號G3GOODSNAMEG3VARCHARG350G3否G3商品名稱G3GOODSPRICEG3DOUBLEG3G3否G3商品G1227G7696G3GOODSPICG3VARCHARG350G3否G3商品G3282G10267G3GOODSINTRG3VARCHAR50G3是G3備注G3GOODSINUMG3INT4G3否G3商品庫存G3字段名稱G3字段G12879型G3字段G3835小G3是否為空G3說明G3SH_IDG3G14270動編號G3G19283整型G3否G3編號G3SH_NAMEG3VARCHARG350G3否G3商品名稱G3SH_PRICEG3DOUBLEG3G3否G3商品G1227G7696G3SH_PICG3VARCHARG350G3否G3商品G3282G10267G3SH_NUMG3INT4G3否G3商品G6980G18339G3字段名稱G3字段G12879型G3字段G3835小G3是否為空G3說明G3IDG3G14270動編號G3G19283整型G3否G3編號G3LB_NAMEG3VARCHARG350G3否G3G12879別名稱G3銷售明G13466表銷售明G13466表用來存儲銷售過的商品G16826G13466G1461G5699表14SELL_LIST三、實施方案31系統(tǒng)設(shè)計方案分析C/S（CLIENT/SERVER）結(jié)構(gòu)，G2375客G6155機和服務(wù)G3132結(jié)構(gòu)。它是G17731G1226系統(tǒng)G1319系結(jié)構(gòu)，通過它可G1209充分利用G1016端硬G1226G10627G3671的優(yōu)勢，將任務(wù)G2524理分G18209到CLIENT端和SERVER端來實現(xiàn)，降低了系統(tǒng)的通訊開銷。G11458G2081G3835多G6980G5224用G17731G1226系G3統(tǒng)G18129是CLIENT/SERVER形式的G1016層結(jié)構(gòu)，由于現(xiàn)在的G17731G1226G5224用系統(tǒng)正在向分布式的WEBG5224用發(fā)展，WEB和CLIENT/SERVERG5224用G18129可G1209進G15904G2528樣的業(yè)務(wù)處理，G5224用不G2528的模塊共享邏輯組G1226；因此，G1881G18108的和G3818G18108的用G6155G18129可G1209G16787G19394G7044的和現(xiàn)G7389的G5224用系統(tǒng)，通過現(xiàn)G7389G5224用系統(tǒng)中的邏輯可G1209G6205展G1998G7044的G5224用系統(tǒng)。這也就是G11458G2081G5224用系統(tǒng)的發(fā)展方向。G3G1268統(tǒng)的CG715SG1319系結(jié)構(gòu)G15441G9994G18331用的是開G6930模式，G1306這G2494是系統(tǒng)開發(fā)一G13435的開G6930G5627，在G10317G4462的G5224用中G7092G16782是CLIENT端還是SERVER端G18129還需要G10317G4462的G17731G1226G6915G6357。字段名稱G3字段G12879型G3字段G3835小G3是否為空G3說明G3S_IDG3G14270動編號G3G19283整型G3否G3銷售單號G3S_GOODSPRICEG3DOUBLEG3G3否G3商品總G1227G7696G3S_GOODSNUMG3INTG34G3否G3商品總G6980G18339G3S_TIMEG3DATATIMEG3否G3商品銷售時G19400G3S_PEOPLEG3VARCHAR20G3否G3經(jīng)G6175人G3S_G77IEG93ANGG3INT4G3否G3是否結(jié)賬G3字段名稱G3字段G12879型G3字段G3835小G3是否為空G3說明G3SEL_IDG3G14270動編號G3G19283整型G3否G3編號G3LISTIDG3INTG34G3否G3銷售單號G3SEL_GOODSNAMEG3VARCHARG350G3否G3商品名稱G3SEL_GOODSPRICEG3DOUBLEG3G3否G3商品G1227G7696G3SEL_GOODSNUMG3INTG350G3否G3商品G6980G18339G3由于G8821G14033提供用G6155G11507正期G7407的開G6930G10627G3671，C/S結(jié)構(gòu)的G17731G1226需要針對不G2528的G6817作系統(tǒng)系統(tǒng)開發(fā)不G2528G10268本的G17731G1226，加G1055G1147品的G7368G7044G6454G1207G2325分G5567，已經(jīng)G5468難G17878G5224G11346G2500G11017G14053G1209上G4628G3507網(wǎng)用G6155G2528時G1363用。而G1000G1207G1227G20652，G6940G10587低G332開發(fā)平臺及運行環(huán)境G6817作系統(tǒng)本系統(tǒng)是在G48ICROSOG73TG3WINDOG90SG59G51G6817作系統(tǒng)G991開發(fā)G4448成的。開發(fā)G5049G1867G48ICROSOG73TG3SG52LG3SERVER2000、G48ICROSOG73TG3G57ISUALG3STUDIOG32005G3運G15904G10627G3671本系統(tǒng)運G15904于WINDOG90S2000和G59G51G6817作系統(tǒng)G991四、實施計劃G20、2010G519211G738815日19日G3G3G3G1946備G17176料，選G1946G16850題，查G6226G16850題G16786G16757的G11468G1863G17176料，G4448成G8617業(yè)G16786G16757任務(wù)G1082。G32、2010G519211G738826日G2081G3G3G3查G6226G17331G16850題G7389G1863的G17176料，整理G17176料G4448成開題G6265G2590。G32010G519212G73883日G2081G3G3G3G6363G4560G13781G5084統(tǒng)一將G457開題G6265G2590G458G11017G4388G12307及G6183G2372G12307G1144系G2162，G5194上G6265開題G6265G2590成G13501G3G22、2010G519212G738817日G2081G3G3G3將G8617業(yè)G16786G16757G1144G13485G6363G4560G13781G5084，G6363G4560G13781G5084對G4410生進G15904中期G7828查，G11575G1431和G5122G2173G4448成較G5058的G4410生G12227G7509的改進，G5194上G6265中期G7828查成G13501G34、2010G519212G738831日G1055G2081G3G3G3G4448成G16850題的G16786G16757G2033G12307，開始G16782文G6788G1901G35、2011G51921G738813日G1055G2081G3G3G3G16782文G6788G1901、G1144G2033G12307G13485G6363G4560G13781G5084；G6363G4560G13781G5084G6363G4560G4410生修改G16782文，G1363G16782文G7696式G16280G14551，G1881G4493G4448整正G11842。G3G25、2011G51921G738814日G1055G2081G3G3G3G16782文G4462G12307、G6183G2372，G16786G16757成果G11G2265G6336G16782文G11017G4388G12307及G6183G2372G12307G2520一G1233、G16786G16757實G19481成果等G12上G1144系G2162G3G26、2011G51922G738821日3G73884日G3G3G3G1946備G12584G17789G3五、參考文獻A8A17A18A19A9A10A22A23A11A12A26A27A13A29A14A15A32A33A14A15A34A20A21A24A25A28A30A31A35A36A37A38A39A40A41A42A43A32A44A45A51A46A47A26A54A55A48A49A50A52A53A56A56A61A22A57A58A58A59A26A58A17A8A57A18A67A60A62A26A70A63A29A14A15A72A33A14A15A73A64A41A65A66A68A69A39A40A71A74A51A75A47A82A76A36A50A53A56A22A57A58A58A58A26A57A8A84A18A85A77A78A22A88A79A26A27A13A29A