萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 網路程式設計 >> ASP 程式設計

17 個 ASP 經典程式設計核心範例:從入門到實戰

基礎輸入輸出

1. GET / POST 取值

' GET: Request.QueryString("field")
' POST: Request.Form("field")
' 通用: Request("field") (優先 Form > QueryString > ServerVariables > Cookies)

2. Request.Form 進階用法

' 同名多值
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

3. 伺服器變數:Client IP、Port、Language

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")

4. 日期時間顯示

<%= Now() %>           ' 完整日期時間
<%= FormatDateTime(Now, 2) %> ' 短日期格式
<%= FormatDateTime(Now, 3) %> ' 長時間格式

5. 註冊自訂 DLL (COM)

' 命令列 (管理員)
regsvr32 MyComponent.dll
' ASP 中使用
Set obj = Server.CreateObject("MyComponent.ClassName")

流程控制與字串處理

6. 迴圈輸出漸變字體

<% For i = 1 To 5 %>
  <font size="<%=i%>" color="#00ffff">快速 ASP</font><br>
<% Next %>

7. 輸出與導向

Response.Write "Hello"           ' 輸出字串
Response.Redirect "home.asp"     ' 302 導向 (注意: 已有輸出會報錯)

8. 伺服端條件邏輯輸出

<%
If TimeValue(Now) > #12:00:00 PM# And TimeValue(Now) < #12:00:00 AM# Then
    greeting = "午安!"
Else
    greeting = "早安/晚安!"
End If
%>
<%=greeting%>

9. <script runat=server> 區塊

<script runat="server" language="VBScript">
Sub ShowMsg()
    Response.Write "Hello from script block!"
End Sub
</script>
<% Call ShowMsg() %>

10. #include 檔案包含

<!--#include virtual="/common/header.asp"-->  ' 虛擬路徑 (站台根目錄)
<!--#include file="../inc/config.asp"-->      ' 相對實體路徑
' 可巢狀包含,但不可在 <%-- --> 註解區塊內

11. 頁面快取控制

Response.Expires = 30          ' 30 分鐘快取
Response.ExpiresAbsolute = #2024-12-31 23:59:59# ' 絕對過期

12. Session 追蹤首次造訪

If Session("Visited") = "" Then
    Response.Write "歡迎首次造訪!"
    Session("Visited") = True
Else
    Response.Write "歡迎回來!"
End If

資料庫操作 (ADO)

13. 連接字串兩種寫法

' 方式一: 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")

14. 標準 CRUD 範本

' 查詢全部
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

15. Recordset 迴圈顯示 (帶連結)

For n = 1 To 6
    If rs.EOF Then Exit For
    Response.Write "" & rs("Title") & "
" rs.MoveNext Next

16. 圖片/超連結儲存與顯示

<%
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>

安全與除錯

17. SQL 注入防護:單引號跳脫

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 專案開發維護的核心技能。

copyright © 萬盛學電腦網 all rights reserved