ASP¸ß¼¶¼¼Êõ¾«Ñ¡¼¯
ASP¸ß¼¶¼¼Êõ¾«Ñ¡¼¯
Ò»¡¢GetRowsµÄʹÓ÷½·¨£º
<%
Set conn=Server.CreateObject("Adodb.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("test.mdb")
Set Rs=Server.CreateObject("Adodb.Recordset")
Rs.Open "Select Top 2 * from ±íÃû",conn,0,1
Dim Array_str
Array_str = rs.GetRows()
Response.Write "µÚÒ»Ìõ¼Ç¼£º<br>"
Response.Write Array_str(0,0)&"<br>"
Response.Write Array_str(1,0)&"<br>"
Response.Write Array_str(2,0)&"<br>"
Response.Write Array_str(3,0)&"<br>"
Response.Write "µÚ¶þÌõ¼Ç¼£º<br>"
Response.Write Array_str(0,1)&"<br>"
Response.Write Array_str(1,1)&"<br>"
Response.Write Array_str(2,1)&"<br>"
Response.Write Array_str(3,1)&"<br>"
%>
ÊìϤGetRowsÄã»á·¢ÏÖ²Ù×÷Êý¾Ý¿â¸ü¼ò½Ý¡¢ËٶȸüÓÅ»¯¡£Óŵã¿ÉÊǺܶàµÄŶ£º£©
¶þ¡¢ÉùÃ÷±äÁ¿ÊDZØÒªµÄÂð£¿
ÒÔÏÂÇé¿öÐèÒªÉùÃ÷±äÁ¿£º
1.ÄãÊÇÒ»¸öºÃµÄ³ÌÐòÔ±
2.д¸ßÖÊÁ¿µÄ´úÂë
¼ÓÈëÒÔÏ´úÂë¿ÉÒÔÇ¿ÖÆÉùÃ÷±äÁ¿£º
<%Option Explicit%>
Èý¡¢ÈçºÎÔÚ¿Í»§¶Ëµ÷Ó÷þÎñÆ÷¶ËµÄº¯Êý£¿
Ô¶³Ì½Å±¾µ÷Óü¼Êõ£¨Remote Scripting£©µÄÌصãÊÇ¿Í»§¶Ë½Å±¾µ÷Ó÷þÎñÆ÷½Å±¾Ê±ÎÞÐèË¢ÐÂÕû¸öÒ³Ãæ¡£
Ò»°ãÇé¿öÏ£¬WebÒ³ÃæÐèÒªÓë·þÎñÆ÷½»»¥Ê±±ØÐëÌá½»±íµ¥Êý¾Ý£¬Ë¢ÐÂÕû¸öÒ³Ãæ¡£¶øÀûÓÃÔ¶³Ì½Å±¾µ÷Óü¼Êõ£¬¿Í»§¶Ë½Å±¾¿ÉÒÔÏñµ÷Óñ¾µØº¯ÊýÒ»Ñùµ÷ÓÃÔ¶³Ì½Å±¾º¯Êý£¬ÌرðÊÇÔÚ¸´ÔÓµÄ±íµ¥ÑéÖ¤ºÍƵ·±µÄÊý¾Ý¿â²Ù×÷ÖУ¬ÕâÖÖÓÅÊƸüÊǵõ½ÁËÁÜÀ쾡Öµķ¢»Ó¡£
ËüµÄ»ù±¾ÔÀíÊÇÆä½èÖú±¾ÉíÌṩµÄÒ»×é½Ó¿Úº¯Êý£¬¿Í»§¶Ë³ÌÐò¿ÉÒÔͨ¹ýÒ»¸ö´úÀí¹ý³Ì£¨Ò»¸öjava applet£©µ÷Ó÷þÎñÆ÷¶Ë´úÂë¡£JavaApplet(RSProxy.class)ÔÚºǫ́¹¤×÷£¬Í¨³£Çé¿öÏÂÓû§´úÂë²¢²»ÐèÒªÖ±½Ó²Ù×÷Ëü£¬ËüµÄÅäÖÃÒ²ÊÇ×Ô¶¯Íê³ÉµÄ¡£Ô¶³Ì½Å±¾µ÷ÓüȿÉÒÔÊÇͬ²½µ÷ÓÃ---µ÷ÓÃÃüÁî·¢³öºóÒ»Ö±µÈ´ý£¬Ö±µ½·þÎñÆ÷Ö´Ðк¯Êý½áÊøºó·µ»Ø£»Ò²¿ÉÒÔÊÇÒì²½µ÷ÓÃ---º¯Êýµ÷ÓúóÁ¢¼´·µ»Ø£¬µ÷ÓñØÐëͬʱ¸ø³ö»Øµ÷º¯Êý¡£Ò»¸ö»ù±¾Ô¶³Ì½Å±¾µ÷Óü¼Êõ±ØÐë°üº¬ÈçÏÂÎļþ£º
RS.htm£º°üº¬¿Í»§¶ËÖ§³Ö´úÂë
RSProxy.class£ºÕâÊÇÒ»¸öJava Applet£¬Êµ¼ÊÍê³É¿Í»§/·þÎñÆ÷½»»¥¹ý³Ì
RS.asp£º·þÎñÆ÷¶ËÖ§³Ö´úÂë
ʹÓÃÔ¶³Ì½Å±¾µ÷Óù¦ÄÜʱ£¬¿Í»§¶ËºÍ·þÎñÆ÷¶Ë´úÂ붼±ØÐë·ûºÏÒ»¶¨µÄÒªÇó£ºÔÚ·þÎñÆ÷¶Ë£¬Ê×ÏȱØÐëÆ
Ïà¹ØÎĵµ£º
Ç°Á½Ì죬¿Í»§ÐèÒªÌí¼ÓÏÂÀ²Ëµ¥£¬ÎÒÔεĺܣ¬ºÜ¼òµ¥µÄÒ»¸öÎÊÌâ°ÑÎÒÓÕµ¼ÁËÁ½ÈýÌ죬ºóÀ´ÐÑÎò¹ýÀ´£¬ÕæÏë´ò×Ô¼º¡£
֮ǰÎÒҲʹÓùýdivÌ×divµÄ·½·¨£¬Ö»Òª¿ØÖÆËûÃǵÄλÖþͿÉÒÔÁË£¬µ«Õâ´ÎÎÒûÓУ¬Ê¹ÓõÄÔÚ±í¸ñʽÌ×div£¬×Ô¼º×ÁÄ¥ÁË°ëÌ죬ÒѾÍü¼ÇÁËdivËùÏÔʾµÄÊÇÏà¶Ô ......
Asp²Ù×÷DTS½øÐдú²ÎÊýµÄÊý¾Ýµ¼Èëµ¼³ö
ÄêÇ°½ÓÁËÒ»¸öСÏîÄ¿,ÆäÖÐÒ»²¿·ÖÊǽ«sqlÖеÄÊý¾Ý½øÐÐÓÐÑ¡ÔñµÄµ¼³öµ½Ò»¸ömdbÖС£
ÕâЩÊÇÍêÈ«¿ÉÒÔͨ¹ýaspµÃsqlÓï¾ä½øÐвÙ×÷µÄ£¬µ«ÊÇ»¹ÊÇÏë°ÑÖ÷Òªµ¼³öµÄÈÎÎñ½»¸øsql serverÈ¥×ö£¬aspÖ÷ÒªÊǵ÷¶¯Õâ¸ö³ÌÐò¶øÒÑ¡£
Ïëµ½ÒÔÇ°×ö¹ýµÄ¶«Î÷£¬¾õµÃʵÏÖÆðÀ´²¢²»ÄÑ£¬Ö»ÊÇÒ»¸ö²ÎÊýµÄÎÊÌâ¡£
¿ªÊ¼ÊµÏÖ£ ......
½ñÌìÖØÐÂÕûÀíµçÄÔ£¬ÕÒµ½Ò»¸öÎļþ£¬¿´ÁËÏÂÈÕÆÚ£¨2006.11.5£© £¬Å²»Ð¡ÐÄÔÙ¶ªÁË£¬´æµ½ÍøÉÏÀ´É¹É¹¡£
°²×°ÓëÅäÖÃ
1.5.1°²×°IIS
¿ØÖÆÃæ°å_ Ìí¼Óɾ³ý³ÌÐò_Ìí¼Óɾ³ýWindows×é¼þ_
"internetÐÅÏ¢·þÎñ(IIS)"¶Ô»°¿ò_ÏêϸÐÅÏ¢——"Word Wide Web·þÎñÆ÷" _ µ¥»÷Á½¸ö“È·¶¨”—&mda ......
asp nowº¯Êý,ASPʱ¼äº¯ÊýÏê½â ,aspʱ¼äº¯Êý´óÈ«,asp ÐÇÆÚº¯Êý
now() »ñÈ¡µ±Ç°ÏµÍ³ÈÕÆÚºÍʱ¼ä,ASPÊä³ö¿ÉÒÔÕâÑùд£º<%=now()%>
Year(now()) »ñÈ¡Äê·Ý£¬ ASPÊä³ö£º<%=Year(now())%>
Month(now()) »ñÈ¡µ±Ç°Ô·ݣ¬ASPÊä³ö£º<%=Month(now())%>
day(now()) ......
aspÖвåÈëÓëÐÞ¸ÄÊý¾ÝµÄ¼¸ÖÖ·½Ê½¡£ÎªÁË·½±ã½â˵£¬ÎÒÃÇÏȽ¨Á¢Ò»¸öÃûΪtestµÄ±í£¬±íÄÚÖ»ÓÐÁ½¸öÊý¾Ý
Ïî:usernameºÍemail,·Ö±ðÓÃÀ´´æ´¢Óû§ÃûÓëÓÊÏäµØÖ·¡£
1.ÀûÓÃinsertÓï¾ä²åÈëÊý¾Ý£º
insertÊÇsqlÓï¾äµÄ»ù±¾Ö¸ÁîÖ®Ò»£¬ Ó÷¨ºÜ¼òµ¥£¬ÕâÀïÎÒÖ»½«Æä»ù±¾¸ñʽÁгö.
´úÂëÈçÏ£º
set conn=s ......