不要死背語法,而要記憶 **「功能模組」**。需要什麼功能,直接拼裝對應模組。所有符號務必使用**半形英文字元**。
' 1. ASP 標記
<% 程式碼 %>
' 2. 取得表單值 (POST)
val = Request.Form("fieldName")
' 3. 取得查詢字串值 (GET)
val = Request.QueryString("paramName")
' 4. 通用取值 (Form > QueryString > Cookies > ServerVariables)
val = Request("name")
' 5. 變數宣告與輸出
Dim str : str = "我愛你"
Response.Write str
Response.Write "除錯訊息:程式執行到這裡"
' 6. SQL 除錯輸出
sql = "SELECT * FROM News"
Response.Write sql ' 確認 SQL 語法
' 7. 頁面導向
Response.Redirect "login.asp"
' 8. 結束輸出
Response.End
' 9. JavaScript 警示彈窗
Response.Write ""
' 1. 單一條件
If Request("username") = "admin" Then
Response.Write "登入成功"
Else
Response.Write "帳號錯誤"
End If
' 2. 多重條件 (登入驗證)
If Request("name") = "admin" And Request("pass") = "admin" Then
Response.Redirect "admin.asp"
Else
Response.Redirect "login.asp"
End If
' 3. 字串串接
a = "我" : b = "愛" : c = "你"
Response.Write a & b & c & "媽媽" ' 輸出: 我愛你媽媽
' 1. Do While 迴圈 (標準 Recordset 遍歷)
Do While Not rs.EOF
Response.Write "
" & rs("title") & "
"
rs.MoveNext
Loop
' 2. For 迴圈固定筆數 (含 EOF 保護)
For n = 1 To 6
Response.Write rs("title") & "
"
If rs.EOF Then Exit For
rs.MoveNext
Next
| 功能 | 函式/語法 | 範例 |
|---|---|---|
| 目前日期時間 | Now() | <%=Now()%> |
| 目前日期 | Date() | <%=Date()%> |
| 數值→字串 | CStr(int) | CStr(123) → "123" |
| 字串→整數 | CInt(str) | CInt("123") → 123 |
| 去除首尾空白 | Trim(str) | Trim(" a ") → "a" |
| 左擷 N 字 | Left(str, N) | Left("標題文字", 10) & "..." |
| 字串長度 | Len(str) | 中文算 1 字元 |
| 取得 Client IP | Request.ServerVariables("REMOTE_ADDR") | |
| 擷取中段 | Mid(str, start[, len]) | Mid("abcdef", 2, 3) → "bcd" |
| 右擷 N 字 | Right(str, N) | Right("abcdef", 3) → "def" |
| 轉小寫 | LCase(str) | |
| 轉大寫 | UCase(str) | |
| 去左空白 | LTrim(str) | |
| 去右空白 | RTrim(str) | |
| 取代字串 | Replace(str, find, repl, [start, count, compare]) | Replace("a b c", " ", "-") → "a-b-c" |
| 搜尋位置 | InStr([start,] str, find, [compare]) | InStr("abc", "b") → 2 |
' 方法一: Jet OLEDB 4.0 (標準)
db = "data.mdb" ' 若在子目錄: "db/data.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
' 方法二: ODBC 驅動 (舊版相容)
conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath(db)
' 通用 Recordset 開啟
Set Rs = Server.CreateObject("ADODB.Recordset")
SqlStr = "SELECT * FROM News"
Rs.Open SqlStr, conn, 1, 1 ' adOpenKeyset, adLockOptimistic
' 取前 6 筆
SqlStr = "SELECT TOP 6 * FROM News"
Rs.Open SqlStr, conn, 1, 1
' 依 ID 查詢單筆 (參數化防注入)
SqlStr = "SELECT * FROM News WHERE Id = ?"
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = conn
cmd.CommandText = SqlStr
cmd.Parameters.Append cmd.CreateParameter("@id", 3, 1, , Request("id")) ' adInteger
Set Rs = cmd.Execute
' 新增 (單引號跳脫)
Dim a,b,c,d
a = Request.Form("a"): b = Request("b"): c = Request("c"): d = Request("d")
sql = "INSERT INTO Members (UserName,Pwd,Q,A) VALUES ('" & Replace(a,"'","''") & "','" & Replace(b,"'","''") & "','" & c & "','" & d & "')"
conn.Execute sql
Response.Write "新增成功"
' 修改
Dim id, newName, newPwd
id = Request("id"): newName = Request.Form("d"): newPwd = Request.Form("e")
sql = "UPDATE Members SET UserName='" & Replace(newName,"'","''") & "', Pwd='" & Replace(newPwd,"'","''") & "' WHERE Id=" & id
conn.Execute sql
Response.Write "修改成功"
' 刪除
Dim delId: delId = Request("delid")
sql = "DELETE FROM Members WHERE Id=" & delId
conn.Execute sql
Response.Write "刪除成功"
' 1. 取得所有資料 (預設排序)
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.Open "SELECT * FROM News", conn, 1, 1
' 2. 取得前 6 筆
Rs.Open "SELECT TOP 6 * FROM News", conn, 1, 1
' 3. 列表顯示 6 筆 (不帶連結)
For n = 1 To 6
Response.Write rs("title") & "
"
If rs.EOF Then Exit For
rs.MoveNext
Next
' 4. 列表顯示 6 筆 (帶連結)
For n = 1 To 6
Response.Write "" & rs("title") & "
"
If rs.EOF Then Exit For
rs.MoveNext
Next
將上述 8 大模組內化為肌肉記憶,開發 ASP 專案時即可「搭積木」式快速組裝功能。進階階段再學習:錯誤處理 (`On Error Resume Next`)、交易處理 (`BeginTrans`/`CommitTrans`)、元件開發 (VB6/VC++ DLL)、效能調校 (連接池、快取、分頁)、安全強化 (XSS/CSRF/上傳防護)。