【正文】 UserID INT, CartID NVARCHAR(50), Address VARCHAR(50), PostCode CHAR(10), Telephone VARCHAR(50), OrderID INT OUTPUT ) AS BEGIN TRAN OrdersInsert /* 產生訂單 */ INSERT INTO Orders ( UserID, Address, PostCode, Telephone, OrderDate ) VALUES ( UserID, Address, PostCode, Telephone GETDATE() ) 返回當前所產生的 OrderID SELECT OrderID = Identity /* 將當前用戶的當前購物車復制到當前所產生的訂單詳情中 */ INSERT INTO OrderDetails ( OrderID, FlowerID, Quantity ) SELECT OrderID, , Quantity FROM ShoppingCart INNER JOIN Flower ON = WHERE CartID = CartID /*扣除相應的庫存鮮花數量 */ UPDATE Flower SET FlowerStock = FlowerStock FROM OrderDetails INNER JOIN Flower ON = WHERE = OrderID /* 完成后 , 調用另一存儲過程 spShoppingCartEmpty 清空當前購物車 ID 的所有明細 */ EXEC spShoppingCartEmpty CartID COMMIT TRAN OrdersInsert GO 其中調用了一個存儲過程 spShoppingCartEmpty 主要代碼如下 ： CREATE Procedure spShoppingCartEmpty ( CartID nvarchar(50) ) AS DELETE FROM ShoppingCart WHERE CartID = CartID GO 撤消訂單 客戶可以在規(guī)定的時間內將自己所下的訂單撤消 ，如圖 12。 圖 12 撤消訂單 主要的代碼如下 ： public void spCancelOrder(int iUserID, int iOrderID) { ConnOpen()。 = 。 SqlParameter Param2 = new SqlParameter(OrderID, , 4)。 (Param2)。 = iOrderID。 ConnClose()。 如果不是管理員 登錄 則不會顯示該表 ，如圖 13。 圖 13 鮮花添加刪除 主要代碼如下： try { int UserID = ()。 = true。 } catch { (?info=請先登錄或注冊！ )。這些過程的討論和分析， 可以 對系統的體系結構，功能模塊等有了更深的了解。但系統仍然有一些不盡人意，而這些問題主要集中在系統的安全上，雖然系統已經通過相關的控制語句對 登錄 用戶身份進行驗證，但是在當今網絡信息安全中，僅僅對用戶身份驗證是不夠的，還需要對 傳送數據進行加密，防止數據傳輸過程中被篡改等攻擊進行防御。 網上購物系統無論是在開發(fā)過程中，還是建成后的日常維護過程中，都需要進行嚴格的檢測，以保證購物系統的服務質量。 （ 1）把握好商品質量和宣傳內容環(huán)節(jié)。產品宣傳廣告內容應健康真實，既要反映客觀事物又要有欣賞價值。對虛擬電子商品的審查，首先要進行內容正確性測試。 ② 進行系統功能的測試。 ③ 對系統的執(zhí)行效率進行測試。 （ 3）用戶身份確認及商品配送 隨著網上購物系統技術的日趨成熟、網上購物的優(yōu)勢日趨明顯 ，會有更多的人參與到網上購物的浪潮中來，人類最終將迎接電子商務時代的來臨。 [2] 石志國 ,劉冬梅 . [M].北京 ： 清華大學出版社和北京交通大學出版社出版 ,2021。 [4] [M].北京 ： 清華大學出版社 ,2021。 [6] 江廣順 ,余松 . +SQL SERVER 熱門網絡應用開發(fā)詳解 [M].北京：人民郵電 出版社 ,2021。 致 謝 本文是在熊淑華老師和張金全老師的熱情關心和指導下完成的，他們淵博的知識和嚴謹的治學作風使我受益匪淺，對順利完成本課題起到了極大的作用。文中除了特別加以標注地方外，不包含他人已經發(fā)表或撰寫過的研究成果，也不包含為獲得成都信息工程學院或其他教學機構的學位或證書而使用過 的材料。 關于學位論文使用權和研究成果知識產權的說明： 本人完全了解成都信息工程學院有關保管使用學位論文的規(guī)定，其中包括： （ 1）學校有權保管并向有關部門遞交學位論文的原件與復印件。 （ 3）學?？梢詫W術交流為目的復制、贈送和交換學位論文。 （ 5）學?？梢怨紝W位論文的全部或部分內容（保密學位論文在解密后遵守此規(guī)定）。 特此聲明！ 作者簽名： 年 月 日 Are you hungry now? No, I am tired and lazy now。 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。t run, N icholas, Dr. Island said with the voice of a wave. It on ly 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 palm s, 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,.。 . sound in an atmosphere silent and unwa ked as Earth39。 there was none. He drew a deep breath then and said, Well, that39。 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。 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 monkey he had ki lled。 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。s head。 had Dr. Island used that sound to speak to him? He walked toward it and found a little rill that threaded a way among the trees, and followed it. In a hundred steps it grew broader, slowed, and ended in a long blind pool under a dome of leaves. . Diane was sitting on moss on the side opposite him。t mistaken after all, was I? I didn39。s Nicholas, and I called you. Then I thought I might be wrong, or that it might be Ignacio. Ignacio was chasing me. Maybe he still is, but h think he39。s a bit frightened of us. Have you ever talked to him, Nicholas? Today I did a little. He told me a story about a pet fish he used to have. Ignacio grew up all alone。s emptie than it used to be. Where Ignacio was, there would have been Red Indian hunters two or three hundred years ago。t anyone,` just the machines. Now he doesn39。t want anyone around him. Nicholas said slowly, Dr. Island said lots of people wouldn39。t other people around all the time. Remember that? a Only there. are other people around all the time。s how the world is. Not in Brazil, maybe, Nicholas said. He was trying to remember something about Brazil, but the only thing he could think of was a parrot singing in a straw hat from the view cartoons。t he stay there? Did I tell you about the bird, Nicholas? She had been not listening again. What bird? I have a bird. Inside. She patted the flat stomach below her small breasts, a