Do Loop 系列是 VBScript 中處理「未知迴圈次數」的核心結構。本文詳細比較 Do While、Do Until、前置/後置條件判斷的差異,並提供資料庫讀取、選單生成、輸入驗證等實戰模式。
| 語法 | 條件檢查時機 | 至少執行一次 | 繼續條件 |
|---|---|---|---|
Do While cond : ... : Loop | 迴圈開始前 | 否 | cond = True |
Do Until cond : ... : Loop | 迴圈開始前 | 否 | cond = False |
Do : ... : Loop While cond | 迴圈結束後 | 是 | cond = True |
Do : ... : Loop Until cond | 迴圈結束後 | 是 | cond = False |
<%
' Do While 前置判斷
Dim i : i = 0
Do While i <= 10
Response.Write i & "
"
i = i + 1
Loop
' Do Until 前置判斷
i = 0
Do Until i > 10
Response.Write i & "
"
i = i + 1
Loop
' Do ... Loop While 後置判斷(至少跑一次)
i = 0
Do
Response.Write i & "
"
i = i + 1
Loop While i <= 10
%>
<%
Dim conn, rs, sql
Set conn = GetConnection()
sql = "SELECT ArticleID, Title, PubDate FROM Articles WHERE IsPub = 1 ORDER BY PubDate DESC"
Set rs = conn.Execute(sql)
' ✅ 標準模式:前置判斷 + MoveNext
Do While Not rs.EOF
Response.Write ""
Response.Write "" & rs("Title") & "
"
Response.Write ""
Response.Write " "
rs.MoveNext
Loop
rs.Close : Set rs = Nothing
%>
<%
' 模擬:提示使用者輸入有效 Email,直到輸入正確或取消
Dim email, isValid
isValid = False
Do
' 在 ASP 中通常透過表單 POST 回傳,這裡示範邏輯
email = Request.Form("email")
If email = "" Then
Response.Write "請輸入 Email"
ElseIf Not IsValidEmail(email) Then
Response.Write "Email 格式錯誤"
Else
isValid = True
End If
If Not isValid Then
' 顯示表單讓使用者重新輸入
ShowEmailForm()
Response.End ' 等待下一次請求
End If
Loop Until isValid
' 通過驗證,繼續處理
Response.Write "驗證通過:" & email
Function IsValidEmail(email)
' 簡易驗證
IsValidEmail = InStr(email, "@") > 0 And InStr(email, ".") > InStr(email, "@")
End Function
Sub ShowEmailForm()
Response.Write ""
End Sub
%>
<%
' 產生日期下拉選單:1-31 日
Response.Write ""
' 產生月份下拉選單
Dim months : months = Array("一月","二月","三月","四月","五月","六月","七月","八月","九月","十月","十一月","十二月")
Response.Write ""
' 產生年份下拉選單:1900-2025(Do Until 示範)
Response.Write ""
%>
<%
' 使用 Do Loop 分批處理大量記錄
Const BATCH_SIZE = 1000
Dim conn, rs, sql, lastId, batchCount
Set conn = GetConnection()
lastId = 0
batchCount = 0
Do
sql = "SELECT TOP " & BATCH_SIZE & " * FROM BigLogTable WHERE LogID > " & lastId & " ORDER BY LogID"
Set rs = conn.Execute(sql)
If rs.EOF Then Exit Do
batchCount = batchCount + 1
Response.Write "處理第 " & batchCount & " 批...
"
Do While Not rs.EOF
' 處理單筆記錄
ProcessLogRecord(rs)
lastId = rs("LogID")
rs.MoveNext
Loop
rs.Close : Set rs = Nothing
' 防止無限迴圈保護
If batchCount > 10000 Then Exit Do
Loop
Response.Write "共處理 " & batchCount & " 批次"
Sub ProcessLogRecord(rs)
' 實際處理邏輯:分析、統計、匯出等
End Sub
%>
<%
Dim i : i = 0
Do While i < 100
i = i + 1
If i = 50 Then
Response.Write "在第 50 次提前結束"
Exit Do
End If
Loop
' 迴圈結束後 i = 50
%>
While/Until 搞反)rs.MoveNext 導致無限讀取同一筆Loop Until rs.EOF 正確,Loop While rs.EOF 錯誤If counter > 10000 Then Exit Do : Response.Write "安全中斷"