µÚÈýÕÂ ÍøÉÏÊéµêÏêϸÉè¼Æ
3-1 ÐèÇó·ÖÎö
ÍøÉÏÊéµêϵͳÖ÷ÒªÊÇʵÏÖÍøÉÏÑ¡Êé¡¢¹ºÊé¡¢²úÉú¶©µ¥µÈ¹¦ÄܵÄϵͳ¡£Ò»¸öµäÐ͵ÄÍøÉÏÉ̳ÇÒ»°ã¶¼ÐèҪʵÏÖÉÌÆ·ÐÅÏ¢µÄ¶¯Ì¬Ìáʾ¡¢¹ºÎï³µ¹ÜÀí¡¢¿Í»§ÐÅÏ¢×¢²áµÇ¼¹ÜÀí¡¢¶©µ¥´¦ÀíµÈÄ£¿é¡£
¸ù¾ÝÍøÉÏÊéµêµÄ»ù±¾ÐèÇ󣬱¾ÏµÍ³ÐèÒªÍê³ÉµÄ¾ßÌåÈÎÎñÈçÏ£º A.
Êéͼ²éѯ: µ±¿Í»§½øÈëÍøÉÏÊéµêʱ£¬Ó¦¸ÃÔÚÖ÷Ò³ÃæÖзÖÀàÏÔʾ×îеÄÊéÄ¿ÐÅÏ¢£¬ÒÔ¹©¿Í»§Ñ¡ÔñËùÐèͼÊ飬ͬʱҲӦ¸ÃÌṩ°´ÕÕͼÊéÃû³Æ£¬»òÕß×÷ÕßÐÅÏ¢¿ìËÙ²éѯËùÐèÊéÄ¿ÐÅÏ¢µÄ¹¦ÄÜ¡£
B.
¹ºÎï³µ¹ÜÀí£ºµ±¿Í»§Ñ¡Ôñ¹ºÂòijͼÊé²úƷʱ£¬Ó¦¸ÃÄܹ»½«¶ÔӦͼÊéÐÅÏ¢£¬È磺¼Û¸ñ¡¢ÊýÁ¿¼Ç¼µ½¶ÔÓ¦µÄ¹ºÎï³µÖУ¬²¢ÔÊÐí¿Í»§·µ»ØÊéÄ¿²éÑ¯Ò³Ãæ£¬Ñ¡ÔñÆäËûÉÌÆ·£¬²¢Ìí¼Óµ½¹ºÎï³µÖУ¬µ±¶ÔÓ¦µÄ¹ºÎï¶©µ¥Éú³Éºó£¬Ó¦¸ÃÄܹ»×Ô¶¯Çå³ýÒÔÉú³É¶©µ¥µÄ¹ºÎï³µÖеÄÐÅÏ¢¡£
C.
¶©µ¥´¦Àí£º¶ÔÓ¦¿Í»§¹ºÂòͼÊéÉÌÆ·ÐÅÏ¢µÄÐèÇó£¬ÔÚÈ·¶¨ÁËËù¹ºÍ¼ÊéÉÌÆ·µÄ¼Û¸ñ¡¢ÊýÁ¿µÈÐÅÏ¢ºó£¬ÌáʾÓû§Ñ¡Ôñ¶ÔÓ¦µÄËÍ»õ·½Ê½¼°¸¶¿î·½Ê½£¬×îÖÕÉú³É¶ÔÓ¦µÄ¶©µ¥¼Ç¼£¬ÒÔ±ãÓÚÍøÕ¾Åä»õÈËÔ±ÒÀ¾Ý¶©µ¥ÐÅÏ¢½øÐкóÐøµÄ³ö»õ¡¢ËÍ»õµÄ´¦Àí¡£
D.
»áÔ±×¢²á£ºÎªÁËÄܹ»ÊµÏÖͼÊéÉÌÆ·µÄ¹ºÂò£¬ÐèÒª¹ÜÀí¿Í»§Ïà¹ØµÄÁªÏµ·½Ê½¡¢ËÍ»õµØµãµÈÏà¹ØµÄÐÅÏ¢¡£
3-2 ×ÜÌåÉè¼Æ ϵͳ×é³É
ϱíÖиø³öÁ˹¹³ÉÍøÉÏÊéµêϵͳµÄ¸÷¸ö×é¼þ£¬Í¨¹ýÏÂ±í£¬¿ÉÒÔ´Óºê¹ÛÉÏÁ˽â¸÷¸ö×é¼þµÄ¹¦ÄÜ¡£
Óû§±íʾ²ã£¨ÊÓͼ£© ¿ØÖÆ´¦Àí²ã£¨¿ØÖÆÆ÷£© ÒµÎñÂß¼²ã£¨Ä£ÐÍ£©
bookMain.jsp BookShow.jsp ActionForm LoginForm Action FirstAction BookDetailAction BookSearchAction LoginAction BookBuyAction DB Constants Book BookCat Order ShopCart User BookShopCart.jsp UserForm OrderAddress.jsp OrderConfirm.jsp UserLogin.jsp UserRegister.jsp OrderHistory.jsp Wrong.jsp
BookIdForm BookCatIdForm PageIdForm BookShopCartFrom AddrConfirmAction BookSearchForm DeliveryForm OrderIdForm ClearShopCartAction OrderDelAction OrderHistoryAction PageCtrlAction RegistAction UpdateShopCartAction
3-3 ¹¦ÄÜÉè¼Æ 1£®Í¼ÊéÐÅÏ¢¹ÜÀí
¸ÃÄ£¿éʵÏÖͼÊéÊéÄ¿ÐÅÏ¢µÄ·ÖÀàÏÔʾ£¬Ò²ÊÇÌṩͼÊéÐÅÏ¢ÒÀ¾ÝÊéÃû¼°×÷ÕßÐÅÏ¢¿ìËÙËÑË÷µÄ¹¦ÄÜ¡£´ËÍ⣬ÔÚÓû§Ñ¡ÔñÁ˶ÔÓ¦ÊéÄ¿ÐÅÏ¢ºó£¬»¹¿ÉÒÔÏÔʾ³öÓйظÃͼÊéµÄÏêϸÐÅÏ¢£¬ÒÔ±ãÓÚ¿Í»§Á˽âËù¹ºÉÌÆ·¡£ 2£®¹ºÎï³µ¹ÜÀí
ÓÃÓÚά»¤Ã¿Ò»¸ö½øÈëÍøÉÏÊéµêµÄ¿Í»§¶ÔÓ¦µÄ¹ºÎï³µ¡£¼´½«¿Í»§ËùÑ¡¹ºµÄͼÊéÉÌÆ·ÐÅÏ¢¼Ç¼µ½¶ÔÓ¦µÄ¹ºÎï³µÖУ¬ÒÔ±ãÓÚµ½ÊÕÒøÌ¨½øÐнáÕË´¦Àí¡£ 3£®»áÔ±×¢²á
ʵÏÖÍøÉÏÊéµê¿Í»§ÐÅÏ¢µÄ×¢²á¡¢¼°Éí·ÝÑéÖ¤¡£ÓÉÓÚÄ¿Ç°ÍøÉÏÉÌ³ÇÆÕ±é²ÉÓõķ½Ê½ÎªËÍ»õÉÏÃÅ»òÕßÓʼģ¬Òò´ËÐèÒªÊÕ¼¯Óë¿Í»§Ïà¹ØµÄÁªÏµ·½Ê½¡¢Í¨ÐŵØÖ·µÈÐÅÏ¢¡£ 4£®¶©µ¥´¦Àí
¸ù¾Ý¿Í»§¹ºÎï³µÖеÄÐÅÏ¢£¬ÒÔ¼°¿Í»§ËùÑ¡ÔñµÄËÍ»õ·½Ê½ºÍ¸¶¿î·½Ê½£¬Á¬Í¬¿Í»§¶ÔÓ¦µÄ¸öÈËÐÅÏ¢Éú³É¶©µ¥£¬ÒÔ±ãÓÚºóÐø½øÐÐËÍ»õ´¦Àí¡£ 3-4 Êý¾Ý¿âÉè¼ÆÓëʵÏÖ 3-4-1 Êý¾Ý¿âµÄÐèÇó·ÖÎö
ÒÀ¾ÝÍøÉÏÊéµêµÄ´¦ÀíÐèÇ󣬶ԾÍÊý¾Ý±íµÄÉè¼Æ¼°¹¦ÄÜÈçÏ¡£ A£® ͼÊé»ù±¾ÐÅÏ¢±í£º´æ·ÅÍøÉÏÊéµêËùÏúÊÛͼÊéµÄ»ù±¾ÐÅÏ¢¡£ B£® ͼÊé·ÖÀà»ù±¾ÐÅÏ¢±í£º´æ·ÅÍøÉÏÊéµêËùÌṩͼÊé·ÖÀàµÄÐÅÏ¢¡£ C£® ¿Í»§»ù±¾ÐÅÏ¢±í£º´æ·ÅÊéµê¿Í»§µÄ»ù±¾ÐÅÏ¢¡£ D£® ¶©µ¥ÐÅÏ¢±í£º´æ·ÅÓë¿Í»§Ïà¹ØµÄ¶©µ¥µÄ»ù±¾ÐÅÏ¢¡£ E£® ¶©µ¥ÌõÄ¿ÏêϸÐÅÏ¢±í£º´æ·Å¶©µ¥ÖÐÏêϸÌõÄ¿µÄ»ù±¾ÐÅÏ¢¡£ 3-4-2 ´´½¨Êý¾Ý±íµÄ½Å±¾ ´úÂëÈçÏ£º
_________________________________________________________________________
___
ͼÊé·ÖÀà»ù±¾ÐÅÏ¢±í
DROP TABLE bookcat CASCADE CONSTRAINTS; CREATE TABLE bookcat( );
ͼÊé»ù±¾ÐÅÏ¢±í
DROP TABLE book CASCADE CONSTRAINTS; CREATE TABLE book( );
¿Í»§»ù±¾ÐÅÏ¢±í
DROP TABLE storeuser CASCADE CONSTRAINTS; CREATE TABLE storeuser(
username VARCHAR2 (20)
PRIMARY KEY,
id catid
id
NUMBER PRIMARY KEY,
VARCHAR2 (40)
NOT NULL
catname
NUMBER PRIMARY KEY,
NUMBER NOT NULL
REFERENCES bookcat(id) ON DELETE CASCADE,
VARCHAR2 (50)
NOT NULL,
name price
NUMBER NOT NULL, NUMBER
NOT NULL,
saleprice descript author contents image
VARCHAR2 (500) NOT NULL, VARCHAR2 (50) NOT NULL, VARCHAR2 (2000) NULL, VARCHAR2 (50) NULL
Ïà¹ØÍÆ¼ö£º