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£º·þÎñÆ÷¶ËÖ§³Ö´úÂë
ʹÓÃÔ¶³Ì½Å±¾µ÷Óù¦ÄÜʱ£¬¿Í»§¶ËºÍ·þÎñÆ÷¶Ë´úÂ붼±ØÐë·ûºÏÒ»¶¨µÄÒªÇó£ºÔÚ·þÎñÆ÷¶Ë£¬Ê×ÏȱØÐëÆ
Ïà¹ØÎĵµ£º
1. ÓÃDSNÁ¬½Ó²¢ÇÒûÓÐÓû§ÃûºÍÃÜÂ룺
<%
set conn = Server.CreateObject("ADODB.Connection")
conn.open "YourDSNName"
%>
ÓÃDSNÁ¬½Ó²¢ÇÒÓÐÓû§ÃûºÍÃÜÂ룺
<%
set conn = Server.CreateObject("ADODB.Connection")
conn.open "YourDSNName","username","password"
%>
2. ÓÃʵ¼ÊµÄÊý¾Ý¿â¾ø¶Ô·¾¶Á¬½Ó ......
Õâ¸öÄ£°åÒýÇæ±È½Ï·½±ã,¸úHTML½áºÏÁË
Class template
Private c_Char, c_Path, c_FileName, c_Content, c_PageUrl, c_CurrentPage, c_PageStr, ReplacePageStr
Private TagName
' ***************************************
' ÉèÖñàÂë
' ***************************************
Public Property Let Char( ......
ÈçºÎÁîÄãµÄÍøÕ¾“¶¯¸ÐÊ®×ã”
ÄúµÄÍøÕ¾ÊÇ·ñÈÔÒ»Èç¼ÈÍùµØ±£³Ö“¾²Ì¬”£¿Ä¿Ç°³Ê¼¸ºÎÔö³¤µÄ»¥ÁªÍøÍøÕ¾ÖУ¬ÓÐÏ൱һ²¿·ÖÈÔ¹ÌÊØ“¾²Ì¬”£¬ÎÞÐÎÖÐÒÑ´ó´óÂäºóÓÚʱ´úµÄ²½·¥¡£Ëùν“¾²Ì¬”Ö¸µÄ¾ÍÊÇÍøÕ¾µÄÍøÒ³ÄÚÈÝ“¹Ì¶¨²»±ä”£¬µ±Óû§ä¯ÀÀÆ÷ͨ¹ý»¥ÁªÍøµÄHTTP£¨Hypertext Transpor ......
ÓÐ2ÖÖʹÓÃcookieµÄ»ù±¾·½Ê½£º
1¡¢½«cookieдÈë·ÃÎÊÕߵļÆËã»ú£¨Ê¹Óà RESPONSE ÃüÁ
2¡¢´Ó·ÃÎÊÕߵļÆËã»úÖÐÈ¡»Øcookie£¨Ê¹Óà REQUEST ÃüÁ
´´½¨cookieµÄ»ù±¾Óï·¨
Response.Cookies("CookieName")=value //½«ÖµvalueдÈëcookie
Ö´ÐÐÏÂÃæµÄ´úÂ뽫»áÔÚ·ÃÎÊÕߵļÆËã»úÖд´½¨Ò»¸öcookie£¬Ãû×Ö£½VisitorNam ......
·Ï»°ÉÙ˵,¼û´úÂë
<%=request.ServerVariables("LOGON_USER")%>
Ê×ÏÈIISËùÔڵķþÎñÆ÷Òª¼ÓÈëÓò,Æä´ÎÊÇIIS·þÎñÆ÷µÄÉèÖÃ.¼ûͼ1
ͼ2
·þÎñÆ÷ÉèÖúúó, IISËùÔڵķþÎñÆ÷ʹÓÃ
<%=request.ServerVariables("LOGON_USER")%>
¾ÍÄÜ»ñÈ¡µ½ÓòÃû³ÆºÍÓû§ÃûÁË.
Èç¹û·ÃÎÊÕßûÓмÓÈëÓò,»áÌáʾµÇ¼,ÈçÏÂͼ.Ê ......