Ŀ ¼
µÚÒ»Õ ǰÑÔ .............................................................................................................................................. 5
1.1Ñ¡ÌâµÄ±³¾°¼°ÒâÒå .................................................................................................. 5 1.2ÆóÒµÎĵµ¹ÜÀíϵͳµÄÏÖ×´ ...................................................................................... 6 1.3±¾ÎÄÑо¿µÄÄ¿±ê ...................................................................................................... 6
µÚ¶þÕ HYPERLINK \\L _TOC2931 ϵͳ¿ª·¢¹¤¾ß............................................................................. 7
2.1 .NET¿ª·¢»·¾³ ......................................................................................................... 7 2.2Êý¾Ý¿â¹¤¾ßÑ¡Ôñ-SQLSERVER2008 R2 ................................................................ 7
µÚÈýÕ ÐèÇó·ÖÎö ...................................................................................................................................... 9
3.1 ϵͳÐèÇó¸ÅÊö ......................................................................................................... 9 3.2ϵͳµÄ¿ÉÐÐÐÔ·ÖÎö ................................................................................................ 10 3.3ϵͳµÄ¹¦ÄÜÐÍÐèÇó ................................................................................................ 10 3.4 ϵͳµÄ·Ç¹¦ÄÜÐÔÐèÇó ........................................................................................... 11
µÚËÄÕ Îĵµ¹ÜÀíϵͳµÄÉè¼ÆÓëʵÏÖ .................................................................................................... 12
4.2Êý¾Ý¿âÉè¼Æ ............................................................................................................ 12 4.3ϵͳʵÏÖ ................................................................................................................ 15
4.3.1 Óû§µÇ¼ ....................................................................................................... 15 4.3.2 ²úƷά»¤Éè¼Æ ............................................................................................... 16 4.3.3 ²úƷĿ¼Ã÷ϸ ............................................................................................... 18 4.3.4 ÎļþÉÏ´«ÓëÏÂÔØ ........................................................................................... 20 4.3.5 Îĵµ²éѯ ....................................................................................................... 22
µÚÎåÕ ½áÂÛ ............................................................................................................................................ 24 ²Î¿¼ÎÄÏ× .................................................................................................................................................. 25 ÖÂл .......................................................................................................................................................... 26
- 4 -
µÚÒ»Õ ǰÑÔ
Éç»áµÄ·¢Õ¹ÊǶàÔª»¯µÄ£¬Ëü·á¸»ÎÒÃǵÄÉú»î£¬µ«Ò²Ê¹¹ÜÀí·½ÃæµÄ¹¤×÷¸ü¼Ó·±Ëö¡£ÎÄÏ××ÊÔ´×÷ΪÐÅÏ¢×ÊÔ´µÄÖØÒª×é³É²¿·Ö£¬ÒÑ¾ÉøÍ¸µ½Éç»áÉú»îµÄµÄÿһ¸ö½ÇÂä¡£Ó¦Ô˶øÉúµÄÆóÒµÎĵµ¹ÜÀíϵͳ¾ÍÊÇÀûÓüÆËã»úÐÅÏ¢»¯¹ÜÀí£¬ÊµÏÖ¹«Ë¾ÄÚ²¿Îļþ¹ÜÀíºÍÎļþÐÅÏ¢²éѯµÈ¹¦ÄÜÈí¼þ¡£ÎĵµÐÅÏ¢»¯½¨ÉèÒѳÉΪÐÅϢʱ´úÎĵµ¹¤×÷ÕßÃæÁÙµÄÖØÒª¿ÎÌâºÍ·¢Õ¹Æõ»ú¡£
1.1Ñ¡ÌâµÄ±³¾°¼°ÒâÒå
Ëæ×żÆËã»úµÄ·¢Õ¹£¬ÐÅÏ¢¼¼Êõ³ÉΪÉç»á·¢Õ¹µÄÖ÷ÒªÇý¶¯Á¦¡£ÆóÒµµÄ·¢Õ¹ÒÀÀµÓÚÁ¼ºÃµÄÆóÒµ¹ÜÀí¡£ÆóÒµÔÚ³¤ÆÚµÄ¾Óª£¬»ýÀÛÁË´óÁ¿µÄÎļþ£¬ÈçºÎÓÐЧµØ¹ÜÀíÎļþ£¬ÈçºÎ·½±ãÎļþµÄ¶ÁÈ¡ºÍÏÂÔØ£¬Ìá¸ßÁËÓû§µÄ´¦ÀíÄÜÁ¦¡£Ëæ×ÅÔ½À´Ô½¶àµÄÆóÒµºÍ¸öÈËʹÓÃÍøÂçÎļþ¼°ÆäÄÚÈÝ£¬ÕâʹµÃ²¶×½¡¢¹ÜÀíºÍÌṩҵÎñÎĵµÐÅÏ¢µÄ±äµÃÔ½À´Ô½ÖØÒª¡£Ä¿Ç°£¬¸÷ÖÖÉÌÎñ°ì¹«¹ý³ÌÖвúÉúµÄµç×ÓÎļþÔ½À´Ô½¶à£¬³ýÁ˸÷ÖÖ±¨±í£¬ºÏͬµÈÎļþ£¬»¹°üÀ¨¸÷ÒôƵ¡¢Í¼ÏñµÈ¶àýÌåÐÅÏ¢µÄÎļþ¡£ÕâЩÎļþÒ»°ãÊǵç×ÓÐÎʽµÄÎļþ£¬ÆäÖÐһЩÆóÒµ½«´òÓ¡Ö½ÕÅÐÎʽµÄµç×ÓÎļþ¡£ÕâЩµç×ÓÎļþ´ó¶àÊýȱ·¦¿ÆÑ§¹ÜÀí£¬ÄÑÒÔʵÏֵĹ²ÏíÎļþµÄ·ÃÎÊ¿ØÖÆ¡£ÏÖ´ú»¯µÄ¹ÜÀí·½·¨¿ÉÒÔ°ïÖúÆóÒµ¸ü¼Ó¸ßЧ¡¢Áé»î½øÐÐÎĵµÐÅϢά»¤£¬
[1]
Ìá¸ßÆóÒµµÄ¾ºÕùÁ¦¡£
´«Í³µÄÎĵµ¹ÜÀí·½·¨µ¥Ò»£¬Ð§Âʵͣ¬¼«´óµØÏÞÖÆÁËÔ±¹¤¼¼ÄܵÄÌá¸ßºÍÆóÒµ¾ºÕùÁ¦µÄ¸ÄÉÆ¡£Ëæ×ÅÆóÒµÐÅÏ¢»¯µÄ½ø³Ì¼ÓËÙ£¬ÆóÒµµÄµç×ÓÎĵµ¹ÜÀíÔ½À´Ô½Êܵ½ÖØÊÓ£¬µç×ÓÎĵµµÄ¹ÜÀí½«»áÔ½À´Ô½¶àµÄÓ¦ÓÃÔÚÆóÒµ¹ÜÀíÉÏ¡£¼ÆËã»ú´¦ÀíÄÜÁ¦µÄ²»¶ÏÌáÉý£¬Èí¼þ¼¼ÊõºÍ¼ÆËã»úÓ¦ÓõIJ»¶ÏÉºÍÀ©´ó£¬´ÙʹÁËÓ¦ÓÃÈí¼þµÄ¹¦ÄÜ¡¢ÖÖÀ಻¶ÏÔö¼Ó¡£Òò´Ë£¬ÆóÒµ±ØÐëÓÉ´«Í³¹ÜÀíģʽÏòÏÖ´ú»¯µÄ¹ÜÀíģʽת±ä¡£Ëæ×żÆËã»ú¼¼ÊõºÍÍøÂçÓ¦ÓÃˮƽµÄ·ÉËÙ·¢Õ¹£¬»ùÓÚWebµÄµç×ÓÎĵµ¹ÜÀíϵͳÊÇÆóÒµÐÅÏ¢»¯µÄ·¢Õ¹Ç÷ÊÆ¡£
µç×ÓÐÅÏ¢ÊÇÒ»¸ö·Ç³£ÖØÒªµÄ×ÊÔ´£¬ÎÞÂÛÊÇÈËÃǵŤ×÷ºÍѧϰÖУ¬»¹ÊÇÔÚÔÚÈËÃǵÄÈÕ³£Éú»îÖУ¬¶¼·¢»Ó×ÅÔ½À´Ô½ÖØÒªµÄ×÷Óã¬ÈçºÎ½â¾öµç×ӼǼµÄ°²È«ÎÊÌ⣬¸üºÃµØ·¢»Óµç×ÓÎļþµÄ×÷ÓÃÌá¸ßЧÂÊ£¬ÕâÊÇÂÛÎĵĸù±¾¡£µç×ÓÎļþÐÅÏ¢¹ÜÀíϵͳÔÚÆóÒµÐÅϢϵͳÖеÄ×÷Óò»ÔÙ½ö½öÊÇÓ¦ÓÃϵͳ¸¨Öú
[2]
×é³É²¿·Ö£¬¶øÊÇ×÷ΪÕû¸öÆóÒµÐÅϢϵͳµÄÖ§³Åƽ̨֮һ¡£
ʹÓÃÕâÑùÒ»¸öµç×ÓÎĵµ¹ÜÀíϵͳ£¬¿ÉÒÔ´ó·ù¶ÈÌá¸ß×Ô¼ºµÄ¹¤×÷ЧÂÊ£¬²¢Í³Ò»±£´æ£¬ÒÔ¹©È«ÆóÒµ¹²ÏíʹÓã¬ÓÐÖúÓÚ²¿ÃÅÖ®¼äËæÊ±»¥Í¨ÓÐÎÞ¡£ÓеĹ«Ë¾²ÉÓà FTP ·þÎñÆ÷×÷ΪÆóÒµµÄµç×Ó×ÊÔ´´æ·Å¿Õ¼ä£»ÕâЩ¶¼»ò¶à»òÉٵĸøÆóÒµÔ±¹¤ÔÚ¹²Ïí¡¢´æ·ÅÉÏ´øÀ´ÁËÒ»¶¨µÄЧ¹û£¬µ«ÊǶÔÓÚÆóÒµ¼¶µÄµç
[3]
×Ó×ÊÔ´¹ÜÀíÀ´Ëµ£¬ÕâʱԶԶ²»¹»µÄ¡£µç×ÓÎĵµ×ÊÔ´¹ÜÀí¾ßÓÐÒÔÏÂÌØÐÔ¡£
1£©µç×Ó×ÊÔ´´æ´¢µÄ±ØÒªÐÔ¡£ÓÉÓÚÆóÒµÔ±¹¤±Ê¼Ç±¾µÄ¶ªÊ§£¬»úÆ÷Ë𻵵ȶ¼ÓпÉÄÜÔì³ÉÆóÒµÖØÒªµç×Ó×ÊÔ´µÄÓÀ¾Ã¶ªÊ§¡£ÒòΪµç×Ó×ÊÔ´µÄ·ÖÉ¢£¬¶ÔÓÚÆóÒµÔ±¹¤»ñÈ¡µç×Ó×ÊÔ´¡¢ÐÅÏ¢£¬Ò²´øÀ´Öî¶àµÄ²»±ã£¬Ó°Ï칤×÷ЧÂÊ£¬½¨Á¢ÆóÒµµÄÖÐÑëµç×Ó×ÊÔ´Êý¾ÝÖÐÐÄÊÇÏ൱ÓбØÒªµÄ¡£
2£©µç×Ó×ÊÔ´°æ±¾¹ÜÀí±ØÒªÐÔ¡£Ò»·Ýµç×Ó×ÊÔ´Æð²Ýºó£¬ÍùÍù»áÒ»´Î´Î¸üУ¬ÕâÑù¾Í²úÉúÁËͬһµç×Ó×ÊÔ´µÄ¶à¸ö°æ±¾¡£Òò´ËÐèÒªÒ»¸öºÜºÃµÄµç×Ó×ÊÔ´°æ±¾¹ÜÀí»úÖÆ£¬ÇåÎúµÄ¼Ç¼µç×Ó×ÊÔ´µÄ°æ±¾Éý¼¶¡£
3£©µç×Ó×ÊÔ´°²È«±ØÒªÐÔ¡£¹ØÓÚµç×Ó×ÊÔ´µÄ°²È«ÐÔÊÇ¶à·½ÃæµÄ¿ÉÄÜÓÉÓÚÔ±¹¤µÄÎóɾ³ýÔì³ÉµÄµç×Ó×ÊÔ´¶ªÊ§¡£µç×Ó×ÊÔ´µÄȨÏÞ¹ÜÀíÊDZ£Õϵç×Ó×ÊÔ´°²È«µÄÒ»¸öÖØÒªÊֶΣ¬µç×Ó×ÊÔ´µÄԽȨ²Ù×÷ÍùÍùÒ²ÊǶԵç×Ó×ÊÔ´°²È«ÐÔµÄÒ»¸öDZÔÚÍþв¡£ÒªÓÐЧµØ±£ÕÏÆóÒµµç×Ó×ÊÔ´µÄ°²È«¾Í±ØÐëÓÐÒ»Ì×ÍêÉÆµÄµç×Ó×ÊÔ´¹ÜÀí·½°¸À´ºÏÀíµØ·ÖÅäµç×Ó×ÊԴȨÏÞ£¬²¢¹æ·¶ÆóÒµÔ±¹¤µÄµç×Ó×ÊԴʹÓÃÁ÷³Ì¡£
ͨ¹ýÒÔÉϵķÖÎö£¬µÃ³ö½áÂÛ£ºÎĵµ¹ÜÀíÊÇÒ»¸ö¹ý³Ì£¬ÒòΪ¸ÃÎļþ¹ÜÀíϵͳ²»ÏÞÓڰ칫ÊÒ£¬Ëæ
- 5 -
×ÅÉç»áºÍÐÅÏ¢¼¼ÊõµÄ·¢Õ¹£¬È«ÇòÐÅÏ¢Òýµ¼Ô½À´Ô½Ã÷ÏÔ¡£×ÛÉÏËùÊö£¬Îĵµ¹ÜÀíϵͳµÄǰ¾°ÊǷdz£¹ãÀ«µÄ¡£
1.2ÆóÒµÎĵµ¹ÜÀíϵͳµÄÏÖ×´
ĿǰÔÚÉÌÒµ»¯µÄÎĵµ¹ÜÀíϵͳÖÐ,¹úÍâ¼¼Êõ±È½Ï³ÉÊ죬ԶԶÁìÏÈÓÚÎÒ¹ú£¬ÔÚ·¢´ï¹ú¼Ò,¶ÔÓÚÎĵµ¹ÜÀíϵͳµÄÑо¿×´¿ö¼°·¢Õ¹Ç÷ÊÆ,ÒѾÖð²½×ßÏò·Ö²¼Ê½¹ÜÀíµÀ·,·Ö²¼Ê½¹ÜÀíϵͳµÄÖ÷ÒªÌØµã°üÀ¨¿çƽ̨ÐÔ¡¢·Ö²¼Ê½¼ÆËã¡¢·Ö²¼Ê½´æ´¢ºÍ¿ÉÀ©Õ¹ÐÔµÄÌØµã¡£Web ServiceµÄ¼¼Êõ±ê×¼ºÍ¹æ·¶ÒѾ³ÉΪITÒµ½ç¹«Èϵķֲ¼Ê½¿ª·¢±ê×¼²¢µÃµ½Á˹㷺µÄáŠÓá£Web Service¼¼Êõ°ÑÆóÒµÐÐÕþÎĵµ¹ÜÀíϵͳ´øÈëÁËÒ»¸öеĽ׶Î,´ó´óÌá¸ßÁËϵͳµÄÔËÐÐÐÔÄÜ¡¢°²È«ÐÔºÍÎȶ¨ÐÔ£¬¿ª·¢Õß¿ÉÒÔÀûÓÃÕâЩÈí¼þ
[4]
ʵÏÖÎĵµ¹ÜÀíµÄ×Ô¶¯»¯¹ÜÀíÄã¡£
¸Ä¸ï¿ª·ÅÒÔºó,ÎÒ¹úµÄÆóÊÂÒµµ¥Î»ÐÐÕþ¹ÜÀí¹¤×÷ÓÉÔÀ´µÄÊÖ¹¤¹ÜÀíÖð½¥×ßÏòÐÅÏ¢»¯¹ÜÀí·½Ê½¡£ÔçÆÚµÄÎĵµ¹ÜÀíϵͳÖ÷ÒªÓÃÀ´´¦ÀíÌØ¶¨ÁìÓòµÄ¸´ÔӰ칫ҵÎñ¡£ÎÒ¹úµÄÆóÒµ¼ÆËã»ú¹ÜÀíÐÅϢϵͳ½¨ÉèÔÚ 20 ÊÀ¼Í 80 Äê´ú¾ÍÒѾ¿ªÊ¼Æð²½£¬µ«·¢Õ¹¼«²»Æ½ºâ£¬Ò²¾ÍÊÇ˵´ó²¿·ÖÆóҵĿǰÈÔ´¦ÓÚµÍˮƽ¿ª·¢ºÍÓ¦Óý׶Ρ£Ëæ×ÅÐÐÕþ¹ÜÀí¹¤×÷Ô½À´Ô½¸´ÔÓ,ÐÐÕþÎĵµ¹ÜÀí¹¤×÷Öð½¥³ÉΪ´ó¼Ò¹Ø×¢µÄÖØµã,
[5]
ÔõÑù¿ÆÑ§ºÏÀíµØ½øÐÐÐÐÕþÎĵµµÄ¹ÜÀíÒ²Öð½¥³ÉΪ¸÷ÆóÊÂÒµµ¥Î»Ñо¿µÄÈȵ㡣
´ÓÎĵµµÄÊÖ¹¤¹ÜÀíµ½ÐÅÏ¢»¯¡¢×Ô¶¯»¯ºÍÖÇÄÜ»¯¹ÜÀí,ÎÞÂÛÊÇ´Ó¹ÜÀí·½Ê½¡¢ÄÚÈݺÍϵͳµÄÌåϵ¼Ü¹¹µÈ¶¼È¡µÃÁ˺ܴóµÄ½ø²½¡£
Ê×ÏÈ,ÔÚÎĵµ¹ÜÀí·½Ê½·½Ãæ,ÐÐÕþÎĵµ¹ÜÀíÀíÄîµÃµ½ÁËÖʵķÉÔ¾¡£Êг¡ÉϳöÏÖÁ˸÷ÖÖ¸÷ÑùµÄÎĵµ¹ÜÀíϵͳ,Éæ¼°µÄÁìÓòÒ²·Ç³£µÄ¹ã·º,°üÀ¨¹¤³ÌÏîÄ¿¡¢Õþ¸®ÐÐÕþ¡¢½ÌÓý»ú¹ØµÈµÈ¡£
Æä´Î,ÔÚ¹ÜÀíµÄÄÚÈÝ·½Ãæ,´Ó×î³õµÄ¾²Ì¬»¯¹ÜÀíµ½¶¯Ì¬»¯¹ÜÀíÔÙµ½ÏÖÔÚµÄÉè¼ÆÎĵµ¹ÜÀí,Éè¼ÆÎĵµ¹ÜÀí½×¶Î,¾²Ì¬»¯¹ÜÀíºÍ¶¯Ì¬»¯¹ÜÀí¾ÍÏûʧÁË,ËüÃÇÆäʵÊÇÒ»¸öÏศÏà³ÉµÄ¹ØÏµ,¸÷×Ô¶¼ÓÐÆä²»Í¬µÄÌØµã¡£Éè¼ÆÎĵµ¹ÜÀí·½Ê½ÊǶԾ²Ì¬»¯¹ÜÀíºÍ¶¯Ì¬»¯¹ÜÀí·½Ê½µÄȨºâ,ÞðÆúËüÃǵÄȱµã,Õû¸öÎĵµ
[6]
µÄ¹ÜÀí·½Ê½¿ÉÒÔ½øÐÐÈ˹¤ÅäÖÃ,ÕâÖÖ·½Ê½¾ßÓÐ×ÔÓɺÍÈËÐÔ»¯µÄÌØµã¡£
´ÓÎĵµ¹ÜÀíϵͳµÄ¹¦ÄÜÉÏÀ´¿´,¿ì½ÝµÄ¼ìË÷¡¢ÊµÊ±µÄ´æ´¢ºÍ·½±ãµÄ²Ù×÷ÊÇÎĵµ¹ÜÀíϵͳ×îÖ÷ÒªµÄ¹¦ÄÜ¡£Îĵµ¹ÜÀíϵͳµÄÌåϵ¼Ü¹¹·¢Õ¹À´¿´,ÓÉ×î³õµÄC/S½á¹¹Îĵµ¹ÜÀíϵͳÉý¼¶µ½»ùÓÚWeb¼¼ÊõµÄB/S½á¹¹µÄ·Ö²¼Ê½Ìåϵ½á¹¹¡£Ëæ×ž¼ÃÌåÖÆµÄ¸Ä¸ïºÍÊг¡¾¼ÃµÄ·¢Õ¹£¬ÆóÒµµÄÔËÐлúÖÆÓÐÁË
[7]
ºÜ´ó±ä»¯¡£ÔÚµ±Ç°ÐÎÊÆÏ£¬ÐÅÏ¢»¯ÊÇÆóÒµ·¢Õ¹µÄ±ØÓÉ֮·¡£
1.3±¾ÎÄÑо¿µÄÄ¿±ê
±¾¿ÎÌâ½øÐÐÆóÊÂÒµÄÚ²¿Îĵµ¹ÜÀíϵͳµÄÑо¿ÊǾßÓÐÉî¿ÌÒâÒåµÄ¡£Í¨¹ýÉÏÃæµÄ·ÖÎö£¬ÆóÒµÐèÒªµÄÎĵµ¹ÜÀíϵͳ±ØÐëÊÇÁ¼ºÃµÄ¿ÉÖØÓÃÐÔ£¬¿ÉÒÆÖ²ÐԺͿÉÀ©Õ¹ÐÔ¡£Í¨¹ýÑо¿ÆóÒµµÄÎĵµ¹ÜÀíϵͳµÄÒµÎñÐèÇ󣬽øÐпÉÐÐÐÔ±¨¸æ¡¢ÐèÇó·ÖÎöºÍϵͳÉè¼Æ£¬¸ÃϵͳÖ÷Òª·ÖΪÒÔϼ¸¸ö¹¦ÄÜÄ£¿é£ºÐ½¨²úƷĿ¼¡¢²úƷĿ¼ä¯ÀÀ¡¢²úƷĿ¼²éѯ£¬Íê³ÉÁËÓû§ÐÅÏ¢¹ÜÀí¼°²éѯµÈ·½ÃæµÄ»ù±¾¹¦ÄÜ£¬¸üÓÐЧµÄÌá¸ßϵͳ´¦ÀíµÄЧÂÊÒÔÊÊÓ¦ÈËÔ±µÄ¹¤×÷ÐèÇó¡£ÒÔÊÊÓ¦¹¤×÷ÈËÔ±µÄ¹¤×÷ÐèÒª¡£±¾ÎļòÒª½éÉÜÁËϵͳµÄÐèÇó·ÖÎö¡¢Êý¾Ý¿âÉè¼Æ¡¢ÏµÍ³Éè¼ÆºÍϵͳʵʩ·½·¨¡£´ËÍ⣬»ùÓÚ.Net¿ª·¢Æ½Ì¨µÄWeb¿ª·¢ÊµÊ©µÄÑо¿ÖУ¬Ê¹ÓÃSQL Server2008 R2Êý¾Ý¿âÍê³ÉϵͳµÄÉè¼ÆÓ뿪·¢¡£
- 6 -
µÚ¶þÕ ϵͳ¿ª·¢¹¤¾ß
2.1 .Net¿ª·¢»·¾³
ÆóÒµÎĵµ¹ÜÀíϵͳÖ÷Òª°üÀ¨Ç°Ì¨¹ÜÀí³ÌÐòÒÔ¼°ºǫ́Êý¾Ý¿âÁ½¸ö·½Ãæ¡£¶ÔÓÚǰÕßÒªÇó³ÌÐò¹¦ÄÜÇ¿´ó¡¢½çÃæÓѺá¢Ò×ÓÚʹÓ᣶ø¶ÔÓÚºóÕßÔòÒªÇó½¨Á¢ÆðÊý¾ÝÒ»ÖÂÐÔ¡¢ÍêÕûÐԺͰ²È«ÐԵŦÄÜ¡£Èí¼þºËÐļ¼ÊõµÄ±à³Ì˼ÏëÊÇÖÆ¶¨¹æ»®ºÍ±àÂëµÄÁ¼ºÃϰ¹ß£¬¿ª·¢ÏîÄ¿Ê×ÏÈÊÇÑ¡Ôñ¼¼Êõ¿ª·¢Æ½Ì¨¡£VC++ÔòËٶȿ졢ÐÔÄܺÃ,µ«¶Ô¿ª·¢ÈËÔ±ËØÖÊÒªÇó¸ß¡£´´½¨ÐÂÒ»´úµÄWEBÓ¦ÓÃËùÒªµÄһЩ¼¼ÊõºÍ¹¤¾ßÊÇÓÐÕâÑùµÄƽ̨ËùÌṩ•A,InternetÐÒéÔÚ.NETƽ̨Éϵõ½Ö§³Ö,°üÀ¨³¬Îı¾µÄ´«ÊäµÄÐÒé(HTTP)¡¢¿ÉÒÔÀ©Õ¹µÄ±ê¼ÇÓïÑÔ(XML)ºÍ¼òµ¥¶ÔÏó·ÃÎʵÄÐÒé(SOAP),ͬʱÓÉÓÚ.NETÌṩÁËÒ»¸öÏà¶Ô°²È«µÄ»·¾³,ʹµÃºÚ¿ÍÒÔ¼°ÀàËÆ¹¥»÷ÕßÄÑÒÔÈëÇÖ¡£¿ÉÒÔÈò»Í¬µÄϵͳ¼äµÄ³ÌÐòʵÏÖͨѶºÍ¼¯³É,ÔÚÕâ¸öƽ̨ÉÏ¿ª·¢µÄÈí¼þºÍ·þÎñ¿ÉÒÔ¸ßЧµÄÈںϵ½Õû¸öÓû§µÄƽʱÈÕ³£»î¶¯µÄµç×Ӽܹ¹ºÍÒµÎñµÄ½ø³ÌÖÐ[8]
¡£
XML¼¼ÊõµÄ³öÏÖʹµÃÕâ¸öÎÊÌâµÄ½â¾öÈÝÒ×Á˺ܶà,Óû§Ö»ÒªÒ»µÃµ½Êý¾Ý¾ÍÄÜ¶ÔÆä½øÐвÙ×÷¡£Ä¿Ç°ÖÕ¶ËÓû§¶ÔÓÚÆä¸öÈ˵ÄÒþ˽ºÍÊý¾Ý°²È«ÐԷdz£¹Ø×¢,ĿǰÔÚÈí¼þ¿ª¹ý³ÌÖÐ,´æÔÚÓ¦ÓóÌÐòºÍ·þÎñÎÞ·¨ºÜºÃµØºÍÆäËûµÄ³ÌÐòºÍ·þÎñºÏ×÷µÄÎÊÌâ,ÕâÒ²µ¼ÖÂÁ˸÷ÖÖÈí¼þ¹«Ë¾ºÍWEBÕ¾µã¿ª·¢ÕßÃǺÜÄÑΪÓû§ÃÇÌṩ×ã¹»µÄºÍÓмÛÖµµÄÊý¾Ý¡£ÕâЩÓïÑÔÉú³ÉµÄÍøÒ³ÔÚºǫ́±àÒë³ÉMSIL´úÂëµÄͬʱ±»×ª»»³ÉÁËÀಢ±àÒë³ÉÁËÒ»¸öDLL¡£ÓÉÓÚËüµÄ±àÒëÖ´ÐÐ,ËùÒÔASP.NET±ÈASPЧÂʸü¸ß¡£.NET³öÏÖ֮ǰһֱûÓеõ½ºÜºÃµÄ½â¾ö,.NETÌṩÁËÒ»Ì×ÍêÕûµÄȨÏ޺Ͱ²È«¿ØÖÆ·þÎñ,ʹÓû§¿ÉÒÔ·½±ãµÄ
[9]
¹ÜÀí¸öÈËÐÅÏ¢,²¢ÇÒ¿ÉÒÔÕâЩÐÅÏ¢µÄ·ÃÎÊȨÏÞ¼ÓÒÔ¿ØÖÆ¡£
NET×÷Ϊ֧³ÖÉú³É¡¢ÔËÐÐÏÂÒ»´úÓ¦ÓóÌÐòºÍXML Web·þÎñµÄÄÚ²¿Windows×é¼þ,Ëü°ïÖúÓ¦ÓóÌÐò¡¢·þÎñºÍÉ豸һÆð¹¤×÷,ʹµÃÊý¾Ý¹²ÏíºÍ²Ù×÷¹¤×÷±äµÃÈÝÒ׺ܶà,ÁíÍâ,XML Web ServicesÊǽ¨Á¢ÔÚXML¹æ·¶Êý¾Ý½»»»»ù´¡ÉϵÄÈí¼þ¼¼ÊõÄ£ÐÍ,ËüÃDZ˴ËÖ®¼äÊǶÀÁ¢,µ«Í¬Ê±ËüÃÇÓÖ¿ÉÒÔÁªÏµµ½Ò»¸ö¾ßÌåµÄºÏ×÷½ø³ÌÉÏ¡£´Ó¼¼Êõ˼ÏëµÄÓ°ÏìÁ¦À´¿´,΢ÈíµÄ.NET¼¼Êõ°ÑXML Web Services±ä³É
[10]
ÒÔºóµÄÖ÷Á÷¼ÆËãģʽ¡£
2.2Êý¾Ý¿â¹¤¾ßÑ¡Ôñ-SQLSERVER2008 R2
Êý¾Ý¿â¼¼ÊõÊÇÐÅϢϵͳµÄºËÐļ¼ÊõÖ®Ò»¡£ËüÑо¿ÈçºÎ×éÖ¯ºÍ´æ´¢Êý¾ÝµÄ¼ÆËã»ú¸¨Öú·½·¨£¬ÈçºÎÓÐЧµØ»ñÈ¡ºÍ´¦ÀíÊý¾Ý¡£ÓÉÓÚ¹ØÏµÊý¾Ý¿â¾ßÓÐÊý¾Ý½á¹¹»¯¡¢½Ï¸ßµÄ³ÌÐòÓëÊý¾Ý¶ÀÁ¢ÐÔ¡¢Ò×ÓÚ±àÖÆÓ¦ÓóÌÐòµÈÓŵã,µÃµ½Á˹㷺µÄÔËÓá£Êý¾Ý¿â¼¼ÊõÊÇÏÖ´úÐÅÏ¢¿ÆÑ§¼¼ÊõµÄÖØÒª×é³É²¿·Ö£¬ÊǼÆËã»úÊý¾Ý´¦ÀíºÍÎļþ¹ÜÀíϵͳµÄºËÐÄ¡£Êý¾Ý¿â¼¼ÊõµÄÑо¿½â¾öÁË´óÁ¿Êý¾ÝµÄ´æ´¢ÎÊÌ⣬¼õÉÙÈßÓàÊý
[12]
¾Ý´æ´¢£¬ÊµÏÖÁ˸ßЧµÄÊý¾Ý¼ìË÷ºÍÊý¾Ý´¦Àí¹¦ÄÜ¡£
Ïà¶ÔÓÚAccessÊý¾Ý¿â£¬SQLÊý¾Ý¿â¸ü¼Ó¿É¿¿£¬Í¬Ê±±ÈAccess¾ßÓиüΪÓѺõĹÜÀí½çÃæ¡ª¡ªÆóÒµ¹ÜÀíÆ÷£¬ÆäÖеÄÊÓͼ֧³ÖÖ±¹ÛµÄÊý¾Ý¿âÉè¼Æ£¬¿ÉÒÔͨ¹ý´Ê·¨·ÖÎöÆ÷ͬʱҲ¿ÉÒÔÖ±¹ÛµÄ½øÐÐÊý¾Ý´¦Àí¡£Ñ¡ÔñSQLÊý¾Ý¿âµÄ×îÖ÷ÒªÔÒòÊÇËüÖ§³ÖÍøÂçÊý¾Ý¿â¡£ÎªÁ˺ÏÀí¿ØÖÆÕâЩÐÅÏ¢£¬²ÉÓÃÍøÂçÊý¾Ý¿âÊÇ×îÀíÏëµÄÑ¡Ôñ¡£SQLServer·þÎñÆ÷ÌṩÁ˿ɿ¿µÄÊý¾Ý±£ÕÏ£¬¿ÉÒÔ×Ô¶¯Êý¾Ý±¸·ÝºÍ·ÃÎÊÈÕÖ¾µÄ¼Ç¼£¬¿ÉÒÔ½øÐÐÏêϸµÄÊý¾Ý·ÖÎöµÈ²Ù×÷¡£
½á¹¹»¯²éѯÓïÑÔSQL£¨STRUCTUREDQUERYLANGUAGE£©Ê¹Ó÷½±ã¡¢¹¦Äܷḻ¡¢¼ò½àÒ×ѧ£¬ÊDzÙ×÷Êý¾Ý¿âµÄ¹¤Òµ±ê×¼ÓïÑÔ¡£Ëü¿ÉÒÔ´Ó¹ØÏµÊý¾Ý¿âÖлñµÃÊý¾Ý£¬Ò²¿ÉÒÔ½¨Á¢Êý¾Ý¿â¡¢Ôö¼ÓÊý¾Ý¡¢ÐÞ¸ÄÊý¾Ý¡£ËüÊÇ×îÖØÒªµÄ¹ØÏµÊý¾Ý¿â²Ù×÷ÓïÑÔ£¬²¢ÇÒËüµÄÓ°ÏìÒѾ³¬³öÊý¾Ý¿âÁìÓò£¬µÃµ½
- 7 -