萬盛學電腦網

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

ASP Do While / Do Until 迴圈:條件控制、至少執行一次與實戰模式

VBScript Do Loop 迴圈完全掌握:前測試、後測試與實戰應用

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 "
" Response.Write "Email: " Response.Write "" 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 %>

Exit Do 提前跳出

<%
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 "安全中斷"
copyright © 萬盛學電腦網 all rights reserved