Õª Òª
Ëæ×Å»¥ÁªÍøºÍ¿í´øÉÏÍøµÄÆÕ¼°£¬µç×ÓÉÌÎñÔÚÖйú¸üÊÇÒì¾üÍ»Æ𣬲¢ÈÕÒæÉø͸µ½ÈËÃǵÄÈÕ³£Éú»îÖС£ÍøÉÏÉÌÆ·½»Ò׸üÊÇÆäÖØÒªÄÚÈÝ¡£¸÷ÖÖÍøÉÏÉÌÆ·½»Ò×ÍøÕ¾²ã³ö²»Çî¡£
±¾¿ÎÌâÉè¼ÆµÄÄ¿±êÊÇʵÏÖÒ»¸ö»ùÓÚJsp+JavaBeanģʽµÄµç×ÓÉ̳ÇÍøÕ¾¡£ÂÛÎÄÏȽéÉÜÁË¿ª·¢ÏîÄ¿ËùÓõ½µÄ¹Ø¼ü¼¼Êõ£¬½Ó×Å´ÓÓû§ÐèÇó¡¢¾¼ÃºÍ¼¼ÊõµÈÈý¸ö·½Ãæ¶Ôϵͳ½øÐзÖÎö¡£ÔÚ¸ÅÒªÉè¼ÆÖУ¬¸ù¾Ýϵͳ·ÖÎöµÄ½á¹û£¬°Ñϵͳ·ÖΪǰ̨ºÍºǫ́Á½´óÄ£¿é¡£¸ù¾Ýǰ̨ºÍºǫ́Óû§µÄ²»Í¬ÐèÇ󣬰Ñǰ̨ϸ·ÖΪ»áÔ±µÇ¼ע²á£¬ÉÌÆ·²éѯ£¬ÉÌÆ·¹ºÂò£¬¶©µ¥²éѯµÈÄ£¿é£¬°Ñºǫ́ϸ·ÖΪ¹ÜÀíÔ±µÇ¼£¬ÉÌÆ·ÉèÖ㬶©µ¥ÉèÖõÈÄ£¿é¡£Ïêϸ½éÉÜÁËÔÚ»ùÓÚJsp+JavaBeanģʽϸ÷¸öÄ£¿éµÄʵÏÖ¹ý³Ì£¬ÇÒÒÔ¿ª·¢¹ý³ÌΪ»ù´¡ÊµÏÖϵͳËù¾ßÓеĿÉÖØÓÃÐÔ¡¢¿Éά»¤ÐԺͿÉÀ©Õ¹ÐÔµÈÓÅÊƽøÐÐÁË·ÖÎö¡£
¹Ø¼ü´Ê eclipse¿ª·¢¹¤¾ß£¬µç×ÓÉ̳ǣ¬ÍøÕ¾°²È«
ABSTRACT
With the popularization of Internet and accessing broadband network, e-commerce in China has suddenly appeared, and increasingly penetrates into daily life. Online commodity trading is an important. Online commodities trading website is increasing day by day.
The aim of this subject is designing an electronic mall site based on the Jsp+JavaBean model. Firstly, this paper introduced the key techniques for using techniques of the development projects. Then it analyzed the system according to user's needs, economic environment and techniques. In the summary design and according to the analysis results, system is divided into two modules. According to the different needs of users, requirements are divided into the sub-member login registered module, merchandise query module, purchase module, and orders inquiry module. Background is divided into sub-administrator login module, setup of merchandise module, and orders module. This paper described implementation process of various modules based on the Jsp+JavaBean model struts framework.. And according to the development, process analyzes the system reuse, maintainability, and scalability advantages based on the struts framework in detail.
Keywords eclipse development tool, electronic mall, website security
Ç° ÑÔ
»¥ÁªÍø´ÓËü³öÏÖ¿ªÊ¼¾Í²»½ö¸Ä±äÁËÐÅÏ¢´«µÝµÄ·½Ê½£¬Í¬Ê±¸Ä±ä×ÅÆóÒµµÄÔËӪģʽ£¬¹ÜÀíģʽ£¬Ó°Ïì×ÅÈËÃǵÄÉú»î¹ÛÄ¸Ä±ä×ÅÈËÃǵÄÏ°¹ß¡£ÍøÂçʹÈËÃÇ×ã²»³ö»§¾ÍÄÜ»ñÈ¡¸÷·½ÃæµÄÐÅÏ¢£¬¶øµç×ÓÉ̳ǵijöÏÖ¸üÊÇÈËÃÇ×ã²»³ö»§¾Í¿ÉÒÔ½øÐÐÉÌÆ·½»Ò׻¡£
»¥ÁªÍøµÄÐËÆð´Ó±¾ÖÊÉϸıäÁËÕû¸öÉç»áµÄÉÌÆ·½»Ò×·½Ê½£¬¹úÄÚ¸÷´óÆóÒµ´ÓÉϸöÊÀ¼Í90Äê´ú»¥ÁªÍøÐËÆð֮ʱ£¬¾Í²úÉúÁËͨ¹ýÍøÂç½øÐÐÏúÊÛ¾ÓªÉÌÆ·µÄÏë·¨¡£µ«ÊÇÓÉÓÚÔÚ»¥ÁªÍøÉÏÆóÒµµÄÐÅÓþÄÑÒÔÈÏÖ¤¡¢ÍøÂç·¨¹æÕþ²ß²»½¡È«¡¢ÎïÁ÷²»·¢´ïµÈһϵÁеÄÔÒò£¬ÏÞÖÆÁËÍøÉϽ»Ò×·¢Õ¹µÄ²½·¥¡£½øÈë21ÊÀ¼ÍÒÔºó£¬Ëæ×ÅÕû¸öÉç»áµÄ·¢Õ¹¡¢½ø²½£¬ÖÆÔ¼ÍøÉϽ»Ò׵ĸ÷¸öÆ¿¾±ÎÊÌâÖðÒ»±»»÷ÆÆ£¬¸÷ÆóÒµÒ²·×·×µÄ¼ÓÈëµ½µç×ÓÉÌÎñµÄºé³±Ö®ÖС£
ÊõÓïÁÐ±í£º
JSP£º£¨Java Server Pages£©£¬JSPÊÇÒ»ÖÖ»ùÓÚJavaµÄ¼¼Êõ£¬ÓÃÀ´²úÉú¿çƽ̨ºÍ¿çWeb·þÎñÆ÷µÄ¶¯Ì¬Ò³Ãæ¡£
JDBC:(Java Database Connectivity),JavaÊý¾Ý¿âÁ¬½Ó¡£ËüÖ÷ÒªÊÇÒ»Ì×ÈÃÄã·ÃÎÊÊý¾Ý¿âµÄAPI£¬³ÌÐòÈËÔ±¿ÉÒÔÀûÓÃJDBC APIÀ´Ö´ÐÐSQLÓï¾ä¡£
Servlet: Servlet¿ÉÒÔ³Æ֮Ϊ¡°·þÎñÆ÷С³ÌÐò¡±£¬ÓëJava application²»Í¬£¬ËüûÓÐmain·½·¨£¬¶øÊÇÓÃһЩÌض¨µÄ·½·¨ÓÃÓÚÆô¶¯¡¢Ö´ÐкÍÍ˳ö¡£Í¨¹ýʹÓÃServlet£¬¿ÉÒÔÓëÔËÐÐÓë¿Í»§¶ËµÄApplet½øÐн»»¥£¬Ò²¿ÉÒÔÖ±½ÓÓëHTMLÒ³½øÐн»»¥¡£
JavaBeans: JavaBeansÊǿɸ´ÓõÄƽ̨ÖÐÁ¢µÄÈí¼þ×é¼þ£¬¿ÉÒÔÔÚÈí¼þ¿ª·¢¹¤¾ßÖб»Ö±¹ÛµØ²Ù×÷¡£Ó¦ÓóÌÐò¿ª·¢Õß¿ÉÒÔͨ¹ýÖ§³ÖJavaBeansµÄ¿ª·¢¹¤¾ß£¬Ö±½ÓʹÓÃÏֳɵÄJavaBeans,Ò²¿ÉÒÔÔÚ¿ª·¢¹¤¾ßÈÝÆ÷ÖУ¬¶Ô×é¼þ½øÐбØÒªµÄÐ޸ġ¢²âÊÔ¶ø²»±Ø±àдºÍ±àÒë³ÌÐò¡£ÔÚJavaÄ£ÐÍÖУ¬×é¼þ¿ÉÒÔÐ޸ĻòÓëÆäËû×é¼þ×éºÏÒÔÉú³ÉÐÂ×é¼þ»òÍêÕûµÄÓ¦ÓóÌÐò¡£
HTML£º(Hypertext Markup Language)³¬Îı¾±ê¼ÇÓïÑÔ£¬ËüÊÇ×éÖ¯¶àýÌåÎĵµµÄÖØÒªÓïÑÔ£¬Ëü²»½öÓÃÀ´±àдWebÍøÒ³£¬¶øÇÒ¿ÉÒÔʹÓÃËüÀ´ÖÆ×÷¹âÅÌÉϵĶàýÌå½ÚÄ¿¡£HTML¿ÉÓÃÀ´±àÅÅÎĵµ¡¢´´½¨ÁÐ±í¡¢½¨Á¢Á´½ÓµÈµÈ¡£
XML:£¨extensible Markup Language£©¿ÉÀ©Õ¹±ê¼ÇÓïÑÔ£¬ËüÊÇÒ»ÖÖ¾ßÓÐÊý¾ÝÃèÊö¹¦ÄÜ(Meta-language)¡¢¸ß¶È½á¹¹ÐÔ¼°¿ÉÑéÖ¤ÐÔµÄÓïÑÔ¡£
SQL:£¨Structured Query Language£©£¬½á¹¹»¯²éѯÓïÑÔ¡£SQLÓïÑÔµØÈÎÎñ¾ÍÊÇÓë¸÷ÖÖÊý¾Ý¿â½¨Á¢¹Øϵ£¬SQLÓïÑÔÊǹØϵÐÍÊý¾Ý¿âµÄ±ê×¼ÓïÑÔ£¬´ó¶àÊý¹ØϵÐÍÊý¾Ý¿â¹ÜÀíϵͳ¶¼Ö§³ÖSQLÓïÑÔ²¢²ÉÓÃÁËSQLµÄÓïÑÔ±ê×¼¡£
MySQL:MySQLÊÇÒ»¸ö¿ÉÓÃÓÚ¸÷ÖÖÁ÷ÐвÙ×÷ϵͳƽ̨µÄ¹ØϵÊý¾Ý¿âϵͳ£¬Ëü¾ßÓпͻ§»ú/·þÎñÆ÷Ìåϵ½á¹¹µÄ·Ö²¼Ê½Êý¾Ý¿â¹ÜÀíϵͳ¡£°´ÕÕʹÓÃÓÖ¿ÉÒÔ·ÖΪDML(Data Manipulation Language),¼´Êý¾Ý²Ù×÷ÓïÑÔºÍDDL(Data Definition Language)¡£
Ŀ ¼
Õª Òª 2
ABSTRACT 3
Ç° ÑÔ 4
Ŀ ¼ 6
µÚÒ»Õ ϵͳ¸ÅÊö 8
µÚÒ»½Ú ¿ÎÌâ±³¾°ÓëÒâÒå 8
Ò»¡¢¿ÎÌ⿪·¢±³¾° 8
¶þ¡¢¿ÎÌ⿪·¢ÒâÒå 8
µÚ¶þ½Ú ¿ÎÌ⿪·¢¹¤¾ßÓë»·¾³ 9
Ò»¡¢JAVAºÍJSP¼¼Êõ¼ò½é 9
¶þ¡¢SQL Server 2005 ·þÎñÆ÷SQL Server¸ÅÊö 10
Èý¡¢Tomcat 6.0·þÎñÆ÷¼Ü¹¹ 13
ËÄ¡¢×ÜÌ忪·¢ 14
µÚ¶þÕ ϵͳ·ÖÎö 15
µÚÒ»½Ú ϵͳ¸ÅÊö 15
Ò»¡¢ÏµÍ³·ÖÎöÔÔòÓë·½Õë 15
¶þ¡¢ÏµÍ³ÐèÇó 15
µÚ¶þ½Ú ϵͳ¹¦ÄÜ·ÖÎö 16
Ò»¡¢ ¿ÉÐÐÐÔ·ÖÎö£º 16
¶þ¡¢ ¾ßÌ幦ÄÜ·ÖÎö£º 16
µÚÈýÕ ϵͳÉè¼Æ 17
µÚÒ»½Ú Êý¾Ý¿âÉè¼Æ 17
Ò»¡¢Êý¾Ý¿â×ÜÌåÉè¼Æ 17
¶þ¡¢Êý¾Ý¿â¸ÅÄîÉè¼Æ 18
Èý¡¢Êý¾Ý¿âÂß¼Éè¼Æ 20
µÚ¶þ½Ú ϵͳ×ÜÌåÉè¼Æ 23
Ò»¡¢×ÜÌåÉè¼Æ 23
¶þ¡¢ÏµÍ³Âß¼´¦Àí 24
µÚÈý½Ú ¹¦ÄÜÉè¼Æ 25
Ò»¡¢Ç°Ì¨Óû§¹¦ÄÜÄ£¿éÉè¼Æ 25
¶þ¡¢ºǫ́Óû§¹¦ÄÜÄ£¿éÉè¼Æ 27
µÚËÄÕ ϵͳʵÏÖÓëµ÷ÊÔ 29
µÚÒ»½Ú ϵͳʵÏÖ¸ÅÂÛ 29
Ò»¡¢ ½á¹¹»¯³ÌÐò±àÂëÔÔò 29
µÚ¶þ½Ú ϵͳ¹¦ÄÜʵÏÖ 29
Ò»¡¢ Îļþ½á¹¹Í¼ 29
¶þ¡¢ ÎļþÏêϸ½á¹¹Í¼ 30
µÚÈý½Ú ¹Ø¼ü¼¼ÊõʵÏÖ 30
Ò»¡¢web.xml 30
¶þ¡¢ Êý¾Ý¿âdb_shopSystemÁ¬½Ó²¿·Ö 31
µÚËÄ½Ú µ÷ÊÔ¹ý³ÌÖеij£¼û´íÎó 32
Ò»¡¢JDKÅäÖôíÎó 32
¶þ¡¢SQL¿ÕÖ¸ÕëÒì³£ 33
Èý¡¢Êý¾Ý¿âÁ¬½Ó´íÎó 33
µÚÎåÕ ϵͳ²âÊÔ¼°½á¹û½Øͼ 34
Ò»¡¢ÏµÍ³Ö÷½çÃæ 34
¶þ¡¢Óû§×¢²á½çÃæ 35
Èý¡¢¸öÈË×ÊÁϹÜÀí 35
ËÄ¡¢Òâ¼û·´À¡ 36
Îå¡¢ÎҵĹºÎï³µ 36
Áù¡¢Éú³É¶©µ¥ 37
Æß¡¢ºǫ́¹ÜÀíÖ÷½çÃæ 37
µÚÁùÕ ½áÊøÓï 38
Ö л 39
²Î¿¼ÎÄÏ× 40
¸½ ¼ 41
Ò»¡¢Ó¢ÎÄÔÎÄ£º 41
¶þ¡¢Ó¢ÎÄ·Ò룺 48
µÚÒ»Õ ϵͳ¸ÅÊö
µÚÒ»½Ú ¿ÎÌâ±³¾°ÓëÒâÒå
Ò»¡¢¿ÎÌ⿪·¢±³¾°
20ÊÀ¼Í£¬Ëæ׿ÆËã»ú¿ÆѧµÄ·¢Õ¹£¬Êý¾Ý¿â¼¼ÊõÔÚInternet ÖеÄÓ¦ÓÃÔ½À´Ô½¹ã·º£¬Îª¹ã´óÍøÂçÓû§ÌṩÁ˸ü¼ÓÖܵ½ºÍÈËÐÔ»¯µÄ·þÎñ¡£¸öÐÔ»¯ÒÑÖð½¥³ÉΪµ±½ñWedÓ¦Óõij±Á÷¡£±¾ÎÄÑо¿ÁËÒ»ÖÖ»ùÓÚÊý¾Ý¹ØÁª¹æÔò²É¼¯¼¼ÊõµÄÓû§¸öÐÔ»¯Ò³Ã涯̬Éú³É·½°¸£¬´Ë·½°¸ÓëÏÖ½ñÍøÉÏÒѲÉÓõÄһЩ·½°¸Ïà±È£¬¾ßÓÐÓû§Ê¹Óøü¼òµ¥¡¢·´Ó³Óû§¸üÃ÷ÏÔϸÖµÈÓŵ㡣
Ëùνµç×ÓÉ̳ǾÍÊÇÔÚÍøÉÏ¿ªÕ¹¹ºÎïÉÌÎñ»î¶¯£¬µ±ÆóÒµ½«ËüµÄÖ÷ÒªÒµÎñͨ¹ýÆóÒµÄÚ²¿Íø£¨Intranet£©¡¢ÍⲿÍø£¨Extranet£©ÒÔ¼°InternetÓëÆóÒµµÄÖ°Ô±¡¢¿Í»§¹©ÏúÉÌÒÔ¼°ºÏ×÷»ï°éÖ±½ÓÏàÁ¬Ê±£¬ÆäÖз¢ÉúµÄ¸÷Öֻ¾ÍÊǵç×ÓÉ̳ǡ£µç×ÓÉ̳ÇÊÇ»ùÓÚInternet»ò¾ÖÓòÍø¡¢¹ãÓòÍø¡¢°üÀ¨ÁË´ÓÏúÊÛ¡¢Êг¡µ½ÉÌÒµÐÅÏ¢¹ÜÀíµÄÈ«¹ý³Ì¡£±¾ÏµÍ³µÄ¿ª·¢Õý·ûºÏÁËÕâÒ»ÒªÇó¡£ÂÛÎÄÖÐÏêϸ²ûÊöÁËϵͳµÄÉè¼ÆÄ¿±ê¡¢×ÜÌå¼Ü¹¹¼°¸÷¹¦ÄÜÄ£¿éµÄÏêϸÉè¼Æ¡£