»ùÓÚasp+mssql·ÖÀàÐÅÏ¢³ÌÐò¿ª·¢_¼ÆËã»úרҵÂÛÎÄ
·¢²¼Ê±¼ä£º
2015-01-16
À´Ô´£º
ÈË´ó¾¼ÃÂÛ̳
¼ÆËã»úרҵÂÛÎÄ·¶ÎÄ
ÕªÒª
Ëæ×Å»¥ÁªÍøµÄ¿ìËÙÆÕ¼°£¬ÈËÃÇ¿ªÊ¼Í¨¹ýÍøÂç·ÖÀàÐÅÏ¢»ñÈ¡ÒÂʳסÐеÈÏà¹ØÐÅÏ¢£¬¿ªÊ¼²½ÈëÍøÂ绯ºÍÐÅÏ¢»¯µÄʱ´ú£¬¶ø·ÖÀàÐÅÏ¢ÍøվΪ´ËÌṩÁËÒ»¸öÐÅÏ¢½»Á÷ƽ̨¡£
¸Ãϵͳ·ÖΪ·ÖÀàÐÅÏ¢·¢²¼ÏµÍ³¡¢ÐÂÎÅ·¢²¼ÏµÍ³¡¢ÆóÒµ»Æҳϵͳ¡¢»áÔ±¹ÜÀíϵͳ¡¢ÍøÕ¾ºǫ́¹ÜÀíϵͳÎå´ó¹¦ÄÜÄ£¿é¡£ÊµÏÖÁËÓοͺͻáÔ±·¢²¼·ÖÀàÐÅÏ¢£¬²¢¿ÉÒÔ×Ô¶¨Òå·ÖÀàÐÅÏ¢µÄ·¢²¼·½Ê½£»ÆóÒµÓû§¿ÉÒÔÉêÇë¡¢Ð޸ġ¢¹ÜÀíÆóÒµ»ÆÒ³£»¹ÜÀíÔ±ÔÚϵͳºǫ́¿ÉÒÔ¹ÜÀí·ÖÀàÐÅÏ¢¡¢·¢²¼ÍøÕ¾ÐÂÎÅ¡¢¹ÜÀí»áÔ±ÐÅÏ¢¡¢ÐÞ¸ÄÍøվϵͳÊôÐÔ¡¢¹ÜÀíÆóÒµ»ÆÒ³µÈ¹¦ÄÜ¡£
±¾ÎĸÅÒªµÄ½²ÊöÁË·ÖÀàÐÅÏ¢ÍøÕ¾³ÌÐòµÄ¿ª·¢»·¾³£¬ÒÔ¼°·þÎñÆ÷Èí¼þºÍÓ²¼þµÄÏà¹Ø½éÉÜ¡£¶ÔÓÚÖ÷ÒªµÄ±à³ÌÓïÑÔASPºÍÊý¾Ý¿âÈí¼þSQL Server 2000×öÁËÏêϸµÄ½éÉÜ¡£½Ó×Å´ÓÍ·µ½Î²µÄ½²ÊöÁ˱¾¿ÎÌâµÄ³ÌÐò¹¦ÄÜÒÔ¼°ÊµÏÖ¼¼Êõ¡£
¹Ø¼ü´Ê£ºASP£»SQL Server 2000£»·ÖÀàÐÅÏ¢£»ÆóÒµ»ÆÒ³
Abstract
With the fast popularization of internet, people begin to get all sorts of information about food, clothing, shelter and transportation through the internet. The life of people is moving into the era of internet and information. Classified information websites have offered platforms for this life style.
The program system of this kind of websites devides into five functional modules, which are information release system, news release system, business directory system, members management system and back-stage management system. This system settings supports both sightseers and members to publish classified information and customize the ways of releasing. Business users can apply, revise, administer their business directories. Administrator can publish site news, revise system property, and manage classified AD information, member¡¯s information and business directories through the back-stage management module.
Firstly, this thesis introduces the development environment of classified information website program and the relative software and hardware of server in outline, and then give a detailed account for ASP, SQL Server 2000. This thesis focuses on introducing the program function of the classified information websites system as well as the implementation technique of this subject throughout the full text.
Key words: ASP£»SQL Server 2000£»Classified information£»Yellow Pages
Ŀ¼
ÕªÒªI
AbstractII
Ç°ÑÔ1
µÚ1Õ ¿ÎÌâ¸ÅÊö2
1.1·ÖÀàÐÅÏ¢ÍøÕ¾Ñо¿µÄ±³¾°ºÍÀúÊ·ÒâÒå2
1.1.1·ÖÀàÐÅÏ¢ÍøµÄÑо¿±³¾°2
1.1.2·ÖÀàÐÅÏ¢ÍøÕ¾¿ÎÌâµÄÒâÒå2
1.2·ÖÀàÐÅÏ¢ÍøÕ¾Éè¼ÆµÄÄ¿µÄ¼°Ä¿±ê3
1.2.1·ÖÀàÐÅÏ¢ÍøÕ¾Éè¼ÆµÄÄ¿µÄ3
1.2.2·ÖÀàÐÅÏ¢ÍøÕ¾Éè¼ÆµÄÄ¿±ê3
µÚ2Õ Éè¼Æ·½°¸ÂÛÖ¤4
2.1»ùÓÚAsp +Accesss·ÖÀàÐÅÏ¢³ÌÐò¿ª·¢4
2.2»ùÓÚAsp+Mssql·ÖÀàÐÅÏ¢³ÌÐò¿ª·¢5
µÚ3Õ ¿ª·¢»·¾³6
3.1ÍøÕ¾½¨ÉèµÄƽ̨ѡÔñ6
3.1.1ƽ̨ÒòËØ6
3.1.2·þÎñÆ÷Ó²¼þ7
3.1.3·þÎñÆ÷Èí¼þ7
3.2±à³ÌÓïÑÔµÄÑ¡Ôñ7
3.2.1 ASP»ù±¾ÌØÕ÷7
3.2.2 ASPµÄ¹¦ÄÜ8
3.2.3 ASPµÄ»ù±¾¹¤×÷ÔÀí8
3.2.4 ASPµÄ¶ÔÏóÄ£ÐÍ9
3.3 ASPÈçºÎÓëIISÁ¬½Ó10
3.4¿ª·¢¹¤¾ß10
3.4.1 WEBä¯ÀÀÆ÷10
3.4.2¿ÉÊÓ»¯±à¼Æ÷10
3.5ͼƬ´¦ÀíÈí¼þ¼ò½é12
µÚ4Õ ϵͳÉè¼Æ13
4.1ÐèÇó·ÖÎö13
4.2¹¦ÄÜÄ£¿éµÄ»®·Ö14
4.3Êý¾Ý¿âµÄÉè¼Æ14
4.3.1 ODBC¼ò½é15
4.3.2 ADO¼ò½é16
4.4Êý¾Ý¿âµÄ»ù±¾²Ù×÷16
4.5ϵͳ½á¹¹19
4.5.1Ö÷ÒªÊý¾Ý±í20
µÚ5Õ ¹¦ÄÜÉè¼Æ27
5.1ϵͳ×ÜÁ÷³Ì27
5.2·ÖÀàÐÅÏ¢·¢²¼¹¦ÄÜ29
5.3ÐÂÎÅ·¢²¼¹¦ÄÜ31
5.4ÆóÒµ»ÆÒ³¹¦ÄÜ32
5.5ÆóÒµ»ÆÒ³32
5.6»áÔ±¹ÜÀí¹¦ÄÜ33
5.8Íøվǰ̨ҳÃæÉè¼Æ35
5.8.1ÍøÕ¾Ê×Ò³µÄÉè¼Æ35
5.8.2ÍøÕ¾·ÖÀàÐÅÏ¢ËõÂÔÒ³Ãæ36
5.9ÆóÒµ»ÆÒ³Ò³ÃæÉè¼Æ37
5.10¹¦ÄÜÓëÉè¼Æ×ܽá37
µÚ6Õ µ÷ÊÔºÍÐÞ¸Ä39
±ÏÒµÉè¼Æ×ܽá40
ÖÂл41
²Î¿¼ÎÄÏ×42
¸½Â¼Ò»£ºÏà¹ØÒ³ÃæЧ¹ûͼ43
¸½Â¼¶þ£ºÏà¹Ø³ÌÐòÒ³Ãæ46