【正文】
Pet supplies sales。 etc. The administrator can by the query user information, order management, inventory management, check the user message etc function to the system maintenance and update and perfect. Thus pleting a humanization, individuation, modernization of emerce sites. This paper includes introduction, requirement analysis, system analysis, system detailed design four most, makes every effort to make the system more humanization, thus can fully satisfy operational the user39。5 【參考文獻(xiàn)】[1] 薩師煊.?dāng)?shù)據(jù)庫系統(tǒng)概論[M].北京:高等教育出版社,2000:222224.[2] 王慶育.軟件工程[M].北京:清華大學(xué)出版社,2005:187189.[3] 雍俊海.Java程序設(shè)計[M].北京:清華大學(xué)出版社,2004:13.[4] 楊鯤鵬 + SQL Server動態(tài)網(wǎng)站開發(fā)從基礎(chǔ)到實踐 [M].北京 : 電子工業(yè)出版社, 200501[5] 程序設(shè)計[M].北京 : 清華大學(xué)出版社, 2004[6] [M].北京 : 人民郵電出版社, 200301[7] 王潤森 [M].北京 : 人民郵電出版社, 2007[8] 付 編程實作教程[M].北京 : 北京希望電子出版社, 2002[9] 東名 動態(tài)網(wǎng)頁設(shè)計高手[M].北京 : 清華大學(xué)出版社, 2001[10] [M].北京 : 清華大學(xué)出版社, 200604Based on WEB campus transaction platform analysis and designBaiDanFengComputer science college of puter science and technology 07154016【Abstract】 As the network technology and related electronic technology rapid development and popularization, based on ebusiness enterprise in increasing all the time. Use the Internet business, carries on the network marketing activities have bee fashion, but also the modern enterprises to participate in the international petition of one of the most important instruments. With the current improvement of people39。但是由于能力有限,所以系統(tǒng)中還有許多不盡如人意的地方,比如付款方式人工化,不夠方便。經(jīng)過幾個月的學(xué)習(xí)、設(shè)計和開發(fā),基于WEB的校園交易平臺系統(tǒng)基本開發(fā)完畢。留言(message)信息表如表7所示。表6管理員信息表列名數(shù)據(jù)類型長度允許空說明adminidInt4否管理員IDadminname Varchar255否管理員姓名adminpassword Varchar255否管理員密碼roleVarchar255否身份(7) 留言信息表留言信息表記錄客戶對商城的留言信息。表5進(jìn)貨信息表列名數(shù)據(jù)類型長度允許空說明purchaseidInt4否進(jìn)貨IDproductidInt4是商品IDpurchasepriceint11是進(jìn)貨價格purchasetimedate9是進(jìn)貨時間purchasequantityint11是數(shù)量(6) 管理員信息表管理員信息表記錄管理員的密碼、權(quán)限等信息。本表以purchaseId、productId作為聯(lián)合主鍵。訂單狀態(tài)(orderstatus)信息表如表4所示。表3 訂單信息表列名數(shù)據(jù)類型長度允許空說明orderidint4否訂單IDuseridint4否用戶IDproductidint4否商品IDquantityint11否數(shù)量allcostint11否花費orderdatedate9否時間orderstatusint4否訂單狀態(tài)(4) 訂單狀態(tài)訂單狀態(tài)表記錄訂單的