【正文】 ............................... 9 系統(tǒng)數(shù)據(jù)庫設(shè) 計(jì) ..................................................... 12 數(shù)據(jù)庫表及各表的相互關(guān)系 ....................................... 12 數(shù)據(jù)庫表結(jié)構(gòu)的詳細(xì)設(shè)計(jì) ......................................... 13 4 系統(tǒng)的設(shè)計(jì)與實(shí)施 ...................................................... 14 系統(tǒng)總體設(shè)計(jì)框架 ................................................... 14 公共庫函數(shù) ..................................................... 14 公共設(shè)置參數(shù) .................................................... 15 商品瀏覽模塊 ...................................................... 16 用戶登錄模塊 ...................................................... 17 購物車模塊 ........................................................ 18 商品管理模塊 ...................................................... 21 訂單管理模塊 ...................................................... 21 5 系統(tǒng)測試 .............................................................. 22 功能性測試 ........................................................ 22 安全性測試 ........................................................ 22 結(jié) 論 .................................................................. 23 參考文獻(xiàn) .................................................................. 24 致 謝 .................................................................. 25 聲 明 .................................................................. 26 第 1 頁 共 26 頁 1 引言 課題背景 在當(dāng)今的 Inter 時(shí)代，電子商務(wù)發(fā)展日新月異，它已成為商業(yè)系統(tǒng)不可缺少的一部分。電子商務(wù)提出了一種全新的商業(yè)機(jī)會(huì)、需求、規(guī)劃和挑戰(zhàn)，正是新世紀(jì)全球經(jīng)濟(jì)與社會(huì)發(fā)展的朝陽領(lǐng)域。 本課題的研究方法 根據(jù)客戶購買書籍的實(shí)際流程設(shè)計(jì)整個(gè)系統(tǒng)的購物流程，以穩(wěn)定性、實(shí)用性、安全性為總體原則。 3．友好性原則：使用網(wǎng)上圖書銷售管理系統(tǒng)的用戶中相當(dāng)一部分對計(jì)算機(jī)知識了解很少，所以系統(tǒng)操作上要求簡單方便，便于用戶掌握。該子系統(tǒng)通過簡潔而明晰的 Web 頁面， 提示管理員進(jìn)行各項(xiàng)管理工作。 第 5 頁 共 26 頁 B/S 三層結(jié)構(gòu)模式 采用 B/S 模式構(gòu)架應(yīng)用系統(tǒng)網(wǎng)絡(luò)，即 采用三層體系結(jié)構(gòu) (如圖 23)：由瀏覽器替代客戶端 (Client)，服務(wù)器端由 Web 服務(wù)器、數(shù)據(jù)庫系統(tǒng)服務(wù)器及中間件組成。它的任務(wù)是接受 Web 服務(wù)器對數(shù)據(jù)庫操作的請求，實(shí)現(xiàn)對數(shù)據(jù)庫查詢、修改、更新等功能，把運(yùn)行結(jié)果提交給 Web 服務(wù)器。 SQL Server 甚至還可以實(shí)現(xiàn)服務(wù)器間通過 Inter 進(jìn)行數(shù)據(jù)復(fù)制。 第 7 頁 共 26 頁 3 系統(tǒng)規(guī)劃與設(shè)計(jì) 系統(tǒng)流程簡述 顧客在進(jìn)入本系統(tǒng)后，首先進(jìn)入的是系統(tǒng)的首頁。 圖 31 客戶端模塊圖 購物車 用戶登陸判斷 服務(wù)臺 生成訂單 用戶登錄 /注冊 Y N 第 8 頁 共 26 頁 圖 32 管理端模塊圖 根據(jù) 節(jié)的系統(tǒng)流程描述和本節(jié)根據(jù)上述描述做出的流程圖，就可以將系統(tǒng)劃分為以下一些模塊，如表 31所示。字符串處理，數(shù)據(jù)傳遞接受函數(shù)等。database=shop 折扣價(jià)格 : const discountPrice= 分頁顯示每頁的條目數(shù) : const MaxPerPage =5 存儲上載圖片的路徑 : Const sPath_Info = /img/ 其中 strcon 常量是設(shè)置數(shù)據(jù)的，當(dāng)設(shè)好 ODBC 后應(yīng)直接修改次參數(shù)來完成； 第 16 頁 共 26 頁 MaxPerPage 常量是設(shè)置每頁顯示數(shù)據(jù)的，默認(rèn)為 5； sPath_Info 為上傳圖片的目錄。 系統(tǒng)一般使用 Session 來存儲用戶的相關(guān)信息并與客戶端保持聯(lián)系。在系統(tǒng)里設(shè)置了 4 個(gè)參數(shù)，分別對購物車的 4 個(gè)操作對應(yīng)。查對購物車中是否已經(jīng)有此物品 If sItemId=sItemA(i) Then sNowItemAIndex=i 第 20 頁 共 26 頁 Exit For End If Next If sNowItemAIndex And sNowItemAIndex=0 Then 39。 End If ElseIf cint(sItemAindex)=1 then 39。 圖 45 購物車 訂單管理模塊 訂單管理模塊是后臺管理的另一個(gè)重要模塊，包括訂單列表頁，訂單確定設(shè)置，訂單發(fā)送設(shè)置、訂單查看和訂單刪除等功能。 3． Cookies 測試 對于要求使用 Cookies 的 Web、應(yīng)用程序，測試用戶是否啟用 Cookies，啟用 Cookies 后是否正常工作， Cookies 過期，刷新對 Cookies 有何 影響。例如用戶訪問數(shù)據(jù)庫的權(quán)利是否過大，是否允許用戶執(zhí)行有權(quán)限限制的存儲程序。參考貝塔斯曼、卓越網(wǎng)、淘寶網(wǎng)等較好的網(wǎng)上書店，吸取其精華為我所用，可以使系統(tǒng)的開發(fā)過程少走彎路。 [3] 萬峰科技 .ASP網(wǎng)站開發(fā)全書 [M].北京：電子工業(yè)出版社 ,2021。除非另有說明，本文的工作是原始性工作。t graduate from college, you won39。s just too risky. I asked him what he meant by old rules? . 第 27 頁 共 26 頁 People like me play by a different set of rules from what you play by, he said. What happens when a corporation announces a downsizing? People get laid off, I said. Families are hurt. Unemployment goes up. Yes, but what happens to the pany, in particular a public pany on the stock exchange? The price of the stoc k usually goes up w hen the downsizing is announced, I said. The market likes it when a pany reduces its labor costs, either through automation or just consolidating the labor force in general. That39。 A child today needs a more sophisticated education, and the current system is not delivering the goods. I don39。s book. I asked him how much financial information he thought a child needed. He said it would depend on the child. He knew at a young age that he wanted to be r ich and was fortuna te enough to have a father figure who was rich and willing to guide him. Education is the foundation of success, Robert said. Just as scholastic skills are vitally important, so are financial skills and munication skills. What follows is the story of Robert39。s developed over a lifetime. The contrast between two dads provides an important perspective. The book is supported, edited and assembled by me. For any accountants who read this book, suspend your academic book knowledge and open your mind to the theories Robert presents. Although many of them challenge the very fundamentals of generally accepted a ccounting principles, they provide a valuable insight into the way true investors analyze their investment decisions. When we as parents advise our children to go to school, study hard and get a good job, we often do that out of cultural habit. It has al ways been the right thing to do. When I met Robert, his ideas initially startled me. Having been raised by two fathers, he had been taught to strive for two different goals. H is educated dad advised him to wor k for a corporation. H is rich dad advised him to own the corporation. Both life paths required education, but the subjects of study were pletely different. His educated dad encouraged Robert to be a smart person. H is rich dad encouraged Robert to know how to hire smart people. Having two dads caused many problems. Robert39。t they get bored? And how do you teach investing when as a parent you yourself are risk averse? Instead of teaching my children to simply play it safe, I decided it was best to teach them to play it smart. So how would you teach a child about money and all the things we39。 owner s and investors win. Robert was describing not only the difference between an employee and employer, but also the difference betwe en controlling your own des