【正文】 ategoryorder2 轉(zhuǎn)化為 int 型再向表中添加記錄 rs(first)=int(request(first2)) 39。更新記錄 39。關(guān)閉記錄集 set rs=nothing 39。釋放資源 39。重定向到本頁面 case edit set rs=() 39。建立 recordset 對(duì)象 select * from category where categoryid=amp。categoryid,conn,1,3 rs(category)=trim(request(category)) rs(categoryorder)=int(request(categoryorder)) rs(first)=int(request(first)) 39。以上修改記錄 set rs=nothing case del (delete from category where categoryid=amp。categoryid) (delete from sorts where categoryid=amp。categoryid) (delete from product where categoryid=amp。categoryid) 39。以上刪除相關(guān)表里的記錄，先刪從表，再刪主表 39。重定向到 end select % 添 加小類效果圖如下圖 514 所示： 圖 514 添加小類 管理員添加新商品，管理員可以添加新商品，包括指定商品的分類，商品 第 20 頁 共 23 頁 的編碼等。界面如下圖 515 所示： 圖 515 添加新商品 管理員管理訂單，管理員可以查看訂單處理情況，并可以點(diǎn)擊訂單號(hào)對(duì)未處理的訂單進(jìn)行處理操作，包括刪除此訂單。界面如下圖 516 所示： 圖 516 訂單的處理 管理員對(duì)注冊(cè)會(huì)員管理，管理員可以點(diǎn)擊用戶名修改注冊(cè)會(huì)員資料，也可以刪除該用戶，以釋放更多空間。界面如下圖 517 所示： 圖 517 注冊(cè)會(huì)員管理 6 系統(tǒng)測試 系統(tǒng)完成后，注冊(cè)了用戶名為 aben 進(jìn)行測試，包括修改自己的個(gè)人資料、收貨資料，修改自己的密碼等。然后對(duì)商品購買進(jìn)行測試，包括選取商品，放入購物車，填寫訂單，生成訂單號(hào)碼后，進(jìn)入“我的訂單”修改訂單狀態(tài)，查看是否被處理。繼而用管理員帳號(hào) lyj 對(duì)后臺(tái)管理員管理模塊進(jìn)行測試，包括系統(tǒng)管理，商品分類，可以分為大類和小類，管理員可以添加新商品，并對(duì)已經(jīng)存在的商品進(jìn)行管理，包括刪除等。注冊(cè)會(huì)員管理，管理員可以修改注冊(cè)會(huì)員資料，刪除注冊(cè)會(huì)員等功 能。經(jīng)過測試后發(fā)現(xiàn)需求中的基本功能都可以實(shí)現(xiàn)。 第 21 頁 共 23 頁 結(jié) 論 本畢業(yè)設(shè)計(jì)采用 ASP，開發(fā)了一個(gè) B/S 模式的 網(wǎng)上商品銷售系統(tǒng)，后臺(tái)數(shù)據(jù)庫采用了 ACCESS 2021。 該網(wǎng)上商品銷售 系統(tǒng)主要實(shí)現(xiàn)了：用戶管理、商品購買、分類管理、商品添加管理、商品訂單管理、商品的查詢等網(wǎng)上商品銷售的基本功能。該系統(tǒng)具有功能健全，界面友好，操作簡單的特點(diǎn)，但也存在一些不足，比如： 界面美工技術(shù)還需加強(qiáng)； 在線支付問題未能解決；上傳商品較少。 參考文獻(xiàn) [1] 孫麗君 ,吳紅普 .ASP編程基礎(chǔ)及應(yīng)用實(shí)例集錦 [M].北京：人民郵電出版社 ,2021。 [2] 精英科技 .ASP核心技術(shù) [M].北京：中國電力出版社 ,2021。 [3] 陳可欣 .ACCESS VBA 數(shù)據(jù)庫高效開發(fā) [M].北京：中國青年出版社， 2021。 [4] 吉根林 .Web程序設(shè)計(jì) [M].北京：電子工業(yè)出版社 ,2021。 [5] Greg Buczek .即時(shí)響應(yīng) ASP腳本 [M].北京： 人民郵電出版社 ,2021。 [6] 趙增敏 .ASP動(dòng)態(tài)網(wǎng)頁設(shè)計(jì) [M].北京： 電子工業(yè)出版社 ， 2021。 [7] 宣小平 .ASP數(shù)據(jù)庫系統(tǒng)開發(fā)實(shí)例導(dǎo)航 [M].北京： 人民郵電出版社 ， 2021。 [8] 清漢計(jì)算機(jī)工作室 .ASP開發(fā)實(shí)例 [M].北京： 機(jī)械工業(yè)出版社 ， 2021。 第 22 頁 共 23 頁 致 謝 本文是在昌燕老師的關(guān)心和指導(dǎo)下完成的，她淵博的知識(shí)和嚴(yán)謹(jǐn)?shù)闹螌W(xué)作風(fēng)讓我受益匪淺，對(duì)完成本課題起了極大的作用，在此向她表示最衷心的感謝！ 感謝同班同學(xué)在課題研究初期給予的幫助，在他們的幫助下課題才得以很好的展開，有了一個(gè)很好的開端，尤其要感謝寇建波同學(xué)給予的支持和指導(dǎo)，在此還要感謝寢室各位同學(xué)在測試階段所做的幫助，因?yàn)樗麄兊膮f(xié)助才得以高效率的完成本課題！ 在論文完成過程中，本人還得到了其他老師和許多同學(xué)的熱心幫助，本 人向他們表示深深的謝意！ 最后向在百忙之中評(píng)審本文的各位專家、老師表示衷心的感謝！ 作者簡介 姓 名：嚴(yán)兵 性別：男 出生年月： 1984 年 11 月 民族：漢 Email: 第 23 頁 共 23 頁 聲 明 本論文的工作是 2021 年 2 月至 2021 年 6 月在成都信息工程學(xué)院網(wǎng)絡(luò)工程系完成的。文中除了特別加以標(biāo)注地方外，不包含他人已經(jīng)發(fā)表或撰寫過的 研究成果，也不包含為獲得成都信息工程學(xué)院或其他教學(xué)機(jī)構(gòu)的學(xué)位或證書而使用過的材料。除非另有說明，本文的工作是原始性工作。 關(guān)于學(xué)位論文使用權(quán)和研究成果知識(shí)產(chǎn)權(quán)的說明： 本人完全了解成都信息工程學(xué)院有關(guān)保管使用學(xué)位論文的規(guī)定，其中包括： （ 1）學(xué)校有權(quán)保管并向有關(guān)部門遞交學(xué)位論文的原件與復(fù)印件。 （ 2）學(xué)?？梢圆捎糜坝　⒖s印或其他復(fù)制方式保存學(xué)位論文。 （ 3）學(xué)?？梢詫W(xué)術(shù)交流為目的復(fù)制、贈(zèng)送和交換學(xué)位論文。 （ 4）學(xué)校可允許學(xué)位論文被查閱或借閱。 （ 5）學(xué)?？梢怨紝W(xué)位論文的全部或部分內(nèi)容（保密學(xué)位論文在解密 后遵守此規(guī)定）。 除非另有科研合同和其他法律文書的制約，本論文的科研成果屬于成都信息工程學(xué)院。 特此聲明！ 作者簽名： 2021 年 06 月 日 第 24 頁 共 23 頁 Are you hungry now? No, I am tired and lazy now。 if I pursue you I will not catch you, and if I catch youthrough your own slowness and clumsinessI will not kill you, and if I kill you I will not eat you. Nicholas had begun to back away, and at the last。 words, realizing that they were a signal, he turned and began to run, splashing through the shallow water. Ignacio ran after him, much helped by his longer legs, his hair flying behind his dark young face, his square teetheach white as a bone and as big as Nicholas39。s thumbnailshowing like spectators who lined the railings of his lips. Don39。t run, N icholas, Dr. Island said with the voice of a wave. It only makes him angry that you run. N icholas did not answer, but cut to his left, up the beach and among the trunks of the palms, sprinting all the way because he had no way of knowing Ignacio was not right behind him, about to grab him by the neck. When he stopped it was in the thick jungle, among the boles of the hardwoods, where he leaned,.。 out of breath, the thumping of his own heart the only39。 . sound in an atmosphere silent and unwa ked as Earth39。s long, prehuman day. For a time he listened for any sound Ignacio might make searching for him。 ther e was none. He drew a deep breath then and said, Well, that39。s over, expecting Dr. Island to answer from somewhere。 there was only the green hush. The light was still bright and strong and nearly, shadowless, but some interior sense told him the day, was nearly over, and he noticed that such faint shades as he could see stretched long, hor izontal distortions of their objects. He felt no hunger, but he had fasted be39。 fore and knew on which side of hunger he stood。 he was not as strong as he had been only a day past, and by this time next day he would probably be unable to outrun Ignacio. He should, he now realized, have eaten the mon key he had killed。 but his stomach revolted at the thought of the raw flesh, and he did not know how he might build a fire, although Ignacio seemed to have done so the night before. Raw fish, even if he were able to c atch a fish, would be as bad, or worse, than raw monkey。 he remembered his effort to open a coconuthe had failed, but it was surely not impossible. His mind was hazy as to what a coconut might contain, but there had to be an edible core, because they were eaten in books. He decided to make a wide sweep through the jungle that would bring him back to the beach well away from Ignacio。 he had several times seen coconuts lying in the sand under the trees. He moved quietly, still a little afraid, trying to think of ways to open the coconut w hen he found it. He imagined himself standing before a large and raggedly faceted stone, holding the coconut in both hands. He raised it and smashed it dow n, but when it struc k it was no longer a coconut but Maya39。s head。 he heard her nose cartilage break with a distin