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£º·þÎñÆ÷¶ËÖ§³Ö´úÂë
ʹÓÃÔ¶³Ì½Å±¾µ÷Óù¦ÄÜʱ£¬¿Í»§¶ËºÍ·þÎñÆ÷¶Ë´úÂë¶¼±ØÐë·ûºÏÒ»¶¨µÄÒªÇó£ºÔÚ·þÎñÆ÷¶Ë£¬Ê×ÏȱØÐëÆ
Ïà¹ØÎĵµ£º
<Html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Éú³ÉWordÎĵµ</title>
</head>
<script ......
asp·ÀÖ¹ÍøÕ¾¹ÒÂíÕÒ°²´ï»¥Áª
Äú»¹ÔÚµ£ÐÄÍøÕ¾±»¹ÒÂí¡¢±»ºÚÂ𣿰²´ï»¥Áª(www. ......
Ò»¡¢Request ¶ÔÏó
¿ÉÒÔʹÓà Request ¶ÔÏó·ÃÎÊÈκλùÓÚ HTTP ÇëÇ󴫵ݵÄËùÓÐÐÅÏ¢£¬°üÀ¨´Ó HTML ±í¸ñÓà POST ·½·¨»ò GET ·½·¨´«µÝµÄ²ÎÊý¡¢cookie ºÍÓû§ÈÏÖ¤¡£
Request[.¼¯ºÏ|ÊôÐÔ|·½·¨](±äÁ¿)
1¡¢Form
Form ¼¯ºÏͨ¹ýʹÓà POST ·½·¨µÄ±í¸ñ¼ìË÷ÓÊË͵½ HTTP ÇëÇóÕýÎÄÖеıí¸ñÔªËØµÄÖµ¡£
Request.Form(element)[(i ......
aspÖвåÈëÓëÐÞ¸ÄÊý¾ÝµÄ¼¸ÖÖ·½Ê½¡£ÎªÁË·½±ã½â˵£¬ÎÒÃÇÏȽ¨Á¢Ò»¸öÃûΪtestµÄ±í£¬±íÄÚÖ»ÓÐÁ½¸öÊý¾Ý
Ïî:usernameºÍemail,·Ö±ðÓÃÀ´´æ´¢Óû§ÃûÓëÓÊÏ䵨ַ¡£
1.ÀûÓÃinsertÓï¾ä²åÈëÊý¾Ý£º
insertÊÇsqlÓï¾äµÄ»ù±¾Ö¸ÁîÖ®Ò»£¬ Ó÷¨ºÜ¼òµ¥£¬ÕâÀïÎÒÖ»½«Æä»ù±¾¸ñʽÁгö.
´úÂëÈçÏ£º
set conn=s ......
·Ï»°ÉÙ˵,¼û´úÂë
<%=request.ServerVariables("LOGON_USER")%>
Ê×ÏÈIISËùÔڵķþÎñÆ÷Òª¼ÓÈëÓò,Æä´ÎÊÇIIS·þÎñÆ÷µÄÉèÖÃ.¼ûͼ1
ͼ2
·þÎñÆ÷ÉèÖúúó, IISËùÔڵķþÎñÆ÷ʹÓÃ
<%=request.ServerVariables("LOGON_USER")%>
¾ÍÄÜ»ñÈ¡µ½ÓòÃû³ÆºÍÓû§ÃûÁË.
Èç¹û·ÃÎÊÕßûÓмÓÈëÓò,»áÌáʾµÇ¼,ÈçÏÂͼ.Ê ......