ÕªÒª

Ëæ×ÅInternet¼¼ÊõµÄ·¢Õ¹£¬»¥ÁªÍøÔÚÖйúÖð²½ÆÕ¼°,ÈËÃǶÔÍøÂçµÄÐèÇóÒ²ÈÕÒæÔö³¤,ÀûÓüÆËã»úʵÏÖÂÃÓÎ×ÊÔ´µÄ¹ÜÀíÊÆÔÚ±ØÐС£±¾ÏµÍ³´Ó³õ²½µ÷²é¿ªÊ¼£¬Ïêϸ½éÉÜÁËÐèÇó·ÖÎö¡¢Á÷³ÌºÍÊý¾Ý·ÖÎö£¬²¢½øÐÐÁËϵͳ×ÜÌå½á¹¹Éè¼ÆºÍÊý¾Ý¿âÉè¼Æ¡£ÏµÍ³²ÉÓÃAdobe Dreamweaver 5±àдASP½Å±¾£¬Microsoft Office Access 2003½¨Á¢Êý¾Ý¿â£¬´Ó½çÃæ¼ò½à¡¢ÊµÓõÄÒªÇó³ö·¢£¬Íê³ÉÁËÂÃÓÎ×ÊÔ´¹ÜÀí¹¤×÷µÄÖ÷Òª²¿·Ö£¬±¾ÎÄÊǸù¾ÝÂÃÓÎÐÐÒµµÄÕâÖÖÏÖ×´£¬Ìá³ö½â¾öÎÊÌâµÄÒ»¸ö¿ÉÐÐÐÔ·½·¨£º²ÉÓÃÏÖ´ú»¯Í³Ò»µÄ¼ÆËã»úÍøÂçϵͳ£¬ÊµÏÖÁËÂÃÓιÜÀíµÄÍøÂ绯£¬¸÷ÀàÐÅÏ¢ÓÐÐòµØ½øÐд洢£¬¿É½øÈëϵͳÖ÷¿Ø½çÃ棬½øÐÐÐÅÏ¢¹ÜÀí£¬ÐÅÏ¢²éѯ£¬½á°é£¬ÁôÑÔ°åµÈ¹¦ÄܵÄʹÓá£ÊµÏÖÁ˸÷ÖÖÒµÎñϵͳµÄÊý¾Ý¼¯³ÉºÍÐÅÏ¢¼¯³É£¬¶ÔÂÃÓθ÷ÀàÐÅÏ¢¡¢×ÊÔ´½øÐÐЭͬ¼¯ÖйÜÀí¡£¸ÃÍøվϵͳ²ÉÓÃÒÔASPΪÖ÷Òª¿ª·¢¼¼Êõ£¬VBΪÖ÷ÒªÉè¼ÆÓïÑÔ£¬Êý¾Ý¿â²ÉÓõ±Ï¹¦ÄÜÇ¿¾¢µÄACCESSÊý¾Ý¿â¡£ÔÚASP¼¼Êõ¼°ACCESSÊý¾Ý¿âÇ¿´ó¹¦ÄܵÄÖ§³ÖÏ£¬±¾ÍøվϵͳʵÏÖÁËÍøÕ¾µÄÈ«Ã涯̬¹ÜÀí£¬¸ßËÙÊý¾Ý´æÈ¡£¬Ê¹µÃ¶ÔÍøÕ¾µÄ¹ÜÀí¸ü¼Ó¼°Ê±ÓÐЧ£¬¼«´óµÄÌá¸ßÁËÍøÕ¾¹ÜÀíÈËÔ±µÄ¹¤×÷ЧÂÊ¡£

¹Ø¼ü´Ê£ºÂÃÓÎÐÅÏ¢£»Êý¾Ý¿â£»Asp¶¯Ì¬ÍøÕ¾

Ŀ¼

µÚÒ»Õ ¸ÅÊö... 1

1.1£®Ñо¿±³¾°... 1

1.2£®Ñ¡ÌâÒÀ¾Ý... 1

1.3£®Ñо¿ÒâÒå... 2

µÚ¶þÕ ¿ª·¢¼¼ÊõÓ빤¾ß... 2

2.1£®Asp¼¼Êõ¼ò½é... 2

2.2£®ASPÓëÊý¾Ý¿âAccess. 3

2.3£®IIS·þÎñÆ÷... 4

2.4£®Dreamweaver CS5¿ª·¢¹¤¾ß... 5

µÚÈýÕ ÐèÇó·ÖÎö... 6

3.1£®Óû§ÐèÇóºÍºǫ́¹ÜÀíÐèÇó... 6

3.2 ϵͳ·ÖÎöÓë»·¾³¿ª·¢ÐèÇó... 6

3.3 ÍøÕ¾µÄ¹¦ÄÜÄ£¿é¼ò½é... 7

µÚËÄÕ ϵͳÉè¼Æ... 7

4.1 ϵͳģ¿é¹¦ÄÜÉè¼Æ... 8

4.2 Êý¾Ý¿âÉè¼Æ... 9

4.2.1 Êý¾Ý¿â¹¦ÄÜ·ÖÎö... 9

4.2.2 Êý¾Ý¿âE-Rͼ... 11

4.2.3 Êý¾Ý¿âÓëaspµÄÁ´½Ó... 11

4£®3 Ò³ÃæÉè¼Æ... 12

4.3.1Ò³Ãæ²¼¾Ö... 12

4.3.2Ò³Ãæ·ç¸ñ... 13

µÚÎåÕ ϵͳʵÏÖ... 13

5.1 ǰ̨... 13

5.1.1 Ê×ҳʵÏÖ... 13

5.1.2 ÁбíҳʵÏÖ... 17

5.1.3 ÄÚÈÝҳʵÏÖ... 18

5.1.4 ¹ÜÀíҳʵÏÖ... 19

5.2 ºǫ́... 21

5.2.1¹ÜÀíÔ±µÇ½... 21

5.2.2 Óû§Ãû¹ÜÀí... 23

5.2.3 ÂÃÓÎÐÅÏ¢¹ÜÀí... 24

5.2.3 ³£ÓòÎÊýÉèÖÃ... 26

µÚÁùÕ ²âÊÔÔËÐÐÓëά»¤... 27

6.1 ÃæÏò¹ý³ÌµÄ²âÊÔ·½·¨... 27

6.1.1 ºÚºÐ²âÊÔ... 27

6.1.2 °×ºÐ²âÊÔ... 27

6.2 ¾ßÌå²âÊÔµÄÉè¼Æ... 28

6.3 ϵͳά»¤... 28

½á ÂÛ... 30

²Î¿¼ÎÄÏ×... 30

µÚÒ»Õ ¸ÅÊö

1.1£®Ñо¿±³¾°

ÎÒ¹úÊÇÒ»¸öÂÃÓÎ×ÊÔ´´ó¹ú£¬µØ´óÎﲩ£¬ÎÄ»¯´«Í³Ô´Ô¶Á÷³¤£¬ÔÚ¹ýÈ¥µÄ20Ä꣬ÖйúÒѾ­´ÓÂÃÓÎ×ÊÔ´´ó¹ú·¢Õ¹³ÉΪÑÇÖÞÂÃÓδó¹ú£¬½ñºó20Ä꣬Öйú½«³ÉΪÊÀ½çÂÃÓÎÇ¿¹ú¡£¸ù¾ÝÊÀ½çÂÃÓÎ×éÖ¯Ô¤²â£¬µ½20##Ä꣬ÎÒ¹ú½«³ÉΪÊÀ½ç×î´óµÄÂÃÓÎÄ¿µÄµØ£¬²¢³É ΪÊÀ½çµÚËÄ´óÂÃÓοÍÔ´¹ú£¬½ìʱ£¬ÖйúÿÄê½Ó´ýµÄÈë¾³ÂÃÓÎÕß½«´ïµ½1.37ÒÚ£¬Ã¿ÄêÒ²½«ÓÐ1ÒÚµÄÖйúÂÃÓÎÕß½«³ö¾³¡¢³ö¹úÂÃÓΡ£

ÎÒ¹úÓµÓеĹúÄÚÂÃÓÎÊг¡Ç±Á¦Ò²Ê®·Ö¾Þ´ó£¬12ÒÚÆÕͨÀÏ°ÙÐÕµÄÂÃÓÎÒâʶÏÖÔڲŠ¸Õ¸ÕÐËÆ𣬹úÄÚÂÃÓÎÊÕÈëÔÚ¹úÃñÉú²ú×ÜÖµÖÐÕ¼±ÈÖغÜС£¬Ëæמ­¼ÃµÄÔö³¤£¬¹úÃñÂà ÓÎÒâʶ½«ÓÐÒ»¸ö¼ÓËٳɳ¤µÄ¹ý³Ì£¬Ä¿Ç°¡°¼ÙÈÕ¾­¼Ã¡±µÄÅÐËÆðÕýÊÇÈËÃÇÂÃÓÎÒâʶºÍ¹ú¼ÒÕþ²ß·öÖ²Ïà½áºÏµÄ½á¹û¡£

½üÄêÀ´£¬Ëæ×ÅÍøÂç¼¼ÊõµÄѸÃÍ·¢Õ¹£¬Ô½À´Ô½¶àµÄ²¿ÃÅ¡¢ÆóÊÂÒµµ¥Î»¶¼ÓÐͨ¹ýInternet¶ÔÍâÐû´«×Ô¼º£¬Í¬Ê±ÎªÄÇЩÓÐÐÅÏ¢ÐèÇóµÄÈËÌṩ·½±ã¿ì½ÝµÄ·þÎñ¡£ÂÃÓÎÍøÕ¾ÊǸ÷ÂÃÓÎʤµØ¶ÔÍâÐû´«Öв»¿ÉȱÉٵŤ¾ß£¬ËüµÄÄÚÈݶÔÓÚÂÃÓÎʤµØµÄÐû´«ºÍÂÃÓεصÄÏîÄ¿µÄ¿ª·¢µÄ¾ö²ßÆð×ŷdz£ÖØÒªµÄ×÷Óá£

ÂÃÓÎÍøµÄ³ÉÁ¢±êÖ¾×ÅÎÒ¹ú»ùÓÚ»¥ÁªÍøµÄÂÃÓÎÍøÂç·¢Õ¹µÄ¿ªÊ¼¡£Ëæ×ŵç×ÓÉÌÎñµÄ³±Æð³±Â䣬ÂÃÓÎÍøÕ¾Ò²¾­ÀúÁËÊг¡µÄÏ´Àñ¡£ÂÃÓÎÍøÕ¾×÷ΪÍøÂç¾­¼ÃÐÎÊÆÏÂÂÃÓÎÒµ·¢Õ¹µÄÒ»ÖÖÕ½ÂÔÎäÆ÷£¬ÒѶÔÎÒ¹úÂÃÓÎÊг¡µÄ¹ÌÓбÚÀÝ´øÀ´³å»÷£¬ÎÒ¹úÂÃÓεç×ÓÉÌÎñÔÚδÀ´µÄ·¢Õ¹ÖÐÉÐÓÐÐí¶à¹¤×÷Òª×ö¡£ÂÃÓεç×ÓÉÌÎñÏñÒ»ÕÅ´óÍø£¬°ÑÖÚ¶àµÄÂÃÓι©Ó¦ÉÌ¡¢ÂÃÓÎÖн顢ÂÃÓÎÕßÁªÏµÔÚÒ»Æð¡£Ïà¶ÔÓÚ´«Í³µÄÂÃÓÎÒµÀ´Ëµ£¬ÂÃÓεç×ÓÉÌÎñ²»½öÌá¸ßÁËÒµÎñ͸Ã÷¶ÈºÍ¹¤×÷ЧÂÊ£¬½µµÍÁ˱߼ʳɱ¾£¬¶øÇÒ͹ÏÖÁËÂÃÓβúÆ·±¾Éí¸öÐÔ»¯¡¢ÐÅÏ¢»¯¡¢Ê±ÁµÈÌØÐÔ¡£

1.2£®Ñ¡ÌâÒÀ¾Ý

Ëæ׏úÄÚ»¥ÁªÍøµÄ·¢Õ¹£¬ÂÃÓÎÒµÒ²³ÉΪÍøÉϵÄÈȵãÖ÷Ì⣬ÂÃÓÎÀà¸÷ÖÖÕ¾µãÒ²·×·×½¨Á¢¡£²»¹ýÐí¶àÍøÕ¾µÄÄÚÈÝ»¹Ö»ÏÞÓÚÂÃÓÎÐÅÏ¢µÄ·¢²¼ºÍ½éÉÜ£¬¶ø»¥ÁªÍøÓëÂÃÓÎÒµµÄ½áºÏ·¢Õ¹ÏÔÈ»²»Ó¦¾ÖÏÞÓÚ´Ë¡£Óû§²»ÔÙÂú×ãÓÚͨ¹ýä¯ÀÀÆ÷¿´µ½¾²Ì¬Ò³Ã棬¶øÊÇÏ£ÍûÄܸù¾ÝÒªÇóÉú³É¸ü¼ÓÁé»îµÄ¡¢Éú¶¯µÄ¶¯Ì¬Ò³Ãæ¡£¶¯Ì¬ÍøÒ³°üº¬½»»¥¹¦ÄÜ£¬¶¯Ì¬ÍøÒ³µÄÌصãÓУºÒÔÊý¾Ý¿â¼¼ÊõΪ»ù´¡£¬¿ÉÒÔ´ó´ó½µµÍÍøվά»¤µÄ¹¤×÷Á¿£»²ÉÓö¯Ì¬ÍøÒ³¼¼ÊõµÄÍøÕ¾¿ÉÒÔʵÏÖ¸ü¶àµÄ¹¦ÄÜ£¬ÈçÓû§µÇ¼¡¢ºǫ́¹ÜÀíµÈ¹¦ÄÜ£»²»ÊǶÀÁ¢´æÔÚÓÚ·þÎñÆ÷µÄÍøÒ³Îļþ£¬Ö»Óе±Óû§ÇëÇó·þÎñÆ÷²Å·µ»ØÒ»¸öÍêÕûµÄÍøÒ³¡£ÆäÖеÄ×îÖ÷ÒªµÄ·½Ãæ¾ÍÊÇÀûÓÃËüÀ´´«µÝºÍ·¢ËÍÐÅÏ¢£¬¸üºÃµÄÕ¹ÏÖ×ÔÎÒ¡£ÎÒµÄÂÃÓÎÍø¾ÍÊÇÀûÓüÆËã»úÍøÂçÏòÓοÍÃÇ·¢²¼ÂÃÓÎÐÅÏ¢£»ÓοÍͨ¹ý¼ÆËã»úÍøÂçÁôÑÔÀ´·¢±í×Ô¼ºµÄÒâ¼ûºÍ½¨Òé¡£ÂÃÓÎÍøÕ¾ÔÚʱ¿Õ·½ÃæûÓÐÏÞÖÆ£¬¿ÉÒÔʵÏÖÔ¶³ÌµÄÐÅÏ¢²éѯºÍ½»Á÷¡£

1.3£®Ñо¿ÒâÒå

ÒÀ¿¿»¥ÁªÍøµÄ·¢Õ¹ºÍÆÕ¼°,ÍøÂçÒѳÉΪһÖÖʱÉÐ,Ðí¶àÓÐÑÛ¹âµÄÂÃÓÎÆóÒµ¼ÒºÍÍøÂçµç×ÓÉÌÎñÆóÒµ¼ÒÃÇÖð½¥³öÏÖ,רעÓÚÍøÂçÂÃÓεķ¢Õ¹ºÍDZÔÚ¼ÛÖµ,»ý¼«Íƶ¯ÍøÂçÂÃÓη¢Õ¹¡£Ò»°ãÀ´Ëµ,ÐéÄâÂÃÓεç×ÓÉÌÎñ¿ÉÒÔÂú×㲻ͬ²ã´ÎµÄÐèÇó,ÄÜ´øÀ´ºÜ¶àµÄÉç»áЧÒæºÍ¾­¼ÃЧÒæ¡£Ö÷Òª±íÏÖÔÚÒÔϼ¸¸ö·½Ãæ:

(l)¶ÔÓÚÂÃÓÎÏû·ÑÕß,ÂÃÓεç×ÓÉÌÎñ¼È¿ÉÒÔΪÐí¶àÂÃÓÎDZÔÚÏû·ÑÕßÌṩ´óÁ¿ÐÅÏ¢×ÊÔ´,Âú×ãÐèÇóµÄÂÃÓÎÐÅÏ¢µÄ²éѯʱ,Ëæ׿¼ÊõµÄ·¢Õ¹,²¢ÄÜÈð®ÍøÂçÐéÄâÂÃÓεÄÏû·ÑÕßͨ¹ýÐéÄâÂÃÓÎÌåÑéƽ̨¸ÐÊܸü±ÆÕæµÄ¸÷¾°ÇøÂÃÓεÄÀÖȤ,ÃÖ²¹Ðí¶àÈ˲»ÄÜʵÏÖÏÖʵµÄȱº¶¡£

(2)¶ÔÓÚÂÃÓÎϵͳµÄ¿ª·¢ºÍ¹æ»®ÕßÀ´Ëµ,ͨ¹ýÂÃÓεç×ÓÉÌÎñϵͳ¿ÉÒÔ¸üÈ«Ãæ¸üÕæʵµÄÊÕ¼¯ÍøÂçÓο͵ķ´À¡ÐÅÏ¢,´Ù½øÆä¸ü¿ì¡¢¸üºÃµØ¸Ä½øºÍÍêÉÆÂÃÓÎϵͳµÄ½¨ÉèºÍ´´ÐÂ,ÕâÑùËü¾Í¿ÉÒÔ´ó´ó½µµÍÁË·çÏպͳɱ¾µÄϵͳ¿ª·¢,ʵÏÖϵͳµÄ¿ª·¢Ð§Òæ×î´ó»¯¡£

µÚ¶þÕ ¿ª·¢¼¼ÊõÓ빤¾ß

2.1£®Asp¼¼Êõ¼ò½é

ASP£¨Active Server Pages£©ÊÇÓÉMicrosoft¹«Ë¾ÍƳöµÄÖ§³ÖInternetµÄ¶¯Ì¬·þÎñÆ÷ÍøÒ³¼¼Êõ£¬ÔÚInternet·çÐеÄÔçÆÚ£¬WEBÍøÒ³Ö»ÊǾ²Ì¬µÄͼÎÄ×éºÏ£¬ä¯ÀÀÕß¿ÉÒÔÔÚÍøÒ³ÉÏÔĶÁÐÅÏ¢£¬µ«ÎÞ·¨×ö½øÒ»²½µÄ²éѯ¡¢·¢±íÒâ¼û»ò½øÐеç×ÓÉÌÎñ¡¢ÔÚÏß½»Ì¸¡¢Îʾíµ÷²é¡¢Ô¤Ô¼¶©Æ±¡¢·Ã¿ÍÁôÑÔ²¾¡¢ÌÖÂÛÇø¡¢µç×Ӻؿ¨¡¢E-mail×Ô¶¯»Ø¸´¡¢Êý¾Ý¿â¹ÜÀíµÈ¹¤×÷£¬ÕâÏÔÈ»²»ÄÜÂú×ãÈËÃÇÔ½À´Ô½¶àÔª»¯µÄÐèÇó¡£Îª´Ë£¬¿ªÊ¼Óв»ÉÙ¹«Ë¾Ìá³ö¶¯Ì¬ÍøÒ³µÄ½â¾ö·½°¸£¬ËùνµÄ¡°¶¯Ì¬ÍøÒ³¡±Ö¸µÄÊÇä¯ÀÀÆ÷¶ËºÍ·þÎñÆ÷¶Ë¿ÉÒÔ»¥¶¯£¬Ò²¾ÍÊÇ·þÎñÆ÷¶Ë¿ÉÒÔʵʱ´¦Àíä¯ÀÀÆ÷¶ËµÄÇëÇó£¨request£©£¬È»ºó½«´¦Àí½á¹ûÏìÓ¦¸øä¯ÀÀÆ÷¶Ë£¬¶øASP±ãÊÇ΢ÈíÓÃÀ´½¨Á¢¶¯Ì¬ÍøÒ³µÄ½â¾ö·½°¸¡£ÓÉÓÚËüµÄ¹¦ÄÜÇ¿´ó£¬¿ÉÒÔÖ§³Öµ±Ç°ËùÓеÄä¯ÀÀÆ÷£¬±ãÓÚWEBÊý¾Ý¿âµÄ¿ª·¢£¬Òò¶ø±¶ÊÜÍƳ硣ͬʱASPÒ²ÔÚ²»¶Ï¸üÐÂÍêÉÆ£¬Æ书ÄÜ¿ÉÒÔ³ä·ÖÂú×ã´ó¶àÊý¿ª·¢ÕßµÄÐèÇ󣬲¢Ôںܴó³Ì¶ÈÉÏ´Ù½øÁËInternetÓ¦ÓóÌÐòµÄ·¢Õ¹¡£ASPÊÇÒ»ÖÖ·þÎñÆ÷¶ËµÄÖ¸Áî»·¾³£¬ÓÃÀ´½¨Á¢²¢Ö´Ðн»»¥Ê½WEB·þÎñÆ÷Ó¦ÓóÌÐò£¬Äã¿ÉÒÔʹÓÃASPÀ´½áºÏ·þÎñÆ÷¶ËÖ¸Áî¡¢HTMLÍøÒ³¼°COM×é¼þ¡£ASP³ÌÐòÖ»ÄÜÔÚWEB·þÎñÆ÷¶ËÖ´ÐУ¬µ±ä¯ÀÀÆ÷Ïò·þÎñÆ÷ÒªÇóÔËÐÐASP³ÌÐòʱ£¬·þÎñÆ÷»á¶ÁÈ¡¸Ã³ÌÐò£¬È»ºóÖ´ÐиóÌÐò²¢½«½á¹ûת»»ÎªHTMLÎļþ£¬ÔÙ½«HTMLÎļþ´«Ë͸øä¯ÀÀÆ÷£¬´ýä¯ÀÀÆ÷ÊÕµ½HTMLÎļþºó£¬±ã»á½«Ö´Ðнá¹ûÏÔʾÔÚä¯ÀÀÆ÷ÉÏ¡£

2.2£®ASPÓëÊý¾Ý¿âAccess

ASPÊÇͨ¹ýÒ»×éͳ³ÆΪADO£¨ActiveX Data Objects£©µÄ¶ÔÏóÄ£¿éÀ´·ÃÎÊÊý¾Ý¿â£¬ÎÞÂÛÄã²ÉÓõÄÊÇAccess£¬SQL Server£¬Visual FoxPro£¬Informix£¬Oracle£¬dBase»òÆäËûÊý¾Ý¿â£¬Ö»Òª¸ÃÊý¾Ý¿â¾ßÓжÔÓ¦µÄODBC»òOLEDBÇý¶¯³ÌÐò£¬ADO¶ÔÏó¾ÍÄܼÓÒÔ·ÃÎÊ¡£ÒªÖªµÀϵͳ°²×°ÄÄЩDOBC»òOLEDBÇý¶¯³ÌÐò£¬Windows XPµÄÓû§¿ÉÒÔ´ò¿ª¡°¿ØÖÆÃæ°å¡±£¬ÒÀÐòÔÚ¡°¹ÜÀí¹¤¾ß¡±£¬¡°ODBCÊý¾ÝÔ´¡±ÉÏË«»÷Êó±ê×ó¼ü¡£ÊÂʵÉÏ£¬ASPÌṩÁËÁù¸öÄÚ½¨¶ÔÏ󣬹©Óû§Ö±½Óµ÷Óãº

£¨1£©Application¶ÔÏ󣺸ºÔð¹ÜÀíËùÓлỰÐÅÏ¢£¬¿ÉÓÃÀ´ÔÚÖ¸¶¨µÄÓ¦ÓóÌÐòµÄËùÓÐÓû§Ö®¼ä¹²ÏíÐÅÏ¢¡£

£¨2£©Session¶ÔÏ󣺴æÖüÌض¨Óû§µÄ»á»°ÐÅÏ¢£¬Ö»±»¸ÃÓû§·ÃÎÊ£¬µ±Óû§ÔÚ²»Í¬WEBÒ³ÃæÌøתʱ£¬SessionÖеıäÁ¿ÔÚÓû§Õû¸ö»á»°¹ý³ÌÖÐÒ»Ö±±£´æ¡£Session¶ÔÏóÐècookieÖ§³Ö¡£

£¨3£©Request¶ÔÏ󣺴ÓÓû§¶ËÈ¡µÃÐÅÏ¢´«µÝ¸ø·þÎñÆ÷£¬ÊÇASP¶ÁÈ¡Óû§ÊäÈëµÄÖ÷Òª·½·¨¡£

£¨4£©Response¶ÔÏ󣺷þÎñÆ÷½«Êä³öÄÚÈÝ·¢Ë͵½Óû§¶Ë¡£

£¨5£© Server¶ÔÏó£ºÌṩ¶Ô·þÎñÆ÷Óйط½·¨ºÍÊôÐԵķÃÎÊ¡£

£¨6£©Object Context¶ÔÏó£ºIIS 4.0ÐÂÔöµÄ¶ÔÏó£¬ÓÃÀ´½øÐÐÊÂÎñ´¦Àí¡£´ËÏÄÜÐèµÃµ½MTS(Microsoft Transaction Server)¹ÜÀíµÄÖ§³Ö¡£

Ad Rotator×é¼þ£ºÓÃÀ´°´Ö¸¶¨¼Æ»®ÔÚͬһҳÉÏ×Ô¶¯ÂÖ»»ÏÔʾ¹ã¸æ£¬ÓÃÓÚWWWÉÏÈÕÒæÖØÒªµÄ¹ã¸æ·þÎñ¡£Browser Capabilities×é¼þ£ºÈ·¶¨·ÃÎÊWEBÕ¾µãµÄÓû§ä¯ÀÀÆ÷µÄ¹¦ÄÜÊý¾Ý£¬°üÀ¨ÀàÐÍ¡¢ÐÔÄÜ¡¢°æ±¾µÈ¡£Database Access×é¼þ£ºÌṩADO (ActiveX Data Objects)À´·ÃÎÊÖ§³ÖODBCµÄÊý¾Ý¿â¡£File Access×é¼þ£ºÌṩ¶Ô·þÎñÆ÷¶ËÎļþµÄ¶Áд¹¦ÄÜ¡£Content Linking×é¼þ£ºÉú³ÉWEBÒ³ÄÚÈÝÁÐ±í£¬²¢½«¸÷ҳ˳ÐòÁ¬½Ó£¬ÓÃÓÚÖÆ×÷µ¼º½Ìõ¡£

AccessÊÇÒ»¸ö¿ÉÊÓ»¯¹¤¾ß£¬ÊÇ·ç¸ñÓëWindowsÍêÈ«Ò»Ñù£¬Óû§ÏëÒªÉú³É¶ÔÏó²¢Ó¦Óã¬Ö»ÒªÊ¹ÓÃÊó±ê½øÐÐÍϷż´¿É£¬·Ç³£Ö±¹Û·½±ã¡£ÏµÍ³»¹ÌṩÁ˱íÉú³ÉÆ÷¡¢²éѯÉú³ÉÆ÷¡¢±¨±íÉè¼ÆÆ÷ÒÔ¼°Êý¾Ý¿âÏòµ¼¡¢±íÏòµ¼¡¢²éѯÏòµ¼¡¢´°ÌåÏòµ¼¡¢±¨±íÏòµ¼µÈ¹¤¾ß£¬Ê¹µÃ²Ù×÷¼ò±ã£¬ÈÝÒ×ʹÓúÍÕÆÎÕ¡£

AccessÖ§³ÖODBC£¨¿ª·¢Êý¾Ý¿â»¥Á¬£¬Open Data Base Connectivity£©£¬ÀûÓÃAccessÇ¿´óµÄDDE£¨¶¯Ì¬Êý¾Ý½»»»£©ºÍOLE£¨¶ÔÏóµÄÁª½ÓºÍǶÈ룩ÌØÐÔ£¬¿ÉÒÔÔÚÒ»¸öÊý¾Ý±íÖÐǶÈëλͼ¡¢ÉùÒô¡¢Excel±í¸ñ¡¢WordÎĵµ£¬»¹¿ÉÒÔ½¨Á¢¶¯Ì¬µÄÊý¾Ý¿â±¨±íºÍ´°ÌåµÈ¡£Access»¹¿ÉÒÔ½«³ÌÐòÓ¦ÓÃÓÚÍøÂ磬²¢ÓëÍøÂçÉϵĶ¯Ì¬Êý¾ÝÏàÁª½Ó¡£ÀûÓÃÊý¾Ý¿â·ÃÎÊÒ³¶ÔÏóÉú³ÉHTMLÎļþ£¬ÇáËɹ¹½¨Internet/IntranetµÄÓ¦Óá£

2.3£®IIS·þÎñÆ÷

IISÊÇInternet Information ServerµÄËõд£¬ËüÊÇ΢Èí¹«Ë¾Ö÷ÍƵķþÎñÆ÷£¬ÎÒʹÓõÄÊÇwindows7°æ±¾IIS7.0£¬IISÓëWindow NT ServerÍêÈ«¼¯³ÉÔÚÒ»Æð£¬Òò¶øÓû§Äܹ»ÀûÓÃWindows NT ServerºÍNTFS£¨NT File System£¬NTµÄÎļþϵͳ£©ÄÚÖõݲȫÌØÐÔ£¬½¨Á¢Ç¿´ó£¬Áé»î¶ø°²È«µÄInternetºÍIntranetÕ¾µã¡£

IISÖ§³ÖHTTP£¨Hypertext Transfer Protocol£¬³¬Îı¾´«ÊäЭÒ飩£¬FTP£¨File Transfer Protocol£¬Îļþ´«ÊäЭÒ飩ÒÔ¼°SMTPЭÒ飬ͨ¹ýʹÓÃCGIºÍISAPI£¬IIS¿ÉÒԵõ½¸ß¶ÈµÄÀ©Õ¹¡£IISÖ§³ÖÓëÓïÑÔÎ޹صĽű¾±àдºÍ×é¼þ£¬Í¨¹ýIIS£¬¾Í¿ÉÒÔ¿ª·¢ÐÂÒ»´ú¶¯Ì¬µÄ£¬¸»ÓÐ÷ÈÁ¦µÄWebÕ¾µã¡£

IISµÄÒ»¸öÖØÒªÌØÐÔÊÇÖ§³ÖASP¡£IIS 3.0°æ±¾ÒÔºóÒýÈëÁËASP£¬¿ÉÒÔºÜÈÝÒ×µÄÕÅÌù¶¯Ì¬ÄÚÈݺͿª·¢»ùÓÚWebµÄÓ¦ÓóÌÐò¡£¶ÔÓÚÖîÈçVBScript£¬JavaScript¿ª·¢Èí¼þ£¬»òÕßÓÉVisual Basic£¬Java£¬Visual C++¿ª·¢ÏµÍ³£¬ÒÔ¼°ÏÖÓеÄCGI½Å±¾¿ª·¢µÄÓ¦ÓóÌÐò£¬IIS¶¼Ìṩǿ´óµÄ±¾µØÖ§³Ö¡£

2.4£®Dreamweaver CS5¿ª·¢¹¤¾ß

Dreamweaver CS5ÊÇÒ»¿îרҵµÄHTML±à¼­Æ÷£¬ÓÃÓÚ¶ÔWebÕ¾µã¡¢WebÒ³ºÍWebÓ¦ÓóÌÐò½øÐÐÉè¼Æ¡¢±àÂëºÍ¿ª·¢¡£ÎÞÂÛÊÇϲ»¶Ö±½Ó±àдHTML´úÂëµÄ¼ÝÔ¦¸Ð»¹ÊÇÆ«°®ÔÚ¿ÉÊÓ»¯±à¼­»·¾³Öй¤×÷£¬Dreamweaver¶¼¿ÉÒÔÌṩ°ïÖúÁ¼¶àµÄ¹¤¾ß£¬·á¸»Web´´×÷ÌåÑé¡£

DreamweaverÊÇMacromedia¹«Ë¾µÄ³öÆ·µÄÒ»¿î"Ëù¼û¼´ËùµÃ"µÄÍøÒ³±à¼­¹¤¾ß¡£ÓëFrontPage²»Í¬£¬Dreamweaver²ÉÓõÄÊÇMac»ú¸¡¶¯Ãæ°æµÄÉè¼Æ·ç¸ñ£¬DreamweaverµÄÖ±¹ÛÐÔÓë¸ßЧÐÔÊÇÒ»°ãÈí¼þËùÎÞ·¨±ÈÄâµÄ¡£DreamweaverÌṩ´úÂëÊäÈëÌáʾ¹¦ÄÜ£¬¿ÉÒÔ²»±ØÈ¥¼Ç´óÁ¿µÄ±êÇ©£¬·½·¨ºÍº¯Êý£¬Ö»Òª¶ÔËüÃÇÓÐÒ»¶¨Ó¡Ï󣬼´¿É¸ù¾ÝÌáʾд³öÍêÕûµÄ´úÂë¡£¶ÔÓÚÍøÒ³Éè¼ÆÖг£ÓõĴúÂ룬DreamweaverÌṩÁËÏֳɵÄÄ£¿é£¬²åÈë¼´¿É¡£¶øÕâЩÍùÍùÊǺÜÀ§ÈÅ¿ª·¢Õߵķ³Ëö²Ù×÷¡£

Dreamweaver¶ÔÓÚDHTML£¨¶¯Ì¬ÍøÒ³£©µÄÖ§³ÖÌرðºÃ£¬¿ÉÒÔÇá¶øÒ×¾ÙµØ×ö³öºÜ¶àѣĿµÄ»¥¶¯Ò³ÃæÌØЧ¡£²å¼þʽµÄ³ÌÐòÉè¼ÆʹµÃÆ书ÄÜ¿ÉÒÔÎÞÏÞµÄÀ©Õ¹¡£Dreamweaver¼¸ºõÖ§³ÖÏÖÓеÄÍøÒ³¿ª·¢¼¼Êõ£¬È磺ASP VBScript£¬ASP JavaScript£¬ASP.NET VB,ASP.NET C#,JSPµÈ¡£DreamweaverÓëFlash¡¢Firework²¢³ÆΪMacromediaµÄÍøÒ³ÖÆ×÷Èý½£¿Í£¬ÓÉÓÚÊÇͬһ¹«Ë¾µÄ²úÆ·£¬Òò¶øÔÚ¹¦ÄÜÉÏÓÐ×ÅÒ»¸ö·Ç³£½ôÃܵĽáºÏ¡£Òò´Ë£¬Dreamweaver·Ç³£ÊʺϿª·¢¶¯Ì¬ÍøÒ³¡£µ±È»DreamweaverÒ²´æÔÚ×ÅһЩÎÊÌâ¡£ËüÕ¾ÓõÄϵͳ×ÊÔ´½Ï¶à£¬ÔËÐÐʱËٶȽÏÂý£¬Òò´ËÊʺϿª·¢´óÐ͵ÄÍøÒ³£¬µ±Ö»ÐèÒª¶ÔÍøÒ³½øÐÐһЩµ÷ÊÔʱºÜ²»½Ï·½±ã¡£

µÚÈýÕ ÐèÇó·ÖÎö

ÐèÇó·ÖÎöÊÇÖ¸Àí½âÓû§ÐèÇ󣬾ÍÈí¼þ¹¦ÄÜÓë¿Í»§´ï³ÉÒ»Ö£¬¹À¼ÆÈí¼þ·çÏÕºÍÆÀ¹ÀÏîÄ¿´ú¼Û£¬×îÖÕÐγɿª·¢¼Æ»®µÄÒ»¸ö¸´ÔÓ¹ý³Ì¡£ÐèÇó·ÖÎöÔÚÕû¸öÈí¼þ¿ª·¢¹ý³ÌÖУ¬¾ßÓоö²ßÐÔ¡¢·½ÏòÐÔ¡¢²ßÂÔÐÔ¡£¼òÑÔÖ®£¬ÐèÇó·ÖÎöµÄÈÎÎñ¾ÍÊǽâ¾ö¡°×öʲô¡±µÄÎÊÌ⣬ÊÇҪȫÃæµØÀí½âÓû§µÄ¸÷ÏîÐèÇ󣬲¢×¼È·µØ±í´ïËù½ÓÊܵÄÓû§ÐèÇó¡£

Õë¶ÔÎÒÃǶÔÍøÉÏÂÃÓÎÍøÕ¾µÄµ÷ÑкͷÖÎö£¬ÎÒÃÇ×ܽá³öÈçϵÄÐèÇóÐÅÏ¢£¬·ÖΪÓû§ÐèÇóºÍ¹ÜÀíÐèÇó£º

3.1£®Óû§ÐèÇóºÍºǫ́¹ÜÀíÐèÇó

Óû§£º

² Óû§¿ÉÒԵǼºÍ×¢²á¡£

² Óû§¿ÉÒÔä¯ÀÀ·ç¾°Í¼Æ¬¡£

² Óû§¿ÉÒԲ鿴ÂÃÓÎÐÂÎÅÒÔ±ã¸üºÃµÄÑ¡ÔñÂÃÓÎʱ»ú¡£

² Óû§¿ÉÒÔÑ¡ÔñÂÃÓεأ¬Èç½®ÄÚÂÃÓΡ¢ÖܱßÂÃÓΡ£

² Óû§¿ÉËÑË÷²éѯÏà¹ØÐÅÏ¢

² Óû§¿ÉÒÔ½øÈëÁôÑÔ°å½øÐÐÁôÑÔ¡£

² Óû§¿ÉÒÔÁªÏµÎÒÃDz¢Ó빤×÷ÈËÔ±½øÐн»Á÷¡£

ºǫ́¹ÜÀí£º

² ¹ÜÀíÔ±¿ÉÒÔÌí¼Ó

² ¹ÜÀíÔ±¿É¶ÔÂÃÓÎÐÅÏ¢½øÐÐÔö¼Ó£¬É¾³ý£¬ºÍÐÞ¸ÄÄÚÈÝ¡£

² ¹ÜÀíÔ±¿É¶ÔÍøÒ³µÄ»ù±¾ÉèÖýøÐÐÐ޸ġ£

² ¹ÜÀíÔ±¶ÔÀ¸Ä¿½øÐÐ×ۺϹÜÀí¡£

² ¹ÜÀíÔ±¿É¶ÔÓû§µÄÁôÑÔ½øÐлظ´ºÍɾ³ý¡£

3.2 ϵͳ·ÖÎöÓë»·¾³¿ª·¢ÐèÇó

² ϵͳ¿ª·¢Æ½Ì¨£ºwindows XP¡£

² ϵͳ¿ª·¢ÓïÑÔ£ºASPÓïÑÔ¡£

² ¹ÜÊý¾Ý¿â¹ÜÀíϵͳ£ºAccess¡£

² ±¾µØ²âÊÔ·þÎñÆ÷£ºIIS¡£

²²âÊÔÍøվƽ̨£ºWindows XPºÍIEä¯ÀÀÆ÷¡£

3.3 ÍøÕ¾µÄ¹¦ÄÜÄ£¿é¼ò½é

ͼ1 °®ÂÃÓÎÍøվϵͳģ¿é

µÚËÄÕ ϵͳÉè¼Æ

±¾½×¶ÎµÄ»ù±¾Ä¿±êÊǽâ¾öϵͳÈçºÎʵÏÖµÄÎÊÌ⣬Ҳ½Ð×ö¸ÅÒªÉè¼Æ£¬±¾½×¶ÎµÄÖ÷ÒªÈÎÎñÊÇ»®·Ö³öϵͳµÄÎïÀíÔªËؼ°Éè¼ÆÈí¼þµÄ½á¹¹£¬Íê³ÉÈí¼þ¶¨ÒåʱÆÚµÄÈÎÎñÖ®ºó¾ÍÓ¦¸Ã¶Ôϵͳ½øÐÐ×ÜÌåÉè¼Æ£¬¼´¸ù¾Ýϵͳ·ÖÎö²úÉúµÄ½á¹ûÀ´È·¶¨Õâ¸öϵͳÓÉÄÄЩϵͳºÍÄ£¿é×é³É£¬ÕâЩϵͳºÍÄ£¿éÓÖÈçºÎÓлúµÄ½áºÏÔÚÒ»Æð£¬Ã¿¸öÄ£¿éµÄ¹¦ÄÜÈçºÎʵÏÖ¡£ÏµÍ³Éè¼ÆµÄÄ¿±êÊÇʹϵͳʵÏÖÓû§ËùÒªÇóµÄ¹¦ÄÜ£¬Í¬Ê±£¬Á¦Õù´ïµ½¸ßЧÂÊ¡¢¸ß¿É¿¿ÐÔ¡¢¿ÉÐÞ¸ÄÐÔ£¬²¢ÇÒÈÝÒ×ÕÆÎÕºÍʹÓá£

4.1 ϵͳģ¿é¹¦ÄÜÉè¼Æ

ϵͳ¸÷¹¦ÄܾßÌå·ÖÎö£¬ÒÔϾÍÊÇϵͳģ¿éÁ÷³Ìͼ¡£

(1)Óο͵Ǽ:

µ±ÓοÍÕýÈ·µÇ¼µ½ÏµÍ³ºó£¬´Ë¹¦Äܽ«±»¼¤»î£¬»áÔ±ÄÜÐ޸ĸöÈËÐÅÏ¢£¬ÁôÑÔ¡£Óû§×¢²áºÍµÇ¼ÊÇÿ¸öÍøÕ¾Öв»¿ÉȱÉٵŦÄÜÖ®Ò»¡£

(2)ÁôÑÔ°å:

ÁôÑÔ°å¿ÉÒÔʵÏÖÍøÕ¾¹ÜÀíÔ±ÓëÓû§Ö®¼äµÄ¹µÍ¨£¬ÊÕ¼¯Óû§µÄÐÅÏ¢£¬Ò²ÊÇÍøÕ¾½¨Éè²¢²»¿ÉÉÙµÄÒ»¸öÖØҪϵͳ¡£±¾ÍøÕ¾ÖÐÓû§¿ÉÒÔ°Ñ×Ô¼º¶ÔÍøÕ¾µÄÒâ¼ûºÍ½¨ÒéдÔÚÁôÑÔ°åÉÏ£¬¹ÜÀíÔ±¿ÉÒÔͨ¹ý»Ø¸´ºÍɾ³ýÀ´¹ÜÀíÕâЩÁôÑÔ¡£

(3)¹ÜÀíÔ±µÇ¼

µ±¹ÜÀíÔ±ÕýÈ·ÊäÈëÓû§ÃûºÍÃÜÂëºó£¬ÏµÍ³»á×Ô¶¯Ìøתµ½¹ÜÀíÔ±Ò³Ã棬¹ÜÀíÔ±¾Í¿ÉÒÔ¶ÔÓοÍ×¢²áÐÅÏ¢¡¢ÁôÑÔ¡¢¶ÔϵͳµÄÐÅÏ¢½øÐÐÐ޸ģ¬¶ÔÂÃÓÎÐÅÏ¢½øÐÐÔöɾ¸Ä¡£

(4)ºǫ́¹ÜÀí

¶ÔÓÚÈκÎÒ»¸öWebÓ¦ÓóÌÐòÀ´Ëµ£¬¶¼Ó¦¾ß±¸Ò»¸öºǫ́¹ÜÀíµÄ¹¦ÄÜ£¬¸ºÔð¶ÔÕû¸öÓ¦ÓóÌÐòµÄ¿ØÖƹÜÀí¡£´ÓʵÏÖ·½Ê½ÉÏ£¬¾ÍÊÇÓû§¿ÉÒÔ¶Ôϵͳ¸÷ÖÖÊý¾Ý¼Ç¼½øÐÐÌí¼Ó¡¢²é¿´¡¢±à¼­ºÍɾ³ýµÈ¹¤×÷£¬ÕâЩ²Ù×÷ÊÇÓÉÍøÕ¾¹ÜÀíÔ±À´Íê³ÉµÄ¡£

ÓοÍ×¢²á¹ÜÀí£º

¹ÜÀíÔ±½øÈëÓû§×¢²á×ÊÁÏÒ³Ãæ¿ÉÒÔÉóºËÓû§µÄ×¢²á×ÊÁÏ£¬¶Ô²»·ûºÏ¹æÔòµÄ×¢²áÓû§¿ÉÒÔ½øÐÐɾ³ý¡£

ÁôÑÔ°å¹ÜÀí£º

¹ÜÀíÔ±½øÈëÁôÑÔ°åÒ³Ãæ¿ÉÒԲ鿴Óû§ÔÚÁôÑÔ°åÉϵÄÁôÑÔ£¬¶Ô²»·ûºÏ¹æÔòºÍ·¨¹æµÄÁôÑÔ½øÐÐɾ³ý£¬¶Ô·ûºÏµÄ½øÐлظ´¡£

À¸Ä¿×ۺϹÜÀí£º

¹ÜÀíÔ±½øÈëÀ¸Ä¿×ۺϹÜÀí½çÃ棬¿É¶ÔÍøÒ³ÉÏÏÔʾµÄÂÃÓζ¯Ì¬£¬ÂÃÓÎÐÂÎÅ£¬ºÍ¸÷¸öµØ·½µÄ½éÉܽøÐÐÔö¼ÓºÍÐ޸ģ¬È·±£ÂÃÓÎÐÂÎŵÄʵʱÐÔ¡£

ǰ̨ÏÔʾ¹ÜÀí£º

¹ÜÀíÔ±½øÈëºǫ́¹ÜÀíÖ®ºó£¬¿ÉÒÔ¶ÔÍøÒ³µÄ°æȨÐÅÏ¢Ð޸ģ¬²¢½«Ò»Ð©À¸Ä¿Òþ²Ø»òÏÔʾ£¬´ïµ½¶ÔÊ×Ò³µÄ¸ß¼¶¹ÜÀí¡£

4.2 Êý¾Ý¿âÉè¼Æ

4.2.1 Êý¾Ý¿â¹¦ÄÜ·ÖÎö

±¾ÏµÍ³²ÉÓÃAccessÊý¾Ý¿â¡£Óû§µÄÐèÇó¾ßÌåÌåÏÖÔÚ¸÷ÖÖ¶ÔÂÃÓÎÍøÕ¾Öи÷ÀàÐÅÏ¢µÄ²éѯ¡¢Ð޸ģ¬Õâ¾ÍÒªÇóÊý¾Ý¿â½á¹¹Äܳä·ÖÂú×ã¸÷ÖÖÐÅÏ¢µÄÊä³öºÍÊäÈë¡£

Õë¶ÔÂÃÓÎÍøÕ¾µÄÐèÇó£¬Í¨¹ý¶ÔÂÃÓÎÍøÕ¾¹¤×÷¹ý³ÌµÄÄÚÈݺÍÊý¾ÝÁ÷³Ì·ÖÎö£¬Éè¼ÆÈçÏÂÃæËùʾµÄÊý¾ÝÏîºÍÊý¾Ý½á¹¹£º

¹ÜÀíÔ±×ÊÁÏÐÅÏ¢£¬°üÀ¨µÄÊý¾ÝÏîÓУº¹ÜÀíÔ±ID¡¢¹ÜÀíÔ±Ãû³Æ¡¢¹ÜÀíÔ±ÃÜÂë

Óû§×ÊÁÏÐÅÏ¢£¬°üÀ¨µÄÊý¾ÝÏîÓУºÓû§ID¡¢Óû§Ãû³Æ¡¢Óû§ÃÜÂë¡¢Óû§ÐÕÃû¡¢Óû§ÓÊÏä¡¢µØÖ·¡¢QQ¡¢ÁªÏµµç»°¡¢Óʱࡣ

ÐÅÏ¢±í£¬°üÀ¨µÄÊý¾ÝÏîÓУºÐÅÏ¢·ÖÀà¡¢ÐÅÏ¢ÄÚÈÝ

ÁôÑÔ°åÐÅÏ¢±í£¬°üÀ¨µÄÊý¾ÝÏîÓУºÐÅÏ¢¡¢ÄÚÈÝ¡¢ÐÕÃû¡¢ÁôÑÔʱ¼ä

ÓÐÁËÉÏÃæµÄÊý¾Ý½á¹¹¡¢Êý¾ÝÏîºÍÊý¾ÝÁ÷³Ì£¬ÎÒÃǾÍÄܽøÐÐÏÂÃæµÄÊý¾Ý¿âÉè¼Æ¡£

Óû§×¢²á±í£º

¹ÜÀíÔ±µÇ½±í

癄ﱒ

Ôö¼ÓÐÅÏ¢±í

4.2.2 Êý¾Ý¿âE-Rͼ

4.2.3 Êý¾Ý¿âÓëaspµÄÁ´½Ó

<%

Dim pagecount,page,pagcount,total,mypage '¶¨Òå±äÁ¿

Dim oConn,oRs,sSql,Id

Dim a,b,c,d,e,f

Dim i, j, k, x, y, z,gaozhen,ReUrl,action

Dim TT,SS,NewsId,PBId,PSID,PPGGEE

PBId = request("PBId")

PSID = request("PSID")

NewsId= request("NewsId")

PPGGEE= request("PPGGEE")

TT= request("TT")

SS= request("SS")

ReUrl= request("ReUrl")

gaozhen = request("gaozhen")

action = request("action")

Dim IsError,Err

IsError = False

Err = False

Id = Request("Id")

Set oConn = Server.CreateObject("ADODB.CONNECTION")

Set oRs =server.createobject("adodb.recordset")

'¶ÁÈ¡ÍøÕ¾µÄ»ù±¾ÐÅÏ¢

Dim sWeb,sUrl

Set sWeb = oConn.Execute("SELECT top 1 Id,WebTitle,WebUrl,WebKeyWord,WebDescription,WebAuthor,WebCopyright,WebICP,WebTel,WebMob,WebFax,WebEmail,WebAddress,WebZip,WebRoad,WebQQ,WebCom,WebSafe FROM [WebInfo] WHERE Id = 1")

sUrl = sWeb("WebUrl")

4£®3 Ò³ÃæÉè¼Æ

4.3.1Ò³Ãæ²¼¾Ö

Ê×Ò³Ö÷ÒªÒÔÕ¹ÏÖÍøÕ¾Ãæò£¬¼òµ¥µÄ½éÉܼ°ÑÝʾΪÖ÷£¬²¼¾ÖÈçͼËùʾ¡£

ͼ5Ò³Ãæ²¼¾Ö

4.3.2Ò³Ãæ·ç¸ñ

±¾ÍøÕ¾Ö÷Òª½éÉÜн®¸÷¸öµØ·½µÄÂÃÓξ°µã£¬ÎªÁËÍ»³öн®¹ãÀ«µÄ²ÝÔ­£¬Ö÷ÒªÒÔÂÌɫΪÖ÷µ÷£¬²¼¾Ö¼òµ¥Ã÷ÁË£¬·½±ã¿ì½Ý£¬½áºÏÁËн®ÌØÓеķç¸ñ¡£

µÚÎåÕ ϵͳʵÏÖ

5.1 ǰ̨

ÏÔʾҳÃæÖ÷Òª°üÀ¨Ê×Ò³¡¢ÁбíÒ³¡¢ÄÚÈÝÒ³ºÍ¹ÜÀíÒ³ÃæµÈ¡£

5.1.1 Ê×ҳʵÏÖ

Ê×Ò³É϶˰üº¬Á˵ǽ¡¢×¢²á¡¢logo¡¢ËÑË÷¡¢ÈÕÆÚ¡¢µ¼º½À¸ºÍÈÈÃÅÍƼöÈçͼ6£º

ͼ6 Ê×Ò³É϶Ë

£¨1£©µÇ½´úÂ룺If Request("action")="loginsave" Then

Usrmail=trim(request("ddaaaa"))

Usrpass=trim(request("ddcccc"))

If Usrmail="" Or Usrpass="" Then

Call Alert ("ÐÅÏäºÍÃÜÂë²»ÄÜΪ¿Õ¡£","-1")

End If

Set oRs=server.createobject("adodb.recordset")

sSql="select top 1 * from [LstUser] where UsrEmail='"&Usrmail&"' or UsrName='"&Usrmail&"'"

oRs.open sSql,oconn,1,1

If not oRs.eof then

If oRs("Usrpass") <> md5(Usrpass,32) then

Call Alert ("ºÜ±§Ç¸,ÄúµÄÃÜÂë´íÎó.","-1")

Else

If CLng(oRs("UsrState"))= 0 Then

Call Alert ("ºÜ±§Ç¸,ÄúµÄÕʺű»Ëø¶¨,ÓÐÎÊÌâÇë×Éѯ¹ÜÀíÔ±.","-1")

Else

oconn.execute("update [LstUser] set UsrIP = '"&useripp&"' , UsrLogintime = now() where Id = "& oRs("Id") &"")

session("userid")=oRs("Id")

session("username")=oRs("Usrname")

Response.Cookies("Type") = oRs("Id")

Response.Cookies("Type").Expires = date()+30

Response.Cookies("Type").Domain = ".yourname.com"

Response.Cookies("Type").Secure = False

response.redirect "/LstUser.asp?gaozhen=myinfo"

End If

End If

Else

Call Alert ("ºÜ±§Ç¸,²»´æÔÚÄúÊäÈëµÄÕʺÅ.","-1")

End If

End If

£¨2£©×¢²á´úÂ룺If Request("action")="regsave" Then

Set oRs=server.createobject("adodb.recordset")

sSql="Select * from [LstUser] where UsrEmail='"&Usrmail&"' or UsrName='"&Usrname&"'"

oRs.open sSql,oconn,1,3

If not oRs.eof then

Call Alert ("ÐÅÏä»òêdzÆÖظ´.","-1")

Else

oRs.addnew

oRs("UsrEmail")=Usrmail

oRs("UsrName")=Usrname

oRs("UsrPass")=md5(Usrpass,32)

oRs("UsrTel")=UsrTel

oRs("UsrAddress")=UsrAddress

oRs("UsrFax")=UsrFax

oRs("UsrZip")=UsrZip

oRs("UsrMoney")=0

oRs("UsrState")=1

oRs("UsrLogintime")=now()

oRs("UsrAddtime")=now()

oRs("UsrIP")=useripp

oRs.update

session("userid")=oRs("Id")

session("username")=oRs("Usrname")

Response.Cookies("Type") = oRs("Id")

Response.Cookies("Type").Expires = date()+30

Response.Cookies("Type").Domain = ".yourname.com"

Response.Cookies("Type").Secure = False

oRs.close

response.redirect "/LstUser.asp?gaozhen=myinfo"

Set oRs = Nothing

End If

End If

£¨3£©ËÑË÷£ºÖ§³Ö¾«È·ËÑË÷£¬Ö§³ÖÄ£ºýËÑË÷¡£

ËÑË÷´úÂ룺

£¨4£©ÈÕÆÚ´úÂ룺function RunGLNL(){

var today=new Date();

var d=new Array("ÐÇÆÚÈÕ","ÐÇÆÚÒ»","ÐÇÆÚ¶þ","ÐÇÆÚÈý","ÐÇÆÚËÄ","ÐÇÆÚÎå","ÐÇÆÚÁù");

var DDDD=(today.getYear()<100 ? today.getYear()+1900:today.getYear())+"Äê"+(today.getMonth()+1)+"ÔÂ"+today.getDate()+"ÈÕ";

DDDD = DDDD + " " + d[today.getDay()];

DDDD = DDDD+ " " + (CnDateofDateStr(today));

//DDDD = DDDD+ " " + SolarTerm(today);

document.write(DDDD);

}......

Ê×Ò³Öм䲿·ÖÓɲ»Í¬µÄ¿ò¼Ü·Ö¿ª£¬ÓзÏß·ÖÀà¡¢ÂÃÓι¤¾ß¡¢ÂÃÓÎÐÂÎÅ¡¢¹úÄÚÂÃÓκÍÖܱßÂÃÓεÈÐÅÏ¢±í£¬ÕâЩ²¼¾Ö¶¼ÔÚindex.aspÖÐÉè¼Æ

ͼ7 Ê×Ò³Öм䲿·Ö

ÏÔʾÆäÄÚÈÝÔÚºǫ́¹ÜÀíÖйÜÀí£º

<%

Dim Crod

Set oRs = oConn.Execute(¡°SELECT Id,MenuTitle,MenuType,MenuUrl,(select top 1 Id from [LstMenuSmall] where MenuId=LstMenuBig.id) FROM [LstMenuBig] where id in(¡°&nroad&¡±)ORDER BY MenuIndex ASC¡±)

If Not oRs.EOF Then Crod= oRs.GetRows

Set oRs = Nothing

%>

<%Call Tophhh()%>