ÕªÒª
ÔÚ¼ÆËã»úʱ´úÈÕÒæ·¢Õ¹µÄ½ñÌ죬¼ÆËã»úÍøÂçÕý¿ìËÙÈÚÈëÕâ¸öÉç»áµÄÿһ¸öÁìÓò¡£µã²ËÒ²´ÓÏÖʵÉú»îÖÐ×ßÉÏÁËÍøÂç¿Õ¼ä£¬¿ª·¢ºÍÉè¼ÆµÄ³ø·¿¶Ëµã²ËϵͳÊÇÕâ¸öʱ´úµÄ²úÎÀûÓüÆËã»úÖ§³Ö¹ÜÀíÕ߸ßЧÂÊÍê³Éµã²Ëϵͳ³ø·¿¶ËÉè¼ÆµÄ¹ÜÀí£¬½ÚÔ¼ÈËÁ¦×ÊÔ´£¬Ê¹¾ÓÃñÉú»î¸ü×ÔÖ÷»¯£¬½â¾ö´«Í³µã²ËµÄ¾ÖÏÞÐÔ¡£
±¾ÏµÍ³ÊÇÔÚWindows XP»·¾³Ï£¬²ÉÓÃB/S½á¹¹£¬ÒÔMySQLΪÊý¾Ý¿â¿ª·¢Æ½Ì¨£¬²ÉÓÃJSP(JAVA Server Pages)¼¼Êõ¿ª·¢µÄ¡£´ËϵͳµÄÉè¼Æ´Ó¹¦ÄÜÉÏÀ´Ëµ£¬ÊDZȽÏÍ걸µÄ£¬ÏµÍ³ÒÔWeb½çÃæÓë¹ÜÀíÔ±½»»¥£¬Îª¹ÜÀíÔ±ÌṩÐÅÏ¢²¢½ÓÊÜÆä²Ù×÷£¬Í¬Ê±Í¨¹ýÊý¾Ý¿â¹ÜÀíϵͳÀ´´æ´¢ÐÅÏ¢Êý¾Ý¡£±¾ÏµÍ³µÄ»ù±¾¹¦ÄÜ£ºÊý¾Ý½øÐмÈë¡¢Ð޸ġ¢É¾³ý¡¢²éѯ¡¢Í³¼ÆµÄ»ù±¾¹¦ÄÜ¡£
¹Ø¼ü´Ê£ºMySQL £»¹ÜÀíϵͳ£»JSP
Abstract
In the computer age growing today, the computer network is rapidly into every field of the society. Order from real life on the network space, the development and design of the kitchen end dish system is a product of this era, the use of computer support managers completed efficiently ordering system kitchen design management, save human resource, so that residents living more autonomy, the limitations of traditional order solution.
This system is under Windows XP environment, using B/S structure, using MySQL database development platform, using JSP (JAVA Server Pages) technology development. The design of this system from the function, is more complete, the system to the Web interface and administrator interaction, and provide information for administrators and accept its operation, at the same time to store information and data through database management system. The basic functions of the system: the basic function of data entry, modify, delete, query, statistics.
Keywords: MySQL; management system; JSP
Ŀ¼
1.Ð÷ÂÛ 1
1.1¿ÎÌâÑо¿±³¾°ºÍÒâÒå 1
1.2ÐÅÏ¢¹ÜÀíϵͳ 1
2.ϵͳ·ÖÎö 2
2.1¿ÉÐÐÐÔ·ÖÎö 2
2.1.1¾¼ÃÉϵĿÉÐÐÐÔ 2
2.1.2¼¼ÊõÉϵĿÉÐÐÐÔ 2
2.1.3²Ù×÷ÉϵĿÉÐÐÐÔ 3
2.2ϵͳ¹¦ÄÜÐèÇó·ÖÎö 3
2.2.1¹¦ÄÜÐèÇó 3
2.2.2ÐÔÄÜÐèÇó 4
2.3ÒµÎñÁ÷³Ì·ÖÎö 5
2.4Êý¾ÝÁ÷³Ì·ÖÎö 6
2.5Êý¾Ý¿âÉè¼Æ 7
2.5.1Êý¾Ý¿â¸ÅÄî½á¹¹Éè¼Æ 7
2.5.2Êý¾Ý¿âÂß¼½á¹¹Éè¼Æ 9
3.ϵͳÉè¼Æ 11
3.1 B/SÌåϵ½á¹¹ 11
3.2 ¿ª·¢Èí¼þ 12
3.2.1 JSP¼¼Êõ 12
3.2.2 Tomcat¹ÜÀíÆ÷ 13
3.2.3 MySQLÊý¾Ý¿â 14
3.3ϵͳµÄÈíÓ²¼þƽ̨ 15
4.ϵͳ²Ù×÷˵Ã÷ 15
4.1¹ÜÀíÔ±²Ù×÷˵Ã÷ 15
4.1.1ϵͳµÇ½½çÃæ 15
4.1.2¹ÜÀíÔ±Óû§¹ÜÀíÒ³Ãæ 19
4.1.3Óû§ÐÅÏ¢²éѯҳÃæ 20
4.1.4³øʦÐÅÏ¢Ìí¼ÓÒ³Ãæ 22
4.1.5ÈËÔ±·ÖÅä¹ÜÀíÒ³Ãæ 24
4.3Óû§²Ù×÷˵Ã÷ 24
4.2.1Óû§×¢²áÒ³Ãæ 24
4.2.2µã²Ë¼Ç¼Ìí¼ÓÒ³Ãæ 26
4.2.3ÆÀ¼ÛÌí¼ÓÒ³Ãæ 27
4.3³øʦ²Ù×÷˵Ã÷ 29
4.3.1¸öÈË×ÊÁÏÐÞ¸ÄÒ³Ãæ 29
4.3.2ÈÎÎñ²é¿´Ò³Ãæ 29
5.Èí¼þ²âÊÔÓë·ÖÎö 29
5.1ϵͳ²âÊԵĶ¨Òå 30
5.2ϵͳ²âÊÔµÄÄ¿µÄ¼°ÒâÒå 30
5.3ϵͳ²âÊÔµÄÖØÒªÐÔ 30
5.4ϵͳ²âÊԵij£Ó÷½·¨ 31
5.5²âÊÔ»·¾³Óë²âÊÔÌõ¼þ 32
5.6ϵͳÔËÐÐÇé¿ö 32
5.7²âÊÔ×ܽá 33
6.½áÂÛ 33
6.1ϵͳµÄÌصã 33
6.2ϵͳµÄ²»×ãºÍ¸Ä½ø 33
6.3Éè¼ÆÊÕ»ñÓëÐĵà 33
Ö л 35
²Î ¿¼ ÎÄ Ï× 36