Õª Òª ÂÃÓÎÍøÕ¾½¨ÉèÊÇÃæÏòÏÖʵÐèÇóµÄÒ»¸öʵÓÃϵͳ¡£ÆäÉè¼ÆµÄÄ¿µÄÊÇΪÓοͺÍÂÃÓÎÍøÕ¾Ìṩһ¸öÓѺõġ¢Ö±½ÓµÄ½»Á÷ƽ̨¡£±¾ÏµÍ³Ö÷Òª·ÖΪÁù´óÄ£¿é£ºÂÃÓÎ×ÉѯÐÅÏ¢¡¢ÂÃÓÎÏß·ÐÅÏ¢¡¢ÈȵãÂÃÓÎÏß·ÐÅÏ¢¡¢Ïß·²éѯ¡¢ÁôÑÔÐÅÏ¢ÒÔ¼°È¨ÏÞ¹ÜÀí¡£¸ÃϵͳµÄÖ÷Òª¹¦ÄÜ£ºÌṩ¸ø¹ÜÀíÕßÒ»¸ö¼òµ¥µÄ½çÃ棬¿ÉÒÔºÏÀí¼Æ»®°²Åŵ¼ÓεŤ×÷ºÍ¼°Ê±Á˽âÓο͵ÄÒªÇóºÍÐÅÏ¢£»Ìṩ¸øÓοÍÒ»¸öÇåеĽçÃæÑ¡Ôñ×Ô¼ºÏòÍùµÄÂÃÓÎʤµØ¡£±¾ÏµÍ³²ÉÓÃJSP½øÐпª·¢£¬½áºÏSQL SEVER À´´´½¨Êý¾Ý¿âºÍ³ÌÐò¸ú×ÙÓë¹ÜÀíÐÅÏ¢¡£±¾ÏµÍ³µÄÉè¼Æ¹ý³ÌÍêÈ«°´ÕÕÈí¼þ¹¤³ÌµÄÒªÇ󿪷¢µÄ,Ö÷Òª·ÖΪÒÔϼ¸¸ö²½Öè:Ê×ÏȽøÐпÉÐÐÐÔÑо¿£»µÚ¶þ²½½øÐÐÏêϸµ÷²é£¬ÐèÇó·ÖÎö£»µÚÈý²½½øÐÐϵͳ×ÜÌå½á¹¹Éè¼Æ£¬Íê³ÉϵͳËùÐèµÄÊý¾Ý¿âÉè¼Æ£»µÚËIJ½½øÐÐϵͳÏêϸÉè¼Æ£¬×îºó½øÐÐÈí¼þ±àÂëºÍϵͳ²âÊÔ¡£
¹Ø¼ü´Ê£º ×ÜÌåÉè¼Æ£» Êý¾Ý¿âÉè¼Æ£» ÏêϸÉè¼Æ£»JSP £» SQL SERVER
Abstract The traveling website construction is faces the realistic demand an utility system. Its design's goal is in a friendly way provides one for the tourist and the traveling website, the direct exchange platform. This system mainly divides into six big modules: Traveling consultation information, tourist route information, hot spot tourist route information, line inquiry, message information as well as jurisdiction management. This system's major function: Provides for the superintendent a simple contact surface, may plan reasonably arranges tour guide's work and understands tourist's request and the information promptly; Provides tourist attraction which a fresh contact surface chooses itself for the tourist to yearn. This system uses JSP to carry on the development, unifies SQL SEVER to found the database and the program tracking and the management information. This system's design process defers to the software engineering completely the request development, mainly divides into the following several steps: First conducts the feasibility study; Second step carries on the close investigation, the demand analysis; Third step carries on the system gross structure design, completes database design which the system needs; Fourth step carries on the system detailed design, finally carries on the software code and the system test.
Key word: System design Database design Detailed design JSP SQL SEVER
Ä¿ ¼ Õª Òª 1 Abstract 2 1. Ð÷ÂÛ 4 1.1 Ñ¡Ìâ±³¾° 5 1.2 Ñ¡ÌâÒÀ¾Ý 5 1.3 ÂÃÓÎϵͳÏÖ×´ 6 2.JSPÈí¼þ½éÉÜ 7 2.1 JSP½éÉÜ 7 2.2 JSP°æ±¾¼ò½é 7 2.3 JSPÓïÑԵĻù±¾Ìصã 8 2.3.1 ¿ÉÊÓ»¯Éè¼Æ 9 2.3.2ʼþÇý¶¯±à³Ì 10 2.4Êý¾Ý¿âµÄ½éÉÜ 10 2.5¹ØϵÐÍÊý¾Ý¿âµÄʵÏÖ 11 2.5.1 JDBCÊý¾Ý·ÃÎÊ½Ó¿Ú 12 2.5.2 JDBCµÄÌåϵ½á¹¹ 12 2.5.3 JDBC·ÃÎʺǫ́Êý¾Ý¿âµÄ¼¼ÊõʵÏÖ·½·¨ 13 2.6 ÂÃÓÎϵͳÈí¼þ¿ª·¢·½·¨ 14 3. ÏîÄ¿¶¨Òå 15 3.1 ϵͳ·ÖÎö 15 3.2 ÎÊÌⶨÒå 15 3.2.1Éè¼ÆÄ¿µÄºÍÈÎÎñ 16 3.2.2 Éè¼ÆÒªÇó 16 3.3 ¿ÉÐÐÐÔ·ÖÎö 17 3.4 ÐèÇó·ÖÎö 18 4.ϵͳ¿ª·¢ 20 4.1 ϵͳÉè¼Æ 20 4.2±¾ÏµÍ³µÄ×ÜÌåÉè¼Æ 21 4.3ÏêϸÉè¼Æ 22 4.4¡¢E-RÄ£Ðͼò½é 24 4.5¡¢±¾ÏµÍ³µÄE-Rͼ¼°Êý¾Ý¿â±íµÄ½á¹¹ 25 4.6 Ä£¿é¹¦ÄÜʵÏÖ 28 4.7 ³ÌÐòÁ÷³Ìͼ 32 4.7.1 ³ÌÐòÉè¼Æ 32 4.7.2±à³ÌµÄ¹ý³Ì¼°ÌØÉ« 34 5. Èí¼þ±àÂëÓë²âÊÔ 35 5.1 ³ÌÐò±àÂë 35 5.2 °²×°ËµÃ÷ 35 5.3 Èí¼þ²âÊÔ 35 5.4 ²âÊÔµÄÄ¿µÄ¼°Ïà¹ØÎÊÌâ 36 5.5²âÊÔ¹ý³Ì 37 5.6²âÊÔ½á¹û 37 6. ÎÊÌâ½â¾ö¹ý³Ì¼°Ìå»á 38 Ö л 39 ²Î¿¼ÎÄÏ× 40
1. Ð÷ÂÛ Ëæ×ÅÉç»á·¢Õ¹¡¢¹¤Òµ½ø²½£¬½üÄêÀ´ÈËÃñµÄÉú»îˮƽÈÕÒæÌá¸ß£¬Ïû·Ñ½á¹¹Ò²·¢ÉúÁ˾޴óµÄ±ä»¯¡£ÈËÃǵÄÉú»î²»ÔÙÖ»¾ÖÏÞÓÚ¼òµ¥µØÂú×ãα¥£¬Ô½À´Ô½¶àµÄÈË¿ªÊ¼×¢ÖØÉú»îµÄÖÊÁ¿£¬¼´ÉíÌåËØÖʺ;«ÉñÎÄ»¯ËØÖʵÄͬ²½Ìá¸ß¡£Í¬Ê±£¬¹ú¼ÒÒ²»ý¼«¹ÄÀøÈËÃÇÀûÓýڼÙÈÕÍâ³öÂÃÓΣ¬ÓÎÀÀ¸÷µØµÄÃÀÀö¾°É«£¬Á˽âÄÇÀïµÄÈËÎĵØÀíºÍ·çÍÁÈËÇé¡£ÕâÑùÒ»·½Ãæ¿ÉÒÔ¶ÍÁ¶ºÍÌá¸ßÈ«ÃñËØÖÊ£¬Ò»·½Ã滹¿ÉÒÔÔö¼Ó¹ú¼ÒÂÃÓβÆÕþ·½ÃæµÄÊÕÈ룬Àû¹úÀûÃñ¡£ °é×ÅÅ·¢Õ¹µÄÂÃÓÎÒµ£¬¸÷ÖÖµÄÂÃÓÎÍøÕ¾Ò²Ó¦Ô˶øÉú¡£ËüÃǵIJúÉúΪÈËÃǵijöÓÎÌṩÁ˺ܶ෽±ã£¬Ö»ÒªÓοÍÌá³öÒªÇó£¬ÂÃÓÎÍøÕ¾»á¾¡Á¿ÎªËûÃÇ¿¼ÂÇ£¬ºÏÀí°²Åźø÷Ìõ·ÏߺÍÏà¹ØÐг̡£µ±È»£¬ÐÂÐ˵ÄÐÐÒµËäÈ»ÓкÜÇ¿µÄÉúÃüÁ¦£¬µ«ÊÇÔÚÉÏÊöµÄ·þÎñÖÐÈÔ´æÔںܶàµÄ²»×ã¡£
|