ASP³ÌÐòʵÏÖÍøÒ³Î±¾²Ì¬Ò³Ô´´úÂë
ºÜ¼òµ¥µÄ½Ì³Ì£¬Ï׸øÏ²»¶SEOµÄÅóÓÑÃÇ¡£°Ñhttp://www.***.cn/article.asp?logID=26 Ìæ»»³Éhttp://www.***.cn/article.asp?/a26.html¡£²»ÐèҪͨ¹ýiis+ISAPI_Rewrite×ö»ùÓÚIISµÄurl rewrite
Ò»¡¢Êý¾Ý¿âºÜ¼òµ¥Ê¹ÓÃACCESS£¬Data.mdb½¨Á¢Ò»¸ö±íArticle£¬Èý¸ö×ֶΣºID£¬Title£¬Content£»×Ô¶¯±àºÅ¡¢±êÌâ¡¢ÎÄÕÂÄÚÈÝ¡£
¶þ¡¢Config.asp
ASP/Visual Basic´úÂë
Èý¡¢Default.asp
ÒÔÏÂΪÒýÓõÄÄÚÈÝ£º
ASP/Visual Basic´úÂë
ËÄ¡¢Article.asp
ASP/Visual Basic´úÂë
±êÌâ:
ÄÚÈÝ:
Õâ¸ö½Ì³ÌÒѾÄÜʵÏÖ×î»ù±¾µÄ¹¦ÄÜ£¬¾ßÌå´ó¼Ò¾ÍÏëÔõôӦÓþͰËÏɹýº££¬¸÷ÏÔÉñͨÁË£¡
Ïà¹ØÎĵµ£º
Access Á¬½Ó×Ö·û´®
strConnect = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyDatabase.mdb;”
Access 2007 Á¬½Ó×Ö·û´®
strConnect = “Provider=Microsoft.ACE.OLEDB.12.0;Mode=Share Exclusive;Data Source=C:\MyDatabase.accdb;”
MSSQL Server Á¬½Ó×Ö·û´®
strConnect = &ldquo ......
ÔõôÓÃaspÅжÏÏÂÃæµÄÐÅÏ¢ÕâÀïÎÒÊÇ¿´µ½¶¯Ì¬ÍøµÄ.
FSOÎļþ¶Áд √ Jmail·¢ËÍÓʼþÖ§³Ö ×
CDONTS·¢ËÍÓʼþÖ§³ ......
¡¡ASPÁ¬½ÓÊý¾Ý¿âµÄ11ÖÖ·½·¨——±¾ÎÄ×ܽáÁËʹÓÃASPÁ´½Ó¸÷ÖÖÊý¾Ý¿âµÄ·½·¨£º
¡¡¡¡1.AccessÊý¾Ý¿âµÄDSN-lessÁ¬½Ó·½·¨:
set adocon=Server.Createobject("adodb.connection")
adoconn.Open"Driver={Microsoft Access Driver(*.mdb)};DBQ="& _
Server.MapPath("Êý¾Ý¿âËùÔÚ·¾¶")
¡¡¡¡2.Access OLE DBÁ¬½Ó·½·¨£ ......
ASPÊÇ΢Èí¹«Ë¾ÊµÏÖ¶¯Ì¬ÍøÒ³µÄÒ»ÖÖ¼¼Êõ¡£
ASPÖ§³ÖһЩ½Å±¾ÓïÑÔ£¬Ö÷ÒªÒÔVBScriptΪÖ÷¡£
ÓëASPÏà±È½Ï£¬Ä㻹¿ÉÒÔÑ¡ÔñÁíÒ»Öпª·ÅÔ´´úÂë±à³ÌÓïÑÔ——PHP£¬PHP¿ÉÒÔÔËÐÐÔÚ¶àÖÖ²Ù×÷ϵͳÏ£¬ÆäÖаüÀ¨LinuxºÍwindows¡£
ËäÈ»ASPÊÇÒ»ÖÖ²»´íµÄ¼¼Êõ£¬µ«´Ó³¤Ô¶¿¼ÂÇÎÒÏàÐÅPHPÔÚ½«À´µÄ¼¼ÊõÁìÓòÀï»áÓв»·²µÄ±íÏÖ¡£
ÎÒÈÏΪÓÐÆß¸ ......
aspÖеÄrs.openÓÚconn.executeµÄÇø±ð
rs.open sql,conn£ºÈç¹ûsqlÊÇdelete,update,insertÔò»á·µ»ØÒ»¸ö¹Ø±ÕµÄ¼Ç¼¼¯£¬ÔÚʹÓùý³ÌÖв»ÒªÀ´¸örs.closeÔÚÎļþ×îºóÔÙдrs.close
Öмä¿ÉÒÔÀ´¶à¸ö¼Ç¼¼¯rs1.open sql1,conn£¬×îºóÒ»¿é¹Ø±Õ¼Ç¼¼¯:rs.close rs1.close
con ......