±ÏÒµÉè¼Æ
УÓѼ¹ÜÀíϵͳ
2012 ½ì ¼Æ Ëã »ú ϵ
רҵ ¼ÆËã»úÍøÂç¼¼Êõ£¨ÍøÂçϵͳ¼¯³É·½Ïò£© °à¼¶ ѧºÅ ÐÕÃû Ö¸µ¼½Ìʦ Íê³ÉÈÕÆÚ 2011Äê12ÔÂ20ÈÕ
ѧԺ
±ÏÒµÉè¼ÆÈÎÎñÊé
ÐÕ Ãû ר Òµ ±ÏÒµÉè¼ÆÌâÄ¿ Ö¸µ¼½ÌʦÐÕÃû ¼ÆËã»úÍøÂç¼¼Êõ£¨ÍøÂçϵͳ¼¯³É·½Ïò£© УÓѼ¹ÜÀíϵͳ Ö°³Æ»òÖ°Îñ ½²Ê¦ ¹¤×÷µ¥Î» ¼ÆËã»úϵ ѧºÅ °à ¼¶ ±ÏÒµÉè¼ÆÄÚÈÝ¡¢»ù±¾ÒªÇó¡¢ÖصãÑо¿ÎÊÌâ¡¢Ö÷ÒªÉè¼Æ·½·¨£¨»ò²½Ö裩£º ÄÚ ÈÝ£ºÐ£ÓѼ¹ÜÀíϵͳ »ù±¾ÒªÇó£ºÓû§¿ÉÒÔÔÚǰ̨²éÕÒºÍ×¢²á×Ô¼ºµÄѧУ,¹ÜÀíÔ±¿ÉÒÔÔÚºǫ́ÉèÖÃÊÇ·ñÔÊÐí×¢²áºÍÊÇ·ñÐèÒªÉóºË,¶ÔÖØ¸´Ñ§Ð£¿ÉÒÔ½øÐÐÉóºËÐ޸ĵȵȣ»ÒªÇó½çÃæÃÀ¹Û¡¢Ê¹Ó÷½±ã£»Íê³É±ÏÒµÉè¼Æ±¨¸æ¡£ ÖØµãÑо¿ÎÊÌ⣺Óû§µÄ×¢²áºÍ¹ÜÀíÔ±µÄºǫ́¹ÜÀí Ö÷ÒªÉè¼Æ·½·¨£ºÊ¹ÓÃASP.netÀ´½øÐÐÉè¼Æ£¬½áºÏSQL SERVERÀ´¹ÜÀíÊý¾Ý¿â¡£ÔÚÕâ¸öϵͳÖÐͬѧÃǺÍУÓÑÃÇ¿ÉÒԺܷ½±ãµÄ×¢²á²¢µÇ¼Õâ¸öϵͳ£¬¶ÔѧУºÍËùÔڰ༶µÄÇé¿ö½øÐÐä¯ÀÀºÍ¼ìË÷£¬Á˽âÆäËûͬѧµÄÇé¿ö¡£»¹¿ÉÒÔä¯ÀÀ֪ͨºÍѧУ×îж¯Ïò£¬ÉÏ´«ÕÕÆ¬µÈ²Ù×÷¡£ÏµÍ³¹ÜÀíÔ±¿ÉÒÔä¯ÀÀÓû§ÐÅÏ¢ºÍ×ÊÁÏ£¬²¢¿ÉÒÔɾ³ýÎ¥·´¹æ¶¨µÄÓû§Õʺţ¬Æðµ½¹ÜÀíУÓÑÂ¼ÍøÕ¾µÄ×÷Óà Ö÷Òª²Î¿¼ÎÄÏס¢×ÊÁÏ£º [1] ÀîµÂÆæ£¬Áº½àæÃ£¬¡¶ASP.NET³ÌÐòÉè¼Æ¡·£¬ÈËÃñÓʵç³ö°æÉ磬2004 (4) [2] ¸ßÊ÷·¼£¬Ã×êÆ¡¶Èí¼þ¹¤³Ì¡·£¬´óÁ¬Àí¹¤´óѧ³ö°æÉ磬2003 (3) [4] ÍõÊçÃô£¬ÂíÊÀϼ£¬Áõµ¤£¬¡¶ASP.NET¶¯Ì¬ÍøÕ¾Éè¼Æ¡·£¬Ç廪´óѧ³ö°æÉ磬2010 [5] ÕÅ´äÐù£¬¡¶ÍøÂçÊý¾Ý¿â¡·£¬ Ç廪´óѧ³ö°æÉ磬2009 ¼Æ»®½ø¶È£º 2011Äê10ÔÂ20ÈÕ¡ª¡ª2011Äê10ÔÂ31ÈÕ Àí½â±ÏÒµÉè¼ÆÈÎÎñ¡¢Öƶ¨Ñо¿¼Æ»® 2011Äê11ÔÂ1ÈÕ¡ª¡ª2011Äê11ÔÂ15ÈÕ ËѼ¯×ÊÁÏ¡¢ÒµÎñµ÷ÑС¢ÐèÇó·ÖÎö 2011Äê11ÔÂ16ÈÕ¡ª¡ª2011Äê12ÔÂ9ÈÕ Èí¼þÉè¼Æ¡¢±àÂë¡¢²âÊÔ¡¢µ÷ÊÔ 2011Äê12ÔÂ10ÈÕ¡ª¡ª2011Äê12ÔÂ20ÈÕ ×«Ð´±ÏÒµÉè¼Æ±¨¸æ Ö¸µ¼½Ìʦǩ×Ö£º Äê Ô ÈÕ
ѧԺ
±ÏÒµÉè¼ÆÆÀ¶¨Êé
ÐÕ Ãû ר Òµ ±ÏÒµÉè¼ÆÌâÄ¿ Ö¸µ¼½ÌʦÆÀÓ Ö¸µ¼½Ìʦ½¨Òé³É¼¨£¨60£¥£© Ö¸µ¼½Ìʦǩ×Ö£º Äê Ô ÈÕ ¼ÆËã»úÍøÂç¼¼Êõ£¨ÍøÂçϵͳ¼¯³É·½Ïò£© УÓѼ¹ÜÀíϵͳ ѧ ºÅ °à ¼¶ ´ð±çС×齨Òé³É¼¨£¨40£¥£© ×鳤ǩ×Ö£º Äê Ô ÈÕ ´ð±çίԱ»á×îºóÉ󶨳ɼ¨ Ö÷ÈÎÇ©×Ö£º Äê Ô ÈÕ ±¸×¢ Õª Òª
±¾ÏµÍ³ÊÇ»ùÓÚWEBµÄÐÅÏ¢´¦Àíϵͳ£¬Ö÷Òª²ÉÓÃASP.NET×÷Ϊ¿ª·¢¹¤¾ß£¬ºǫ́Êý¾Ý
¿â²ÉÓÃSQL2005Êý¾Ý¿âÉè¼Æ£¬ÀûÓÃSQL2005Êý¾Ý¿â·ÃÎʼ¼ÊõʵÏÖ¶ÔÊý¾Ý¿âµÄ¸÷ÖÖ¹ÜÀí²Ù×÷¡£Ö÷ҪʵÏÖÁ˹ÜÀíÔ±ÐÅÏ¢¹ÜÀí¡¢ÆÕͨÓû§ÐÅÏ¢¹ÜÀí¡¢ÔºÏµ°à¼¶ÐÅÏ¢¹ÜÀíºÍºǫ́ÐÅÏ¢¹ÜÀíµÈ¹¦ÄÜÄ£¿é¡£Ð£ÓÑÂ¼ÍøÕ¾ÉÏÓÐ×îеÄѧУ¶¯Ì¬,¿ÉÒÔÈÃͬѧÃǼ°Ê±Á˽âѧУ¼°°à¼¶µÄ¸øÀàÐÅÏ¢, ʹÓ÷½±ã¡¢¹¦ÄÜÆëÈ«¡¢ÔËÐÐËÙ¶È¿ì,¾ßÓÐÁ¼ºÃµÄ¿ÉÒÆÖ²ÐÔºÍÀ©Õ¹ÐÔ¡£±¾ÏµÍ³ÔÚÉè¼Æ¹ý³ÌÖУ¬Ê×ÏȽ¨Á¢ÁËϵͳµÄÓ¦ÓÃÔÐÍ£¬È»ºóÔÚ´Ë»ù´¡ÉϽøÐÐÐèÇóµü´ú£¬ÏêϸÉè¼ÆÊ±²»¶ÏµØÐ޸ĺÍÍêÉÆ£¬×îÖÕÐγɴﵽÉè¼ÆÒªÇóµÄϵͳ¡£
УÓѼ¹ÜÀíϵͳÊÇÔÚasp¼¼ÊõºÍsqlÊý¾Ý¿â¼¼ÊõÉϽ¨Á¢ÆðÀ´µÄ¡£ÔÚÕâ¸öϵͳÖÐͬѧÃǺÍУÓÑÃÇ¿ÉÒԺܷ½±ãµÄ×¢²á²¢µÇ¼Õâ¸öϵͳ£¬¶ÔѧУºÍËùÔڰ༶µÄÇé¿ö½øÐÐä¯ÀÀºÍ¼ìË÷£¬Á˽âÆäËûͬѧµÄÇé¿ö¡£»¹¿ÉÒÔä¯ÀÀ֪ͨºÍѧУ×îж¯Ïò£¬ÉÏ´«ÕÕÆ¬µÈ²Ù×÷¡£ÏµÍ³¹ÜÀíÔ±¿ÉÒÔä¯ÀÀÓû§ÐÅÏ¢ºÍ×ÊÁÏ£¬²¢¿ÉÒÔɾ³ýÎ¥·´¹æ¶¨µÄÓû§Õʺţ¬Æðµ½¹ÜÀíУÓÑÂ¼ÍøÕ¾µÄ×÷ÓÃ
¹Ø¼ü´Ê: УÓѼ ASP.NET SQL Server ÍøÂç ͨѶ
Ŀ ¼
1 Ð÷ÂÛ ................................................................................................................................. 1
1.1 Ñ¡ÌâÄ¿µÄºÍÒâÒå .................................................................................................... 1
1.1.1 ¿ª·¢±³¾° ..................................................................................................... 2 1.2 ϵͳ¼ò½é ................................................................................................................ 2 1.3 ϵͳ¿ÉÐÐÐÔ·ÖÎö¼°¹Ø¼ü¼¼Êõ ................................................................................ 2
1.3.1 ϵͳ¿ÉÐÐÐÔ·ÖÎö ......................................................................................... 2 1.3.2 ¹Ø¼ü¼¼Êõ ..................................................................................................... 3
2 ϵͳ¿ª·¢¹¤¾ß ................................................................................................................. 4
2.1 ϵͳÖ÷Òª¿ª·¢¹¤¾ß ................................................................................................ 4
2.1.1 Micro Studio 2008 ................................................................................... 4 2.1.2 SQL Server 2005 ........................................................................................ 4 2.2 ϵͳ¸¨Öú¿ª·¢¹¤¾ß ................................................................................................ 5
2.2.1 Microsoft Access ........................................................................................ 5 2.3 Óû§ºÍϵͳÁ÷³Ìͼ ................................................................................................ 5 3 Êý¾Ý¿âÉè¼Æ ..................................................................................................................... 6
3.1 Êý¾Ý¿âÓ¦ÓÃϵͳ¿ª·¢¼ò½é .................................................................................... 6 3.2 Êý¾Ý¿â¹ÜÀíϵͳ .................................................................................................... 6 4 ϵͳ¹¦ÄÜÉè¼Æ ................................................................................................................. 7
4.1 ϵͳ¼òÒ×ͼ ............................................................................................................ 7 4.2 ϵͳÔËÐл·¾³ ........................................................................................................ 8
4.2.1 ¶ÔÐÔÄܵĹ涨 ............................................................................................. 8 4.2.2 Êý¾Ý¹ÜÀíÄÜÁ¦ÒªÇó ..................................................................................... 8 4.3 ÔËÐл·¾³ ................................................................................................................ 8
4.3.1 Ó²¼þÒªÇó ..................................................................................................... 8 4.4 Êý¾Ý¿â»·¾³ ............................................................................................................ 8
4.4.1 ¿ª·¢Æ½Ì¨ ..................................................................................................... 8 4.4.2 Ó¦ÓÃÆ½Ì¨ ..................................................................................................... 8 4.5 ϵͳµÄÌåϵ½á¹¹ .................................................................................................... 8
4.5.1 ϵͳҵÎñÁ÷³Ìͼ ......................................................................................... 9
I
Ïà¹ØÍÆ¼ö£º