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£º·þÎñÆ÷¶ËÖ§³Ö´úÂë
ʹÓÃÔ¶³Ì½Å±¾µ÷Óù¦ÄÜʱ£¬¿Í»§¶ËºÍ·þÎñÆ÷¶Ë´úÂë¶¼±ØÐë·ûºÏÒ»¶¨µÄÒªÇó£ºÔÚ·þÎñÆ÷¶Ë£¬Ê×ÏȱØÐëÆ
Ïà¹ØÎĵµ£º
<%
'ÒÔϲ¿·ÖÊÇÑéÖ¤Ìá½»µÄpageÊÇ·ñΪºÏ·¨µÄ²ÎÊý
'Õⲿ·Ö×îºÃÅжÏÒ»ÏÂÌá½»µÄ²ÎÊýÊÇ·ñΪÊýÖµ×Ö·û
dim page
page=Trim(request("page"))
If page="" Then
page=1
Elseif CInt(page)<=0 then
page=1
else
page=CInt(page)
End If
'½øÐвéѯ£¬È¡³öÒªÏÔʾµÄ¼Ç¼
str=rs1("content")
'°Ñ³ö ......
¡¡¡¡Ò»¡¢ÕýÔò±í´ïʽ¸ÅÊö
Èç¹ûÔÀ´Ã»ÓÐʹÓùýÕýÔò±í´ïʽ£¬ÄÇô¿ÉÄܶÔÕâ¸öÊõÓïºÍ¸ÅÄî»á²»Ì«ÊìϤ¡£²»¹ý£¬ËüÃDz¢²»ÊÇÄúÏëÏóµÄÄÇôÐÂÆæ¡£
Çë»ØÏëÒ»ÏÂÔÚÓ²ÅÌÉÏÊÇÈçºÎ²éÕÒÎļþµÄ¡£Äú¿Ï¶¨»áʹÓà ? ºÍ * ×Ö·ûÀ´°ïÖú²éÕÒÄúÕýѰÕÒµÄÎļþ¡£? ×Ö·ûÆ¥ÅäÎļþÃûÖеĵ¥¸ö×Ö·û£¬¶ø * ÔòÆ¥ÅäÒ»¸ö»ò¶à¸ö×Ö·û¡£Ò»¸öÈç £§data?.dat£§ µÄģʽ¿É ......
ÈçºÎÁîÄãµÄÍøÕ¾“¶¯¸ÐÊ®×ã”
ÄúµÄÍøÕ¾ÊÇ·ñÈÔÒ»Èç¼ÈÍùµØ±£³Ö“¾²Ì¬”£¿Ä¿Ç°³Ê¼¸ºÎÔö³¤µÄ»¥ÁªÍøÍøÕ¾ÖУ¬ÓÐÏ൱һ²¿·ÖÈÔ¹ÌÊØ“¾²Ì¬”£¬ÎÞÐÎÖÐÒÑ´ó´óÂäºóÓÚʱ´úµÄ²½·¥¡£Ëùν“¾²Ì¬”Ö¸µÄ¾ÍÊÇÍøÕ¾µÄÍøÒ³ÄÚÈÝ“¹Ì¶¨²»±ä”£¬µ±Óû§ä¯ÀÀÆ÷ͨ¹ý»¥ÁªÍøµÄHTTP£¨Hypertext Transpor ......
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 ......