ºþÄϹ¤Òµ´óѧ±¾¿Æ±ÏÒµÉè¼Æ£¨ÂÛÎÄ£©
Õª Òª
ͼÊ鳬ÊÐÏÖÒѱȽϳÉÊ죬Ëü¿ÉÒÔÔÚ×î¿ì¡¢×î¶ÌµÄʱ¼äÄÚ¸æÖªÈËÃÇÐÂ֪ʶ£¬Èôó¼Ò¿ÉÒÔÔÚûÊéµÄÇé¿öϾÍÄÜÏíÊܶÁÊéµÄÀÖȤ£¬Í¬Ê±Ê¹¹Ë¿ÍÄÜ×ã²»³ö»§¾Í¹ºµÃÊé¡£ËüµÄ¹¦ÄÜÒ²Öð½¥ÍêÉÆ£¬´Ó»ù±¾µÄ¶ÔÍ⹵ͨչʾ¹¦ÄÜ¡¢ÐÅÏ¢·¢²¼¹¦ÄÜ¡¢ÔÚÏßͼÊéչʾ¹¦ÄÜ£¬µ½ÔÚÏßǢ̸¹¦ÄÜ¡¢ÔÚÏß½»Ò×¹¦ÄÜ¡¢ÔÚÏ߲ɹº¹¦ÄÜ¡¢ÔÚÏ߿ͻ§·þÎñ¹¦ÄÜ¡¢ÔÚÏßÍøÕ¾¹ÜÀí¹¦Äܵȵȣ¬¼¸ºõÒÔÍù´«Í³Êéµê¹¦Äܶ¼¿ÉÒÔÔÚ»¥ÁªÍøÉϽøÐеç×Ó»¯µÄ¸ßЧÔË×÷¡£¡£
µç×ÓÉÌÎñÊÇÒ»ÖÖ»ùÓÚWebƽ̨µÄÐÂÐÍÉÌÎñģʽ£¬Ëü³É¹¦µÄÀûÓÃÁË»¥ÁªÍø·á¸»µÄ×ÊÔ´´ïµ½ÁËÉÌÒµ½»Ò×µÄÄ¿µÄ£¬Ê¹·þÎñÉÌÓë¹Ë¿ÍÖ®¼ä½øÐз½±ã¿ì½ÝµÄ¶àÑù»¯µÄÉÌÎñ¹¦ÄܳÉΪ¿ÉÄÜ¡£±¾ÎÄÖ÷Òª½éÉÜÁËÍøÉÏͼÊ鳬ÊÐϵͳµÄʵÏÖ¹ý³Ì¡£ÏµÍ³²ÉÓÃJAVA·þÎñÆ÷¶Ë¼¼Êõ¼´JSP¼¼Êõ£¬»ùÓÚ¿Í»§¶ËµÄBrowser/ServerµÄģʽ¿ª·¢¡£²ÉÓÃDreamwaver MX 2004×÷Ϊǰ̨¿ª·¢¹¤¾ß£¬ÒÔJDK×÷ΪJavaBean¡¢servletµÄ¿ª·¢¹¤¾ß£¬Microsoft SQL Server 2000 ×÷Ϊºǫ́Êý¾Ý¿âµÄ¿ª·¢¹¤¾ß¡£ÔÚWindows XPϵͳÖÐʹÓÃODBC-JDBCÁ¬½ÓÇż¼Êõ½øÐÐÊý¾Ý¿âÁ¬½Ó¡£
ϵͳÓÉÍøÕ¾Ç°Ì¨ºÍºǫ́¹¹³É¡£Ç°Ì¨Ö÷Òª°üÀ¨Óû§×¢²áÓëµÇ¼¡¢Í¼Êéչ̨¡¢ÍøÉϵ÷²é¡¢¹ºÎï³µ¡¢ÊÕÒøÌ¨¡¢¶©µ¥²éѯµÈÄ£¿é¡£ºǫ́Ö÷Òª°üÀ¨¹ÜÀíÔ±µÇ¼¡¢Í¼Êé¹ÜÀí¡¢Óû§¹ÜÀí¡¢¶©µ¥¹ÜÀí¡¢¹«¸æ¹ÜÀí¡¢Í¶Æ±¹ÜÀíµÈÄ£¿é¡£ÊµÏÖÁË»ù±¾µÄÓû§¹ºÊéÁ÷³Ì£¬°üÀ¨Óû§×¢²á¡¢µÇ¼¡¢²é¿´Í¼ÊéÐÅÏ¢¡¢Ìîд¡¢²é¿´¡¢Ð޸ĺÍÌá½»¶©µ¥¡¢½áÕÊ¡¢Ö´ÐÐËÍ»õµÈ¹¦ÄÜ¡£
¹Ø¼ü´Ê£ºJSP¼¼Êõ£¬ÍøÉÏÊéµê£¬µç×ÓÉÌÎñ
Ŀ ¼
µÚ1Õ Ð÷ÂÛ .................................................. ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£
I
ºþÄϹ¤Òµ´óѧ±¾¿Æ±ÏÒµÉè¼Æ£¨ÂÛÎÄ£©
1.1 ¿ÎÌâ±³¾° ....................................... ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£ 1.2 ϵͳ¿ª·¢¹Ø¼ü¼¼Êõ½éÉÜ ........................... ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£ 1.3 JDBC¼ò½é ....................................... ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£ 1.4 JavaBean¼¼Êõ½éÉÜ ............................... ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£
µÚ2Õ ϵͳÐèÇó·ÖÎö .................................. ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£
2.1 Êг¡ÐèÇó·ÖÎö ................................... ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£ 2.2 Óû§ÐèÇó·ÖÎö ................................... ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£ 2.3 ϵͳÖ÷Òª¹¦ÄÜÐèÇó ............................... ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£
µÚ3Õ ϵͳÉè¼Æ ........................................................................ - 5 -
3.1 Óû§½Ó¿ÚÄ£¿é ................................................ - 5 - 3.2 ¹ÜÀíÔ±½Ó¿ÚÄ£¿é ................................. ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£ 3.3 Êý¾Ý·þÎñ½Ó¿ÚÄ£¿é ............................... ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£
µÚ4Õ Êý¾Ý¿âÉè¼Æ ............................................... ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£
4.1 Êý¾Ý¿â¸ÅÄî½á¹¹Éè¼Æ ............................. ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£
4.1.1 ϵͳE-RͼÉè¼Æ ............................ ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£ 4.1.2 Êý¾Ý¿âµÄ±í½á¹¹ ............................ ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£
µÚ5Õ ϵͳÉè¼ÆÓë±àÂë ....................................... ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£
5.1 ϵͳµÄÒ³Ãæ°²ÅÅ ................................. ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£ 5.2 ϵͳ¿ª·¢ÓëÔËÐл·¾³ ............................. ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£ 5.3 Êý¾Ý¿âÁ¬½Ó ..................................... ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£ 5.4 ϵͳ½çÃæÉè¼Æ ................................... ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£
5.4.1 ¹ÜÀíԱģ¿éÉè¼Æ ............................ ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£ 5.4.2 ͼÊé¹ÜÀíÄ£¿éÉè¼Æ .......................... ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£ 5.4.3 Óû§¹ÜÀíÄ£¿éÉè¼Æ .......................... ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£ 5.4.4 ÖØµãÍÆ¼öչ̨ģ¿éÉè¼Æ ...................... ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£ 5.4.5 ÐÂÊéÉϼÜÄ£¿éÉè¼Æ ....................................... - 8 - 5.4.6 ͼÊé·ÖÀàÄ£¿éÉè¼Æ .......................... ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£ 5.4.7 ÏúÊÛÅÅÐÐÄ£¿éÉè¼Æ .......................... ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£ 5.4.8 ¹ºÎﳵģ¿éÉè¼Æ ........................................... - 9 - 5.4.9 ¶©µ¥Ä£¿éÉè¼Æ .............................. ´íÎó£¡Î´¶¨ÒåÊéÇ©¡£
II
ºþÄϹ¤Òµ´óѧ±¾¿Æ±ÏÒµÉè¼Æ£¨ÂÛÎÄ£©
µÚ6Õ ϵͳ²âÊÔ ............................................................................ 35
6.1 ϵͳ²âÊÔ¸ÅÊö ................................................... 35
6.1.1²âÊÔÄ¿±ê .................................................. 35 6.1.2ϵͳ²âÊÔÐèÇó»·¾³ .......................................... 35 6.2²âÊÔÑо¿ÓëÑ¡Ôñ .................................................. 36 6.3ϵͳ²âÊÔÏêϸÄÚÈÝ ................................................ 36 6.4ϵͳ²âÆÀ½á¹û·ÖÎö ................................................ 38
½á ÂÛ ................................................................................................ 39 ²Î¿¼ÎÄÏ× ............................................................................................ 40 Ö л ............................................................................................. ...41
Æäǰ̨¹¦ÄܽṹͼÈç2.1Ëùʾ£º
ÍøÉÏͼÊ鳬ÊÐǰ̨ͼÊéÕ¹Ì¨ÍøÉϵ÷²é¹ºÎï³µÊÕÒøÌ¨»áÔ±¹ÜÀí¶©µ¥²éÑ¯ÖØµãÍÆ¼öÐÂÊéÉϼÜͼÊé·ÖÀàä¯ÀÀÏúÊÛÅÅÐÐÍøÉϵ÷²é²é¿´µ÷²é½á¹ûÌí¼ÓÖÁ¹ºÎï³µ²é¿´¹ºÎï³µÒÆ³ýͼÊéÇå¿Õ¹ºÎï³µÌîд¶©µ¥ÐÅÏ¢¹ºÊé½áÕË»áÔ±×¢²á»áÔ±µÇ¼»áÔ±×ÊÁÏÐ޸Ķ©µ¥²éѯ ͼ2.1 ¿Í»§½çÃæÏµÍ³¹¦ÄÜÄ£¿é
ºǫ́Ö÷ÒªÊǶÔÓÚ»áÔ±Óû§¡¢Í¼ÊéºÍ¶©µ¥µÈ½øÐÐһЩ±ØÒªµÄ¹ÜÀí¹¤×÷£¬Ç¿´óµÄºǫ́¹¦ÄÜÄܰѸ´ÔӵĴ¦Àí¹¤×÷±äµÃ¼òµ¥¡¢¿ì½Ý¡¢¸ßЧ¡£
Æäºǫ́¹¦ÄܽṹͼÈçͼ2.2Ëùʾ£º
III
ºþÄϹ¤Òµ´óѧ±¾¿Æ±ÏÒµÉè¼Æ£¨ÂÛÎÄ£©¹ý³Ì¹ÜÀí×ÊÁÏ
ÍøÉÏͼÊ鳬Êкǫ́ͼÊé¹ÜÀíÓû§¹ÜÀí¶©µ¥¹ÜÀí¹«¸æ¹ÜÀíͶƱ¹ÜÀíÍ˳ö²é¿´Í¼ÊéÐÅÏ¢Ìí¼ÓͼÊéÐÅÏ¢ÐÞ¸ÄͼÊéÐÅϢɾ³ýͼÊéÐÅÏ¢²é¿´Óû§ÐÅÏ¢¶³½á/½â¶³Óû§²é¿´¶©µ¥ÐÅÏ¢Ö´Ðж©µ¥²é¿´¹«¸æÐÅÏ¢Ìí¼Ó¹«¸æÐÅϢɾ³ý¹«¸æÐÅÏ¢ä¯ÀÀͶƱÏîÄ¿Ìí¼ÓͶƱÏîĿɾ³ýͶƱÏîÄ¿Í˳öºǫ́¹ÜÀí ͼ2.2 ºǫ́¹¦Äܽṹͼ
ÍøÉÏͼÊéÏúÊÛϵͳÒÔÆäÇ¿´óµÄ¹¦ÄÜ»ñµÃÁËÀÏʦ¡¢Í¬Ñ§ÃǵijÆÔÞ¡£Í¨¹ýºÏÀíµÄÉè¼ÆºÍ¾«ÐĵIJ¼Öã¬ÇåÎúµÄÊý¾ÝÁ÷Ïò£¬Ê¹µÃϵͳͨË×Ò×¶®¡£²Ù×÷¼ò½Ý¡¢·½±ã¡£Ò²±ãÓÚ¹ÜÀíÔ±½øÐкÏÀíµÄ¹ÜÀí¡£
ÆäÊý¾ÝÁ÷³ÌͼÈçͼ2.3Ëùʾ£º
¿ªÊ¼ÖØÐµÇÂ¼ÖØÐµÇ¼Í˳öµÇ¼ʧ°Ü¹ÜÀíÔ±µÇ¼Óû§µÇ¼µÇ¼ʧ°ÜÍ˳öÏÖÓÐͼÊé¹ÜÀíÌí¼ÓÐÂͼÊéÌí¼ÓͼÊé·ÖÀà¶©µ¥¹ÜÀíÓû§¹ÜÀíÔÚÏß¹ºÊé²é¿´¹ºÎï³µ²é¿´¶©µ¥ÐÅϢͼÊé²éѯ¹ºÊé²é¿´Í¼Êé¿Í»§×¢²áµÇ¼
ͼ2.3 Êý¾ÝÁ÷³Ìͼ
- 4 -

