Õª  Òª
½üÄêÀ´£¬Ëæ×ÅInternetµÄѸËÙáÈÆ𣬻¥ÁªÍøÒÑÈÕÒæ³ÉΪÊÕ¼¯ÌṩÐÅÏ¢µÄ×î¼ÑÇþµÀ²¢Öð²½½øÈ봫ͳµÄÁ÷ͨÁìÓò¡£ÓÚÊǵç×ÓÉÌÎñ¿ªÊ¼Á÷ÐÐÆðÀ´£¬Ô½À´Ô½¶àµÄÉ̼ÒÔÚÍøÉϽ¨ÆðÔÚÏßÉ̵꣬ÏòÏû·ÑÕßչʾ³öÒ»ÖÖÐÂÓ±µÄ¹ºÎïÀíÄ±¾¹ºÎïϵͳ»ùÓÚB/Sģʽ£¬ÊµÏÖÁ˵±Ç°¹ºÎïÍøÕ¾µÄ»ù±¾¹¦ÄÜ¡£
±¾ÂÛÎľʹ˹ºÎïϵͳ½øÐÐÁËÏêϸȫÃæµÄÂÛÊö¡£ÏµÍ³ÖÐÓû§µÄÖ÷Òª¹¦ÄÜÓУºÓû§µÇ¼¡¢×¢²á¡¢ÉÌÆ·ä¯ÀÀ¡¢ÉÌÆ·¹ºÂò¡¢¶©µ¥¹ÜÀíÒÔ¼°¸öÈËÐÅÏ¢¹ÜÀí¡£¹ÜÀíÔ±µÄÖ÷Òª¹¦ÄÜÓУºÉÌÆ·¹ÜÀí¡¢Óû§¹ÜÀíÒÔ¼°¶©µ¥ÐÅÏ¢¹ÜÀí¡£
È«ÎĹ²·ÖΪÎå¸ö²¿·Ö£¬µÚÒ»²¿·ÖÊǽéÉÜÏà¹ØÀíÂÛ֪ʶ£»µÚ¶þ²¿·Ö½éÉÜϵͳ×ÜÌåÉè¼Æ£»µÚÈý²¿·Ö½éÉÜϵͳ¾ßÌåʵÏÖ¹ý³Ì£»µÚËIJ¿·ÖÊDzâÊÔ¹¤×÷¡£×îºóÊǽáÂÛ¡£

¹Ø¼ü´Ê£ºµç×ÓÉÌÎñ£»¹ºÎïϵͳ£»JSP£»SQLÊý¾Ý¿â
 
The Design and Realization of shopping Online System Based on JSP
Abstract
In recent years, Internet has become the best channel for collection of information and entered the traditional field of circulation with the rapid rising. E-commerce has been popular, and more and more online stores are established on the Internet, displaying a new idea of shopping. This Shopping system based on B/S mode, realize the base function of the current Shopping site.
This paper introduces the Shopping system in detail. The main functions of people in system include login, registration, view and purchasing of goods, management of the Orders and customers. The main functions of administrator include management of the goods, users and Orders.
There are five sections in this paper, the first is introduction of Related theoretical knowledge; the second is introduction of the design of system; the third is introduction of the process of realization; the forth is test; and the conclusion in the end.

Key words: E-commerce; Shopping System; JSP; Databasei

Ä¿    ¼
¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª

Ð÷ ÂÛ

µÚÒ»½Ú¡¡ÏµÍ³·ÖÎö    ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨5£©
1.1 ÐèÇó·ÖÎö     ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨5£©
1.2  ¿ÉÐÐÐÔ·ÖÎö  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨5£©

µÚ¶þ½Ú  ×ÜÌåÉè¼Æ   ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨6£©
2.1 ÏîÄ¿¹æ»®    ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨7£©
2.2 ϵͳ¹¦Äܽṹͼ     ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨7£©

µÚÈý½Ú ϵͳÉè¼Æ    ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨8£©
3.1 Éè¼ÆÄ¿±ê    ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨8£©
3.2 ¿ª·¢¼°ÔËÐл·¾³    ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨9£©

µÚËÄ½Ú Êý¾Ý¿âÉè¼Æ  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨10£©
4.1 SQLÓïÑÔ¼ò½é   ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨10£©
4.2 Microsoft SQL Server ¼ò½é ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­  £¨11£©
4.3 AVA¼¼Êõ¼ò½é ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨12£©
4.4 TOMCAT¼ò½é ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨13£©
4.5 Êý¾Ý¿âÐèÇó·ÖÎö ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨13£©
4.5.1  Êý¾Ý¿âµÄÂß¼­½á¹¹·ÖÎö  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨14£©
4.5.2  Êý¾Ý¿â±íµÄÉè¼Æ  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨14£©

µÚÎå½Ú  ¾ßÌåÉè¼Æ·ÖÎö  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨15£©
5.1 ϵͳÊ×Ò³   ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨15£©
5.2 ¾ßÌåÄ£¿éʵÏÖ ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨17£©
5.2.1  ÉÌÆ·²é¿´  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨18£©
5.2.2  ¹ºÎï³µ  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨20£©
5.2.3  ¶©µ¥¹ÜÀí  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨23£©
5.2.4  Óû§¸öÈËÐÅÏ¢¹ÜÀí  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨24£©
5.2.5  Óû§¿Ø¼þ  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨25£©
5.2.6  ÉÌÆ·¹ÜÀí  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨27£©
5.2.7  ¹ÜÀíÓû§  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨27£©

µÚÁù½Ú  ϵͳ²âÊÔ  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨28£©
6.1 ǰ̨²âÊÔ  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨29£©
6.2 ºǫ́²âÊÔ  ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨29£©

½á¡¡ÂÛ   ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨30£©

ºó  ¼Ç   ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨31£©

¸½ ¼    ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨32£©

²Î¿¼ÎÄÏ×   ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­   £¨33£©

Ð÷ ÂÛ
ÔÚ21ÊÀ¼ÍµÄ½ñÌ죬ÍøÂç³ÉΪ¹¤×÷¡¢Ñ§Ï°ºÍÒ»ÖØÒª²¿·Ö£¬³äʵ×ÅÈËÃǵÄÉú»î¡£×÷ΪÍøÂçÊÀ½çµÄÖ§³ÅµãµÄÍøÕ¾£¬¸üÊÇÈËÃǹØ×¢µÄÈȵ㣺Õþ¸®ÀûÓÃÍøÕ¾Ðû´«×Ô¼ºµÄÊ©Õþ¸ÙÁ죬ÈÕÒæ³ÉΪÓë°ÙÐÕ½»Á÷µÄֱͨ³µ£»ÆóÒµÀûÓÃÍøÕ¾Ðû´«×Ô¼ºµÄÐÎÏ󣬽ø¶øÍÚ¾òÎÞÏÞÉÌ»ú£»¸öÈËÀûÓÃÍøվչʾ¸öÐÔ·ç²É£¬´´½¨±Ë´Ë¹µÍ¨µÄÇÅÁº¡£Ô½À´Ô½¶àµÄÆóÒµºÍ¸öÈËÏ£ÍûÓµÓÐ×Ô¼ºµÄÍøÕ¾£¬¿ª±ÙÍøÂçÊÀ½çÀïµÄһƬÌìµØ¡£

½üÄêÀ´£¬Ëæ×ÅInternetµÄѸËÙáÈÆ𣬻¥ÁªÍøÒÑÈÕÒæ³ÉΪÊÕ¼¯ÌṩÐÅÏ¢µÄ×î¼ÑÇþµÀ²¢Öð²½½øÈ봫ͳµÄÁ÷ͨÁìÓò¡£ÓÚÊǵç×ÓÉÌÎñ¿ªÊ¼Á÷ÐÐÆðÀ´£¬Ô½À´Ô½¶àµÄÉ̼ÒÔÚÍøÉϽ¨ÆðÔÚÏßÉ̵꣬ÏòÏû·ÑÕßչʾ³öÒ»ÖÖÐÂÓ±µÄ¹ºÎïÀíÄî¡£

ÍøÉ϶©¹ºÏµÍ³×÷ΪB2B,B2C,C2Cµç×ÓÉÌÎñµÄÇ°¶ËÉÌÎñƽ̨,ÔÚÆäÉÌÎñ»î¶¯È«¹ý³ÌÖÐÆðמÙ×ãÇáÖصÄ×÷Óᣱ¾ÎÄÖ¼ÔÚÌÖÂÛÈçºÎ½¨ÉèB2CµÄÍøÉϹºÎïϵͳ¡£ÍøÉϹºÎïÊÇÒ»ÖÖ¾ßÓн»»¥¹¦ÄܵÄÉÌÒµÐÅϢϵͳ¡£ËüÏòÓû§Ìṩ¾²Ì¬ºÍ¶¯Ì¬Á½ÀàÐÅÏ¢×ÊÔ´¡£Ëùν¾²Ì¬ÐÅÏ¢ÊÇÖ¸ÄÇЩ±È¾­³£±ä¶¯»ò¸üеÄ×ÊÔ´£¬È繫˾¼ò½é¡¢¹ÜÀí¹æ·¶ºÍ¹«Ë¾Öƶȵȵȣ»¶¯Ì¬ÐÅÏ¢ÊÇÖ¸Ëæʱ±ä»¯µÄÐÅÏ¢£¬ÈçÉÌÆ·±¨¼Û£¬»áÒé°²ÅźÍÅàѵÐÅÏ¢µÈ¡£ÍøÉϹºÎïϵͳ¾ßÓÐÇ¿´óµÄ½»»¥¹¦ÄÜ£¬¿ÉʹÉ̼ҺÍÓû§·½±ãµÄ´«µÝÐÅÏ¢£¬Íê³Éµç×ÓóÒ×»òEDI½»Òס£ÕâÖÖȫеĽ»Ò×·½Ê½ÊµÏÖÁ˹«Ë¾¼äÎĵµÓë×ʽðµÄÎÞÖ½»¯½»»»¡£