【正文】 圖 41 實(shí)體間的關(guān)系ER圖 用戶(hù) 購(gòu)買(mǎi) 商品 N M N 1 1 N 管理員 帳號(hào) 姓名 密碼 圖 42 管理員信息實(shí)體 ER 圖 注冊(cè)用戶(hù) 會(huì)員帳號(hào) 姓名 密碼 地址 ...... 圖 43 注冊(cè)用戶(hù)信息實(shí)體 ER圖 畢業(yè)設(shè)計(jì)（論文） 27 / 48 實(shí)體 ER 圖如圖 44 所示： 類(lèi)型實(shí)體 ER 圖如圖 45 所示： 定單詳細(xì)信息實(shí)體 ER 圖如圖 46 所示： ...... 商 品 信息 編號(hào) 名稱(chēng) 原價(jià) 現(xiàn)價(jià) 圖 44 圖書(shū)實(shí)體ER圖 商 品 類(lèi)型 類(lèi)型編號(hào) 類(lèi)型名稱(chēng) 添加時(shí)間 圖 45 汽車(chē) 類(lèi)型實(shí)體 ER圖 定單詳細(xì)信息 編號(hào) 所屬定單列表 購(gòu)買(mǎi)商品 購(gòu)買(mǎi)數(shù)量 圖 46 定單詳細(xì)信息實(shí)體 ER圖 畢業(yè)設(shè)計(jì)（論文） 28 / 48 定單列表實(shí)體 ER 圖如圖 47 所示： 數(shù)據(jù)庫(kù)邏輯結(jié)構(gòu)設(shè)計(jì) 數(shù)據(jù)庫(kù)的概念結(jié)構(gòu)設(shè)計(jì)完畢后，現(xiàn)在可以將上面的數(shù)據(jù)庫(kù)概念結(jié)構(gòu)轉(zhuǎn)化為某種數(shù)據(jù)庫(kù)系統(tǒng)所支持的實(shí)際數(shù)據(jù)庫(kù)模型，也就是數(shù)據(jù)庫(kù)的邏輯結(jié)構(gòu)。每個(gè)表格表示在數(shù)據(jù)庫(kù)中的一個(gè)表。 表 1 管理員信息表（ allusers） 表 2 為會(huì)員信息表，記錄系統(tǒng)中注冊(cè)用戶(hù)的詳細(xì)信息。 表 3 產(chǎn)品信息表（ allPro） 表 4 為產(chǎn)品類(lèi)別信息表，記錄系統(tǒng)中的類(lèi)別信息。 表 5 定單詳細(xì)信息表（ dtproperties） 畢業(yè)設(shè)計(jì)（論文） 30 / 48 畢業(yè)設(shè)計(jì)（論文） 31 / 48 第 六 章 電子商務(wù)網(wǎng)站 界面設(shè)計(jì) 6． 1 開(kāi)發(fā)環(huán)境簡(jiǎn)介 是 的一部分，作為戰(zhàn)略產(chǎn)品，它提供了一個(gè)統(tǒng)一的 Web 開(kāi)發(fā)模型，其中包括開(kāi)發(fā)人員生成企業(yè)級(jí) Web 應(yīng)用程序所需的各種服務(wù)。可以通過(guò)在現(xiàn)有 ASP 應(yīng)用程序中逐漸添加 功能，隨時(shí)增強(qiáng) ASP 應(yīng)用程序的功 能。另外，任何 應(yīng)用程序都可以使用整個(gè) .NET Framework。 可以無(wú)縫地與 WYSIWYG HTML 編輯器和 Microsoft Visual Studio .NET 一起工作。 微軟為 設(shè)計(jì)了這樣一些策略：易于寫(xiě)出結(jié)構(gòu)清晰的代碼、代碼易于重用和共享、可用編譯類(lèi)語(yǔ)言編寫(xiě)等等，目的是讓程序員更容易開(kāi)發(fā)出 Web 應(yīng)用，滿足計(jì)算向 Web 轉(zhuǎn)移的戰(zhàn)略需要。貫穿整個(gè) 的主題就是系統(tǒng)幫用戶(hù)做了大部分不重要的瑣碎的工作。 畢業(yè)設(shè)計(jì)（論文） 32 / 48 6． 2 系統(tǒng)界面的設(shè)計(jì) 首頁(yè)設(shè)計(jì) 此界面為 所有用戶(hù)的操作頁(yè)面，包括非注冊(cè)用戶(hù)、注冊(cè)會(huì)員、管理員，都可在此界面進(jìn)行信息瀏覽、查詢(xún)。 畢業(yè)設(shè)計(jì)（論文） 34 / 48 商品詳細(xì)信息界面的設(shè)計(jì) 界面的左邊是商品類(lèi)別、熱門(mén)產(chǎn)品及最優(yōu)惠產(chǎn)品列表，右邊則是用戶(hù)所點(diǎn)擊關(guān)注的商品的詳細(xì)信息。 購(gòu)物車(chē)界面的設(shè)計(jì) 當(dāng)用戶(hù)點(diǎn)擊“放入購(gòu)物車(chē)”的按鈕后，系統(tǒng)跳轉(zhuǎn)到購(gòu)物車(chē)界面： 畢業(yè)設(shè)計(jì)（論文） 35 / 48 該界面即為用戶(hù)選購(gòu)的所有商品的清單，包括商品編號(hào)、商品名稱(chēng)、每類(lèi)商品的價(jià)格及總價(jià)格。前者可返回購(gòu)物界面，后者則是前往購(gòu)物確認(rèn)。當(dāng)擁有合法身份的管理員在輸入正確的帳號(hào)及密碼后，進(jìn)入后臺(tái)管理系統(tǒng)。 商品類(lèi)別管理 界面設(shè)計(jì) 畢業(yè)設(shè)計(jì)（論文） 38 / 48 畢業(yè)設(shè)計(jì)（論文） 39 / 48 在此界面中，可以進(jìn)行關(guān)于商品類(lèi)別的添加管理操作。 訂單管理 界面設(shè)計(jì) 畢業(yè)設(shè)計(jì)（論文） 41 / 48 此界面的執(zhí)行結(jié)果，是列出所有記錄。 綜言上文，電子商務(wù)網(wǎng)站操作簡(jiǎn)約，流程清晰。 但是，隨著競(jìng)爭(zhēng)的進(jìn)一步升級(jí)和網(wǎng)絡(luò)技術(shù)及網(wǎng)絡(luò)營(yíng)銷(xiāo)手段的升級(jí)，本系統(tǒng)會(huì)有些落伍，所以，系統(tǒng)留有足夠的升級(jí)端口，以備日后系統(tǒng)升級(jí)。 NET 及 SQL2021 的基本知識(shí)和編程技巧，并在開(kāi)發(fā)過(guò)程中我的 ASP。如： SQL語(yǔ)言的使用；以前學(xué)過(guò)的軟件工程知識(shí)、數(shù)據(jù)庫(kù)原理及操作也得到了充分的應(yīng)用。我們?cè)谥珠_(kāi)發(fā)之前不要急于編程，先應(yīng)有較長(zhǎng)的時(shí)間去把分析做好，做好數(shù)據(jù)庫(kù)設(shè)計(jì)工作，寫(xiě)出相關(guān)的開(kāi)發(fā)文檔等。當(dāng)然也有些還需待繼續(xù)深入地方如： COM 技術(shù)等。主要是因?yàn)槠綍r(shí)很少接觸軟件開(kāi)發(fā)工作，盡管相關(guān)理論考試已經(jīng) 通過(guò)了，但在應(yīng)用方面缺乏經(jīng)驗(yàn)，如果及時(shí)得到老師或?qū)＜业闹更c(diǎn)，象這樣的系統(tǒng)開(kāi)發(fā)起來(lái)應(yīng)該還比較容易。 NET 課程設(shè)計(jì)與系統(tǒng)開(kāi)發(fā)案例》 .清華大學(xué)出版社 [2] 楊小平 .《 ASP。 NET 編程實(shí)用技術(shù)與案例 》 .清華大學(xué)出版社 [4] 鄭阿奇 .《 ASP。 NET+ SQL 2021 組建動(dòng)態(tài)網(wǎng)站 [M].北京：人民郵電出版社， 2021 年 8月第一版 畢業(yè)設(shè)計(jì)（論文） 44 / 48 he new army slippers. How nice my handkerchiefs look, don39。s gone and put `Mother39。. How funny! cried Jo, taking one up. Isn39。s initials are ., and I don39。, looking troubled. It39。s Mother. Hide the basket, quick! cried Jo, as a door slammed and steps sounded in the hall. Amy came in hastily, and looked rather abashed when she saw her sisters all waiting for her. Where have you been, and what are you hiding behind you? asked Meg, surprised to see, by her hood and cloak, that lazy Amy had been out so early. Don39。t mean anyone should know till the time came. I only meant to change the little bottle for a big one, and I gave all my money to get it, and I39。, while Beth ran to the window, and picked her finest rose to ornament the stately bottle. You see I felt ashamed of my present, after reading and talking about being good this morning, so I ran round the corner and changed it the minute I was up, and I39。m glad you began at once, and hope you will keep on. But I want to say one word before we sit down. Not far away from here lies a poor woman with a little newborn baby. Six children are huddled into one bed to keep from freezing, for they have no fire. There is nothing to eat over there, and the oldest boy came to tell me they were suffering hunger and cold. My girls, will you give them your breakfast as a Christmas present? They were all unusually hungry, having waited nearly an hour, and for a minute no one spoke, only a minute, for Jo exclaimed impetuously, I39。d do it, said Mrs. March, smiling as if satisfied. You shall all go and help me, and when we e back we will have bread and milk for breakfast, and make it up at dinnertime. They were soon ready, and the procession set out. Fortunately it was early, and they went through back streets, so few people saw them, and no one laughed at the queer party. A poor, bare, miserable room it was, with broken windows, no fire, ragged bedclothes, a sick mother, wailing baby, and a group of pale, hungry children cuddled under one old quilt, trying to keep warm. How the big eyes stared and the blue lips smiled as the girls went in. Ach, mein Gott! It is good angels e to us! said the poor woman, crying for joy. Funny angels in hoods and mittens, said Jo, and set them to laughing. In a few minutes it really did seem as if kind spirits had been at wor k there. Hannah, who had carried wood, made a fire, and stopped up the broken panes with old hats and her own cloa k. Mrs. March gave the mother tea and gruel, and forted her with promises of help, while she dressed the little baby as tenderly as if it had been her own. T he girls meantime spread the table, set the childre n round the fire, and fed them like so many hungry birds, laughing, talking, and trying to understand the funny broken English. Das ist gut! Die Engel kinder! cried the poor things as they ate and warmed their purple hands at the fortable blaze. T he girls had never been c alled angel children before, and thought it very agreeable, especially Jo, who had been considered a `Sancho39。t ge t any of it. And when they went away, leaving fort behind, I think there were not in all the city four merrier people than the hungry little girls who gave away their bre akfasts and contented themselves with bread and milk on Christmas morning. That39。, and her chief trouble was poverty. She found it harder to bear than the others because she could remember a time when home was beautiful, life full of ease and pl