' GET: Request.QueryString("field")
' POST: Request.Form("field")
' 通用: Request("field") (優先 Form > QueryString > ServerVariables > Cookies)
' 同名多值
For i = 1 To Request.Form("chkItems").Count
val = Request.Form("chkItems")(i)
Next
' 遍歷所有欄位
For Each key In Request.Form
Response.Write key & " = " & Request.Form(key) & "
"
Next
Dim ip, port, lang
ip = Request.ServerVariables("REMOTE_ADDR")
port = Request.ServerVariables("SERVER_PORT")
lang = Request.ServerVariables("HTTP_ACCEPT_LANGUAGE")
' 依語言導向
If InStr(lang, "zh") > 0 Then Response.Redirect("zh.asp") Else Response.Redirect("en.asp")
<%= Now() %> ' 完整日期時間
<%= FormatDateTime(Now, 2) %> ' 短日期格式
<%= FormatDateTime(Now, 3) %> ' 長時間格式
' 命令列 (管理員)
regsvr32 MyComponent.dll
' ASP 中使用
Set obj = Server.CreateObject("MyComponent.ClassName")
<% For i = 1 To 5 %>
<font size="<%=i%>" color="#00ffff">快速 ASP</font><br>
<% Next %>
Response.Write "Hello" ' 輸出字串
Response.Redirect "home.asp" ' 302 導向 (注意: 已有輸出會報錯)
<%
If TimeValue(Now) > #12:00:00 PM# And TimeValue(Now) < #12:00:00 AM# Then
greeting = "午安!"
Else
greeting = "早安/晚安!"
End If
%>
<%=greeting%>
<script runat="server" language="VBScript">
Sub ShowMsg()
Response.Write "Hello from script block!"
End Sub
</script>
<% Call ShowMsg() %>
<!--#include virtual="/common/header.asp"--> ' 虛擬路徑 (站台根目錄)
<!--#include file="../inc/config.asp"--> ' 相對實體路徑
' 可巢狀包含,但不可在 <%-- --> 註解區塊內
Response.Expires = 30 ' 30 分鐘快取
Response.ExpiresAbsolute = #2024-12-31 23:59:59# ' 絕對過期
If Session("Visited") = "" Then
Response.Write "歡迎首次造訪!"
Session("Visited") = True
Else
Response.Write "歡迎回來!"
End If
' 方式一: Jet OLEDB (Access)
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("db.mdb")
' 方式二: ODBC (舊版驅動)
conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("db.mdb")
' 查詢全部
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "SELECT * FROM News", conn, 1, 3 ' adOpenKeyset, adLockOptimistic
' 查詢前 6 筆 (Access/SQL Server)
rs.Open "SELECT TOP 6 * FROM News ORDER BY Id DESC", conn, 1, 1
' 參數化查詢 (防注入)
cmd.CommandText = "SELECT * FROM News WHERE Id = ?"
cmd.Parameters.Append cmd.CreateParameter("@id", 3, 1, , Request("id"))
Set rs = cmd.Execute
' 新增
sql = "INSERT INTO Members (Name,Pwd,Q,A) VALUES ('" & Replace(a,"'","''") & "','" & Replace(b,"'","''") & "','" & c & "','" & d & "')"
conn.Execute sql
' 修改
sql = "UPDATE Members SET Name='" & Replace(d,"'","''") & "', Pwd='" & Replace(e,"'","''") & "' WHERE Id=" & a
conn.Execute sql
' 刪除
sql = "DELETE FROM Members WHERE Id=" & Request("delid")
conn.Execute sql
For n = 1 To 6
If rs.EOF Then Exit For
Response.Write "" & rs("Title") & "
"
rs.MoveNext
Next
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "myDSN"
Set rs = conn.Execute("SELECT Name, Tel, Url, Image FROM Contacts")
%>
<table>
<% For i = 0 To rs.Fields.Count - 1 %>
<td><b><%=rs(i).Name%></b></td>
<% Next %>
</tr>
<% Do While Not rs.EOF %>
<tr>
<td><%=rs("Name")%></td>
<td><%=rs("Tel")%></td>
<td><a href="<%=rs("Url")%>">連結</a></td>
<td><img src="<%=rs("Image")%>" width="100"></td>
</tr>
<% rs.MoveNext Loop %>
</table>
Function SafeSQL(str)
SafeSQL = Replace(str, "'", "''")
End Function
' 使用
sql = "SELECT * FROM Users WHERE Name='" & SafeSQL(Request("name")) & "'"
這 17 個範例涵蓋 ASP 核心能力:HTTP 請求處理、伺服器變數、流程控制、字串/日期操作、COM 元件、檔案包含、快取、Session、ADO 資料庫完整 CRUD、Recordset 遍歷、二進位資料顯示、SQL 注入防護。熟練掌握並理解背後原理 (如連接池、游標類型、鎖定類型、緩衝機制),即具備經典 ASP 專案開發維護的核心技能。