Êý¾Ý¿â²ÍÒû¹ÜÀíϵͳ¿Î³ÌÉè¼Æ - ͼÎÄ ÏÂÔØ±¾ÎÄ

Ŀ¼

µÚÒ»Õ ǰÑÔ .............................................................................................................................. 3

1.1¿ª·¢±³¾° ..................................................................................................................... 3 1.2¿ª·¢¹¤¾ß ..................................................................................................................... 3 1.3¿ª·¢Ä¿±ê ..................................................................................................................... 3 µÚ¶þÕ ÐèÇó·ÖÎö ...................................................................................................................... 4 µÚÈýÕ ×ÜÌåÉè¼Æ ...................................................................................................................... 5

3.1ϵͳ¹¦Äܽṹ ............................................................................................................. 5 3.2³ÌÐòÁ÷³Ìͼ ................................................................................................................. 6 µÚËÄÕ Êý¾Ý¿âÉè¼Æ .................................................................................................................. 7

4.1¸ÅÄî½á¹¹Éè¼Æ ............................................................................................................. 7 4.2Âß¼­½á¹¹Éè¼Æ ............................................................................................................. 9 4.3ÎïÀí½á¹¹Éè¼Æ ............................................................................................................. 9

6¡¢ÉÌÆ·Àà±ðÐÅÏ¢±íÈç±í4-6Ëùʾ ......................................................................................... 11 µÚÎåÕ ÏêϸÉè¼Æ .................................................................................................................... 12

5.1µÇ½²¿·Ö ................................................................................................................... 12 5.2Ö÷½çÃæ ....................................................................................................................... 12 5.3Ö°¹¤ÐÅÏ¢²éѯ ........................................................................................................... 13 5.4ץ̀ÐÅÏ¢²éѯ ........................................................................................................... 14 5.5¸¨Öú¹¤¾ß ................................................................................................................... 14 5.6ÐÞ¸ÄÃÜÂë¡¢Ëø¶¨¹¦ÄÜ ............................................................................................... 15 5.7¿ªÌ¨²¿·Ö ................................................................................................................... 15 5.8½áÕ˲¿·Ö ................................................................................................................... 16 5.9µã/¼Ó²Ë²¿·Ö ............................................................................................................. 16 5.10Ïû·Ñ²éѯ²¿·Ö ......................................................................................................... 17 5.11Óû§È¨ÏÞ¹ÜÀí ......................................................................................................... 17 µÚÁùÕ ±àÂë ............................................................................................................................ 18 µÚÆßÕ ²âÊÔ ............................................................................................................................ 20 µÚ°ËÕ Éè¼Æ×ܽá .................................................................................................................... 22 ÖÂл .......................................................................................................................................... 23 ²Î¿¼ÎÄÏ× .................................................................................................................................. 23

µÚÒ»Õ ǰÑÔ

1.1¿ª·¢±³¾°

½ü¼¸ÄêÀ´£¬¼ÆËã»úÍøÂç¡£·Ö²¼¼°¼¼ÊõÈÕÇ÷³ÉÊì£¬Ëæ×ſƼ¼µÄ·¢Õ¹£¬²ÍÒûÒµµÄ¾º

ÕùÒ²Ô½À´Ô½¼¤ÁÒ¡£ÏëÔÚÕâÑù¼¤ÁҵĻ·¾³ÖÐÉú´æ£¬¾Í±ØÐëÔËÓÿÆÑ§µÄ¹ÜÀí˼ÏëÓëÏȽøµÄ¹ÜÀí·½·¨£¬Ê¹µã²ÍÓë¹ÜÀíÒ»Ì廯¡£ÕâÑù²»½ö¿ÉÒÔÌá¸ß¹¤×÷ЧÂÊ£¬Ò²±ÜÃâÁËÒÔǰÊÖ¹¤×÷ÒµµÄÂé·³£¬´Ó¶øÊǹÜÀíÕßÄܹ»×¼È·¡£ÓÐЧµÄ¹ÜÀí¡£Òò´Ë£¬²ÍÒûÒµµÄ¹ÜÀíÕ߸üÏñ´Ó¿ÆÑ§µÄ¹ÜÀíÖÐÈ¥µÄ¾ºÕùµÄÓÅÊÆ£¬ÔÚ¼¤ÁÒ¾ºÕùµÄÉÌÒµÊг¡ÖÐȡʤ¡£

1.2¿ª·¢¹¤¾ß

Ó²¼þ£º±Ê¼Ç±¾µçÄÔ

Èí¼þ£ºWindows XP²Ù×÷ϵͳ Microsoft Visual Studio 2008 Microsoft SQL Server 2000

±¾ÏµÍ³ÊDzÉÓà C#¼¼Êõ½áºÏSQL ServerÊý¾Ý¿âÉè¼Æ²¢ÊµÏֵġ£´°¿ÚµÄ¿ª·¢¹¤¾ßΪMicrosoft Visual Studio 2008£¬Êý¾Ý¿âʹÓõÄÊÇSQL Server 2000 Express Edition¡£±à³ÌÓïÑÔ²ÉÓõÄÊÇc#¡£

1.3¿ª·¢Ä¿±ê

1¡¢ÏµÍ³²ÉÓÃÈË»ú½»»¥µÄ·½Ê½£¬½çÃæÓѺÃÃÀ¹Û£¬ÐÅÏ¢²éѯÁé»î·½±ã£¬Êý¾Ý¿â´æ´¢°²È«¿É¿¿¡£

2¡¢ÊµÏÖ¶Ô²ÍÌü¹Ë¿Í¿ªÌ¨¡¢µã²Ë/¼Ó²Ë¡¢ÕËÄ¿²éѯºÍ½áÕ˵ȲÙ×÷¡£ 3¡¢¶ÔÓû§ÊäÈëµÄÊý¾Ý½øÐÐÑϸñµÄ¼ìÑ飬¾¡¿ÉÄܵıÜÃâÈËΪ´íÎó¡£ 4¡¢ÊµÏÖ¶ÔÏû·ÑÕËÄ¿×Ô¶¯½áËã¡£

5¡¢ÊµÏÖ¶ÔÏû·ÑµÄÀúÊ·¼Ç¼½øÐвéѯ£¬Ö§³ÖÄ£ºý²éѯ¡£ 6¡¢ÏµÍ³Ó¦¾¡´óÏ޶ȵÄʵÏÖÒ×ά»¤ÐÔºÍÒ×ÓÚ²Ù×÷ÐÔ¡£ 7¡¢½çÃæ¾¡¿ÉÄÜÃÀ¹Û´ó·½£¬Ò×ѧÒ×Óá£

µÚ¶þÕ ÐèÇó·ÖÎö

Ëæ×ŲÍÒûÒµµÄ²»¶Ï·¢Õ¹£¬²ÍÒû¹ÜÀíϵͳµÄÄÚÈݶÔÓÚ²ÍÒûÒµµÄ¾ö²ßÕߺ͹ÜÀíÕßÀ´Ëµ¶¼·Ç³£ÖØÒª¡£±¾ÏµÍ³Ö÷Òª°üÀ¨×Ą̀ÏÔʾ¡¢Ïû·Ñ²éѯ¡¢ÈËʵµ°¸¼°È¨Ï޵ȼ¸´ó²¿·Ö£¬¾ßÓÐÁ¼ºÃµÄÓû§½Ó¿Ú£¬Ê¹Ó÷½±ã¾ßÓÐÍêÉÆµÄ²éѯ£¬¶Ôά»¤ÏµÍ³Æðµ½¸¨Öú¾ö²ßµÄ×÷Óã¬Äܼ°Ê±¡¢·½±ã¡¢Áé»îµÄ½øÐвéѯ¡¢ÐÞ¸Äɾ³ýµÈά»¤ÐÔ²Ù×÷¡£²ÍÒû¹ÜÀíϵͳÓÐ×ã¹»´óµÄ´æ´¢ÈÝÁ¿£¬Âú×ã¾ÆµêÿÈÕÓªÒµµÄ±ä¶¯£¬ÁíÍâ¶ÔÓÚ²Ù×÷Óû§ÓÐÒ»¶¨µÄ¹ÜÀí£¬²¢¶ÔÓû§µÄȨÏÞÓÐÒ»¶¨µÄÉèÖá£

ΪÁËʹϵͳ¸ü¼ÓÈËÐÔ»¯£¬±ãÓÚ¹ÜÀíÔ±¹ÜÀí£¬´ËϵͳµÄÓû§½«·ÖΪÁ½ÖÖÀàÐÍ£¬Ò»¸öÊÇÕë¶ÔÔ±¹¤µÄ²ÍÒû¹ÜÀíϵͳ£¬Ò»¸öÊÇÕë¶Ô¹ÜÀíÔ±£¨µêÖ÷£©µÄ²ÍÒû¹ÜÀíϵͳ¡£³¬¼¶¹ÜÀíÔ±ÓµÓÐËùÓÐȨÏÞ¡£¾­Àí³ýÁËϵͳά»¤Í⣬ÆäËû²Ù×ݶ¼¿ÉÒÔ£¬ÆÕͨÓû§Ö»ÄÜʵÏÖ¸¨Öú¹¤¾ßµÄʹÓÃȨÏÞ¡£

²»Í¬Óû§µÄȨÏÞÈçÏ£º

Ô±¹¤Ê¹Óñ¾²ÍÒûÐÅÏ¢¹ÜÀíϵͳӦ¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ£º 1¡¢Ê¹Óø¨Öú¹¤¾ß£¨ÈÕÀú¡¢¼Çʱ¾¡¢¼ÆËãÆ÷£© 2¡¢²éѯͳ¼Æ£¨ÊÕÈëÈÕ±¨£© 3¡¢Ê¹ÓðïÖú²Ëµ¥ 4¡¢Í˳öϵͳ

¹ÜÀíԱʹÓñ¾²ÍÒûÐÅÏ¢¹ÜÀíϵͳӦ¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ£º

1¡¢½øÐлù´¡ÐÅÏ¢µÄ²éѯÐ޸ģ¨¿ª×ÀÐÅÏ¢¡¢Ö°Ô±ÐÅÏ¢¡¢Ê³Æ·ÐÅÏ¢£© 2¡¢Ê¹Óø¨Öú¹¤¾ß£¨ÈÕÀú¡¢¼Çʱ¾¡¢¼ÆËãÆ÷£© 3¡¢½øÐÐϵͳά»¤£¨È¨ÏÞ¹ÜÀí£© 4¡¢ÏµÍ³ÉèÖã¨ÃÜÂëÐ޸ġ¢ÏµÍ³Ëø¶¨£© 5¡¢²éѯͳ¼Æ£¨ÊÕÈëÈÕ±¨£© 6¡¢Ê¹ÓðïÖú 7¡¢Í˳öϵͳ

³ýÁËʵÏÖÒÔÉϹ¦ÄÜÍ⣬±¾ÏµÍ³»¹ÐèÒª·½±ãÓû§µØÊ¹Óã¬Ê¹µÃÓû§¿ÉÒÔºÜ¿ìµØÊìÁ·ÕÆÎÕ£¬´Ó¶ø¿ÉÒÔÈÃÓû§¿ìËÙµÄͶÈ빤×÷¡£²¢ÇÒÒª±ÜÃâÂß¼­´íÎóµÄ³öÏÖ¡£