²Í¹Ýµã²ÍϵͳÐèÇó·ÖÎö ÏÂÔر¾ÎÄ

²Í¹Ýµã²ÍϵͳÐèÇó·ÖÎö

1¡¢ ÐèÇó·ÖÎö

Óû§¿Éͨ¹ý·ÃÎÊÎÒÃǵÄÍøÕ¾£¬½øÐеǽ»ò×¢²á£¬»ñµÃÄãÏëÒªµÄ¸÷ÖÖʳÎ¹ÜÀíÔ±¿ÉÒԲ鿴Óû§²ËÆ·£¬¿ÉÒÔ¶Ô²ËÆ·½øÐÐÔöɾ¸Ä²é¡£ 2¡¢ Èí¼þ¹¦ÄÜ

´ËϵͳÖ÷ÒªÊÇÕë¶Ô¹Ë¿Í¿ª·ÅµÄÍøÉ϶©²Íϵͳ¡£ ¹Ë¿Í¶©²ÍÖ÷ÒªÁ÷³ÌÈçÏ£º

1. ¹Ë¿ÍµÇ¼ÍøÉ϶©²Íϵͳ½øÐв˵¥µÄä¯ÀÀ»òÕß×¢²áΪ»áÔ±¡£

2. »áÔ±¿ÉÒÔ¶Ô×Ô¼ºµÄ¸öÈËÐÅÏ¢½øÐиü¸Ä£¬ÒÔ»áÔ±ÐÎʽµÇ½µÄ¹Ë¿ÍÏíÊܶ©²Í·þÎñ¡£ 3. Èç¹û¹Ë¿Í¾õµÃ²Ëµ¥Ó¦¸ÃÓÐËù¸Ä±äÔò¿É¶ÔÒÑÑ¡µÄ²Ëµ¥½øÐÐÑ¡Ôñ¡¢¸ü¸Ä¡¢É¾³ýµÈ¹¦

ÄÜ¡£

4. µ±¹Ë¿ÍÈ·¶¨¶©²ÍÍê±Ïºó£¬¹Ë¿Í¿ÉÒÔ½«ÆäÌá½»ÖÁÎÒÃǵIJÍÌüºǫ́ϵͳ£¬²¢Éú³É¶©

µ¥¡£

5. ¹Ë¿Í¿ÉÒÔ¶Ôϵͳ»òÕß²ÍÌüÓÐÒâ¼û»òÕß½¨ÒéµÄÁôÑÔ¸øÎÒÃÇ£¬ÎÒÃǻἰʱÂúÒâµÄ»Ø

¸´¡£

¹ÜÀíÔ±¡¢ºǫ́¹ÜÀíÁ÷³ÌÈçÏ£º

1. ¹ÜÀíÔ±µÇ¼ºǫ́µã²Íϵͳ¡£ 2. ¹ÜÀíÔ±¿ÉÒÔ¹ÜÀí»áÔ±ÐÅÏ¢¡£

3. ºǫ́½«¹Ë¿Íµã²ÍÌá½»µ½ºó³øÏÔʾ¡£ 4. ºó³ø¸ù¾Ý¹Ë¿Í¶©²Í²Ëµ¥½øÐÐ×ö²Ë¡£ 5. ÿÍê³ÉÒ»¸ö²Ë¾Í¸ü¸ÄÆä״̬ΪÒÑ×ö¡£

6. ËùÓж©²Í²ËÍê³Éºó¸ù¾Ý»áÔ±Ìá½»ËͲ͵ØÖ·½øÐÐÈ·Èϲ¢ËͲ͡£

3¡¢ ¹¦ÄÜÃèÊö

3.1¹Ë¿ÍÍøÉ϶©²Í¹¦ÄÜ·ÖÎö£º

¸ù¾Ý¶Ô¹Ë¿ÍÍøÉ϶©²ÍϵͳҵÎñÁ÷³ÌµÄ·ÖÎö£¬¿ÎÒÑ¿´³ö¹Ë¿Íµã²ËÖ÷ÒªÉæ¼°µ½Ò»Ð©Êý¾Ý¿âµÄÂß¼­ºÍ³ÌÐòÓ¦ÓÃÂß¼­¡£¾ßÌåµÄ¹¦ÄܹéÄÉÈçÏ£º

1. ¹Ë¿ÍµÇ¼ÍøÉ϶©²Íϵͳ½øÐв˵¥ä¯ÀÀ¡¢ 2. ¹Ë¿Í×¢²áΪ»áÔ±¡£

3. »áÔ±¶Ô×Ô¼ºµÄ¸öÈËÐÅÏ¢½øÐиü¸Ä£¬±ÈÈçËͲ͵ØÖ·ºÍÁªÏµµç»°¡£ÒÔ¼°ÕË»§ÃÜÂë¡£ 4. ¹Ë¿Í¶ÔÒÑÑ¡µÄ²Ëµ¥½øÐиü¸ÄÑ¡ÔñµÄÊýÁ¿»òÕßÈ¡ÏûÑ¡Ôñ¡£

5. µ±¹Ë¿ÍÈ·¶¨¶©²ÍÍê±Ïºó£¬¹Ë¿Í½«ÆäÌá½»Ö»·þÎñÆ÷ºǫ́µã²Íϵͳ£¬²¢Éú³É¶©µ¥¡£ 3.2¹ÜÀíÔ±ºǫ́¹ÜÀíϵͳ¹¦ÄÜ·ÖÎö£º

1£® ¹ÜÀíÔ±ÔÚºǫ́µÇ¼ºó£¬¿ÉÒÔ´´½¨ÐµĹÜÀíÔ±¡£

2£® ¹ÜÀíÔ±¿ÉÒÔ¶Ô²ÍÌüÍøÉ϶©²ÍϵͳÉϵIJ˵¥½øÐÐÌí¼Ó¡¢É¾³ýºÍÐ޸ģ¬±ÈÈç¸ü¸Ä²Ë

µ¥µÄͼƬ£¬¼Û¸ñ£¬²Ëµ¥µÄÃèÊö£¬¸ü»»ÐÂÆ·£¬Ìí¼Óв˵ȡ£ 3£® ¹ÜÀíÔ±¶Ô²Ëµ¥½øÐйÜÀí£¬È·¶¨¶©µ¥µÄÉú³É¡£

4£® ¹ÜÀíÔ±¸ù¾Ý²»Í¬µÄÊôÐÔÀ´²éѯ¶©µ¥£¬±ÈÈçÉú³ÉÈÕÆÚ»òÕß±àºÅµÈ¡£ 5£® ¹ÜÀíÔ±¸ù¾Ý²»Í¬µÄʱ¼ä¶Îͳ¼Æ´¦ÓªÒµ¶î£¬³É±¾£¬Í¬Ê±»¹ÄÜͳ¼Æ³öÿµÀ²ËµÄÏúÊÛ

Á¿¡¢ÈκÎʱ¼ä¶ÎµÄÏúÊÛÇé¿öÒÔ¼°Ã¿Ò»¸ö¹Ë¿ÍµÄÏû·ÑÇé¿ö¡£

Ϊ¸üºÃµÄ˵Ã÷ϵͳ£¬¾ßÌ幦ÄÜÈçÏÂ±í£º

- 1 -

¹¦ÄÜÀà±ð Óû§¹ÜÀí Óû§²Ù×÷ ×Ó¹¦ÄÜ Óû§µÇ¼ Óû§×¢²á ²ÍƷչʾ ²ÍÆ·µÄÏêϸ½éÉÜ ·Å½ø¹ºÎï³µ ²é¿´¹ºÎï³µ ÏêϸÐÅÏ¢Ìá½» ·´À¡Òâ¼û ²ì¿´ËùÓÐÁôÑÔ ¹ÜÀíÔ±²Ù×÷ Ôö¼Ó²ÍÆ· Ð޸òÍÆ· ɾ³ý²ÍÆ· »Ø¸´ÁôÑÔ É¾³ýÁôÑÔ ½áÕʸ¶¿î ½áÊø¶©µ¥ 4¡¢ Êý¾Ý¿âÉè¼Æ

4.1Êý¾Ý¿â±í¼°×Ö¶ÎÉè¼Æ userInfo±í£¨×¢²áÓû§±í£© ÊôÐÔ userID userName userPass userMail userRealName userSex ÊôÐÔ foodId dno customerName Address zipCode telephone movPhone email Notice TotalPrice Examine Stants rdate caipu±í£¨²ËÆ×±í£©

- 2 - È·ÈϺÍÅäËÍÐÅÏ¢ ÉèÖÃÓѺýáÊø½çÃæ Êý¾ÝÀàÐÍ Int Varchar£¨30£© Varchar£¨30£© Varchar£¨50£© Varchar£¨30£© Varchar£¨4£© Êý¾ÝÀàÐÍ Int Varchar(50) Int Varchar(100) Varchar(20) Varchar(30) Varchar(30) Varchar(30) Text Numeric(18,0) Varchar(50) Varchar(50) Varchar(50) ÔÊÐí¿Õ Not null Not null Not null ÔÊÐí¿Õ Not null Not null Not null Not null Not null Primary Ö÷¼ü Primary foodOrderInfo±í£¨¶©²Í±í£©

ÊôÐÔ caipuming caipineirong rtiem Lianxi±í£¨ÁôÑÔ±í£© ÊôÐÔ zhuti email yijian ritem Êý¾ÝÁ÷³Ìͼ£º

Óû§Ä£¿é Êý¾ÝÀàÐÍ Varchar£¨50£© Varchar£¨50£© Varchar£¨50£© datetime ÔÊÐí¿Õ Not null Not null Not null Not null Ö÷¼ü primary Êý¾ÝÀàÐÍ Varchar(50) Varchar(500) datetime ÔÊÐí¿Õ Not null Not null Not null Ö÷¼ü primary ×¢²áÓû§ µÇ¼ϵͳ ä¯ÀÀ²ÍÆ· ²ÍÆ·²éѯ ¶©¹º²ÍÆ· ÔÚÏßÁôÑÔ

¹ÜÀíԱģ¿é ²ÍÆ·¹ÜÀí ·þÎñ¹ÜÀí Ìí¼Ó²ÍÆ· Ð޸IJÍÆ· ɾ³ý²ÍÆ· »Ø¸´ÁôÑÔ É¾³ý²ËÆ× Ìí¼Ó²ËÆ× É¾³ýÁôÑÔ ¹ÜÀí¶©µ¥

5¡¢ Óû§½çÃæ

½çÃæ·ç¸ñÒÔ³ÈɫΪÖ÷µ÷£¬ÇåÐÂ×ÔÈ»£¬¿ÉÒÔÔöǿʳÓû£¬Ìí¼Ó¶¯Ì¬»­ÃæЧ¹û£¬±ÜÃâÁËÒ³ÃæµÄ´ô°å¡£°üÀ¨Á˵Ǽ´°¿Ú£¬¹ØÓÚÎÒÃÇ£¬ÍøÉ϶©²Í£¬×îл£¬Ê±¼äÏÔʾ£¬ÓÑÇéÁ´½Ó£¬

- 3 -