Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ASpÁ¬½ÓÊý¾Ý¿â

1. ASPÁ¬½ÓAccessÊý¾Ý¿âÓï¾ä
Set Conn=Server.CreateObject("ADODB.Connection")
Connstr="DBQ="+server.mappath("www/bbs.mdb")+";DefaultDir=;DRIVER={Microsoft
AccessDriver(*.mdb)};"
Conn.Open connstr
ÆäÖÐSet Conn=Server.CreateObject("ADODB.Connection")Ϊ½¨Á¢Ò»¸ö·ÃÎÊÊý¾ÝµÄ¶ÔÏó
server.mappath("www/bbs.mdb")ÊǸæËß·þÎñÆ÷access Êý¾Ý¿â·ÃÎʵÄ·¾¶
2. ASPÁ¬½ÓSqlserverÊý¾Ý¿âÓï¾ä
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open"driver={SQLServer};server=202.108.32.94;uid=wu77445;pwd=p780522;database=w
ww_panwei_com"
conn open
ÆäÖÐ/Set conn = Server.CreateObject("ADODB.Connection")ΪÉèÖÃÒ»¸öÊý¾Ý¿âµÄÁ¬½Ó¶ÔÏó
driver=£¨£©¸æËßÁ¬½ÓµÄÉ豸ÃûÊÇSQL-SERVER
serverÊÇÁ¬½ÓµÄ·þÎñÆ÷µÄipµØÖ·£¬UidÊÇÖ¸Óû§µÄÓû§Ãû£¬pwdÊÇÖ¸µÄÓû§µÄpassword£¬
databaseÊÇÓû§Êý¾Ý¿âÔÚ·þÎñÆ÷¶ËµÄÊý¾Ý¿âµÄÃû³Æ


Ïà¹ØÎĵµ£º

ASPÖеļǼ¼¯

eofÊÇaspÖÐrecordset¶ÔÏóÖ¸ÕëµÄÒ»ÖÖ¡£
rs.eof ·µ»Ø¼Ç¼ָÕëÊÇ·ñ³¬³öÊý¾Ý±íÄ©¶Ë£¬true±íʾÊÇ£¬falseΪ·ñ
rs¼Ç¼¼¯ÊÇÎÒÃǾ­³£»áÅöµ½µÄ,ÏÂÃæ¶ÔËüÖî¶àµÄÒÆ¶¯Ö¸Õë½øÐлã×Ü,ÈçÏÂ:
rs.movenext ½«¼Ç¼ָÕë´Óµ±Ç°µÄλÖÃÏòÏÂÒÆÒ»ÐÐ
rs.moveprevious ½«¼Ç¼ָÕë´Óµ±Ç°µÄλÖÃÏòÉÏÒÆÒ»ÐÐ
rs.movefirst ½«¼Ç¼ָÕëÒÆµ½Êý¾Ý±íµÚÒ»ÐÐ ......

ASP×Ö·û´®º¯Êý´óÈ«

º¯Êý Óï·¨ ¹¦ÄÜ
Len Len(string|varname) ·µ»Ø×Ö·û´®ÄÚ×Ö·ûµÄÊýÄ¿£¬»òÊÇ´æ´¢Ò»±äÁ¿ËùÐèµÄ×Ö½ÚÊý¡£
Trim Trim(string) ½«×Ö·û´®Ç°ºóµÄ¿Õ¸ñÈ¥µô
Ltrim Ltrim(string) ½«×Ö·û´®Ç°ÃæµÄ¿Õ¸ñÈ¥µô
Rtrim Rtrim(string) ½«×Ö·û´®ºóÃæµÄ¿Õ¸ñÈ¥µô
Mid Mid(string,start,length) ´Óstring×Ö·û´®µÄstart×Ö·û¿ªÊ¼È¡µÃlength³¤¶ ......

asp¿çÓò¹²ÓÃcookieºÍsessionµÄÎÊÌâ

      
Õ⼸ÌìÒòÎªÍøÕ¾Éæ¼°µ½¶þ¼«ÓòÃû¹²ÓÃsessionµÄÎÊÌ⣬ͷʹ¡£ÔÚÍøÉÏÕÒÁ˺þõÄÁÏ£¬ÖÕÓÚÔÚcsdnÀïÃæÕÒµ½2004Äêǰ±²ÃÇÌÖÂ۵Ľâ¾ö·½°¸£¬¸öÈ˸оõºÜ
ÊÜÓá£
Â¥Ö÷
yufeiyxl£¨Óë
·É£©
ÎÒÒªÏò¸÷λÇë½ÌµÄÊÇCookieµÄ¿çÓò·ÃÎÊÎÊÌâ¡£   
       ......

ASP¿Ø¼þ´óÈ«½²½â

4.1 ³£ÓõÄHTML¿Ø¼þ
4.1.1 ±íµ¥¿Ø¼þ
ÓÃÓÚ½ÓÊÕ¿Í»§¶ËµÄÊäÈ룬²¢½«ÊäÈëµÄ½á¹ûÌá½»¸ø·þÎñÆ÷´¦Àí
1.HtmlForm¿Ø¼þ
 ËùÓеÄWeb Form¿Ø¼þ±ØÐë°üº¬ÔÚÒ»¶ÔHtmlForm¿Ø¼þ±êÇ©ÖÐ
<Form
   Id = "¿Ø¼þ±êʶ"
   Runat = "Server"
   Method = "Post | Get"
   Action = "ÒªÖ´ÐÐ ......

Oracle´óÎı¾ÔÚASPÖдæÈ¡ÎÊÌâµÄ½â¾ö


ÔÚÎÒ¿ª·¢BS½á¹¹³ÌÐòÖУ¬ÓÉÓÚ¾­³£ÐèÒªÔÚORACLEÖд¦ÀíһЩÈÝÁ¿½Ï´óµÄÎı¾Êý¾Ý£¬ËùÒÔ¾­¹ý·´¸´²âÊÔÖÕÓÚÓÃASP³É¹¦½â
¾öÁË´óÎı¾Êý¾ÝÔÚORACLEÏ´æÈ¡ÎÊÌâ¡£
¡¡¡¡
¡¡¡¡Ò»¡¢ÔËÐл·¾³£º
¡¡¡¡1¡¢Microsoft Windows 2000 Server + IIS 5.0
2¡¢Oracle8iÖÐÎıê×¼°æ
¡¡¡¡
¡¡¡¡¶þ¡¢½¨Á¢Êý¾Ý±í£º
¡¡¡¡CREATE TABLE SYSTEM.TEST(
B ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ