網(wǎng)上書(shū)店管理信息系統(tǒng)開(kāi)發(fā)設(shè)計(jì)論文(參考版)
2025-06-26 23:31本頁(yè)面
【正文】 后來(lái)，我去圖書(shū)館借了幾本有關(guān)系統(tǒng)分析和設(shè)計(jì)方面的書(shū)，又在網(wǎng)上下載了一些資料，經(jīng)過(guò)我對(duì)書(shū)本上的知識(shí)的學(xué)習(xí)和對(duì)網(wǎng)上資料的研究，我終于弄清楚了該怎么設(shè)計(jì)分析設(shè)計(jì)一個(gè)系統(tǒng)通過(guò)本次實(shí)驗(yàn)使我對(duì)數(shù)據(jù)庫(kù)有了一個(gè)更加全面，更加深入的了解，也可以說(shuō)是對(duì)本學(xué)期所學(xué)的數(shù)據(jù)庫(kù)知識(shí)的一個(gè)總結(jié)，這次實(shí)驗(yàn)不像以前一樣，只是對(duì)數(shù)據(jù)庫(kù)某一部分知識(shí)的練習(xí)鞏固，不僅僅是設(shè)計(jì)幾張表，設(shè)計(jì)幾個(gè)存儲(chǔ)過(guò)程，觸發(fā)器，而是對(duì)這些知識(shí)的一個(gè)整合，是一次綜合的練習(xí)，使我對(duì)設(shè)計(jì)一個(gè)數(shù)據(jù)庫(kù)的流程有了一個(gè)了解和掌握。這次網(wǎng)上書(shū)店管理系統(tǒng)的設(shè)計(jì)花了我不少的時(shí)間，在沒(méi)有設(shè)計(jì)這個(gè)系統(tǒng)前，我一直覺(jué)得編碼很難，但是經(jīng)過(guò)這次系統(tǒng)設(shè)計(jì)，我覺(jué)得系統(tǒng)分析階和設(shè)計(jì)階段是最難的。 rollback end end ，其基本功能是在填寫(xiě)訂單和詳細(xì)訂單的時(shí)候相應(yīng)的總價(jià)被計(jì)算處理填入相應(yīng)的位置。其具體代碼如下所示： create trigger trig1 on tb_bookinfo for update as if(update(BookStoremount)) begin declare mount int set mount=(select BookStoremount from deleted) if(mount0) begin print 39。ljfl’,’331231’,’的發(fā)愛(ài)的’(‘風(fēng)云網(wǎng)上書(shū)店’,tb_parameter7. insert’’,’’,’云峰’,’’,’180’),’1’,’’valuesinto’2’,20101222’1’(‘’,tb_order5. insert1:1:1:111’,’精品包裝’)’201021’,’php編程寶典’(‘’,tb_bookinfo4. insert(’科技類(lèi)’)tb_booktypeinfo(BookTypeName)3. insert11:00:11:111’)11:00:11:111’,’valuesCustomerLogTime,CustomerQues,CustomerAddr,CustomerTel,Customertruename,(CustomerName,intovaluestb_manager(AdminName,AdminPwd, alter table tb_bookinfo add constraint FK_TB_BOOKI_REFERENCE_TB_BOOKT foreign key (BookTypeId) references tb_booktypeinfo (BookTypeId) go alter table tb_ment add constraint FK_TB_COMME_REFERENCE_TB_BOOKI foreign key (BookId) references tb_bookinfo (BookId) go alter table tb_ment add constraint FK_TB_COMME_REFERENCE_TB_CUSTO foreign key (CustomerId) references tb_customerinfo (CustomerId) go alter table tb_order add constraint FK_TB_ORDER_REFERENCE_TB_CUSTO foreign key (CustomerId) references tb_customerinfo (CustomerId) go alter table tb_orderdetail add constraint FK_TB_ORDER_REFERENCE_TB_ORDER foreign key (OrderId) references tb_order (OrderId) go alter table tb_orderdetail add constraint FK_TB_ORDER_REFERENCE_TB_BOOKI foreign key (BookId) references tb_bookinfo (BookId) go alter table tb_reply add constraint FK_TB_REPLY_REFERENCE_TB_CUSTO foreign key (CustomerId) references tb_customerinfo (CustomerId) go alter table tb_shopbook add constraint FK_TB_SHOPB_REFERENCE_TB_BOOKI foreign key (BookId) references tb_bookinfo (BookId) go alter table tb_shopbook add constraint FK_TB_SHOPB_REFERENCE_TB_CUSTO foreign key (CustomerId) references tb_customerinfo (CustomerId) go 1. insert11. )(ReplyId)primaryconstraintnotvarchar(10)9. null,datetimeCommentdatenotvarchar(20)7. null,varchar(100)6. null,Replytitlenotvarchar(20)ReplyTypenotint3. null,2. (tablekeyPK_TB_COMMENT9. null,8. null,varchar(100)7. null,datetimeCommentdatenotvarchar(20)5. null,CustomerIdnotint3. null,2. (tablekeyPK_TB_ORDERDETAIL12. null,11. )),39。(39。(RecevstatusCKC_RECEVSTATUS_TB_ORDER未收貨39。defaultnotvarchar(10)Recevstatus已發(fā)貨39。未發(fā)貨39。incheckconstraint8. 39。nullpoststatusnotint6. null,BookIdnotvarchar(20)OrderIdnotvarchar(20)OrderDetailIdidtb_orderdetail（8）tb_orderdetail訂單詳細(xì)信息表1. create16. )(OrderId)primaryconstraintnotmoney14. null,memonotvarchar(10)12. null,11. null,10. null,varchar(100)paymethodnotpostmethodvarchar(100)messagenotint6. null,datetimeOrderdatenotint4. null,3. identity,int2. (table（7）9. )BookId)keyPK_TB_SHOPBOOK8. )),39。(39。(ispayCKC_ISPAY_TB_SHOPB未付款39。defaultnotvarchar(10)ispaynotmoneypricenotint4. null,BookIdnotint2. (tablekeyPK_TB_PARAMETER21. null,varchar(100)20. null,varchar(100)19. null,varchar(100)lawnot17. null,worktimenot15. null,14. null,varchar(100)13. null,varchar(100)12. null,varchar(100)11. null,10. null,varchar(100)weblogonotvarchar(20)copyrightnotvarchar(10)telnotvarchar(10)6. null,5. null,varchar(100)4. null,varchar(100)3. null,2. (table（5）tb_parameter參數(shù)設(shè)置信息表1. tb_7. )(AdminId)primaryconstraintnotintAdminFlagnotvarchar(20)4. null,3. identity,intAdminIdtb_manager（4）tb_manager管理員信息表1. create27. )(BookId)primaryconstraintnotvarchar(20)BookPackstylenot24. null,BookStoremountnotmoneyBookPicnotvarchar(10)21. nu
語(yǔ)文相關(guān)推薦
鄂ICP備17016276號(hào)-1