陣列是 ASP 處理資料集合的基礎結構。本文詳細說明靜態/動態陣列宣告差異、多維陣列操作、ReDim Preserve 陷阱、效能優化技巧與現代集合類別替代方案。
<%
' 宣告指定上界(下界固定為 0)
Dim arrCars(4) ' 5 個元素:索引 0-4
arrCars(0) = "BMW"
arrCars(1) = "Mercedes"
arrCars(2) = "Audi"
arrCars(3) = "Bentley"
arrCars(4) = "Mini"
' 替代宣告:Array 函數自動建立並填入
Dim arrCars2
arrCars2 = Array("BMW", "Mercedes", "Audi", "Bentley", "Mini")
' 遍歷
For i = 0 To UBound(arrCars)
Response.Write arrCars(i) & "
"
Next
%>
<%
' 宣告:不指定大小
Dim arrDynamic
arrDynamic = Array() ' 初始為空陣列
' 第一次設定大小
ReDim arrDynamic(27) ' 28 個元素
' 後續調整:⚠️ 不加 Preserve 會清空資料!
ReDim arrDynamic(50) ' 資料遺失!
' ✅ 正確:保留現有資料擴充
ReDim Preserve arrDynamic(52) ' 保留前 28 個,擴充至 53 個
' 縮減陣列
ReDim Preserve arrDynamic(10) ' 保留前 11 個
%>
<%
' 二維陣列:3 列 4 行
Dim matrix(2, 3)
matrix(0, 0) = "A1" : matrix(0, 1) = "A2" : matrix(0, 2) = "A3" : matrix(0, 3) = "A4"
matrix(1, 0) = "B1" : matrix(1, 1) = "B2" : matrix(1, 2) = "B3" : matrix(1, 3) = "B4"
matrix(2, 0) = "C1" : matrix(2, 1) = "C2" : matrix(2, 2) = "C3" : matrix(2, 3) = "C4"
' 遍歷二維陣列
Dim row, col
For row = 0 To UBound(matrix, 1) ' 第一維上界
For col = 0 To UBound(matrix, 2) ' 第二維上界
Response.Write matrix(row, col) & " "
Next
Response.Write "
"
Next
' 三維陣列(罕見但支援)
Dim cube(2, 3, 4) ' 3x4x5
%>
<%
Dim arr(2, 3) ' 3x4
' ReDim Preserve arr(3, 3) ' ❌ 錯誤:嘗試修改第一維
ReDim Preserve arr(2, 5) ' ✅ 正確:修改最後一維(第二維)為 6
' 解決方案:轉置陣列或使用 Scripting.Dictionary
%>
<%
Dim arr : arr = Array("C", "A", "B", "E", "D")
' UBound / LBound:取得邊界
Response.Write "上界:" & UBound(arr) & ",下界:" & LBound(arr) & "
"
' Join:陣列轉字串
Response.Write "Join: " & Join(arr, "|") & "
"
' Split:字串轉陣列
Dim str : str = "A|B|C"
Dim arr2 : arr2 = Split(str, "|")
' Filter:篩選包含/不包含子字串的元素
Dim filtered : filtered = Filter(arr, "A", True, 1) ' 包含 "A",文字比較
' 結果:Array("A")
' IsArray:檢查是否為陣列
Response.Write "IsArray:" & IsArray(arr) & "
"
' Erase:清空陣列(釋放動態陣列記憶體,靜態陣列重置為空值)
Erase arr
%>
| 操作 | 問題 | 優化方案 |
|---|---|---|
| 迴圈中 ReDim Preserve | 每次重新配置記憶體、複製資料,O(N²) | 預估大小一次配足、或用 Dictionary/List |
| 迴圈中字串串接 | 字串不可變,每次建立新字串 | 用陣列收集,最後 Join |
| 大陣列傳遞給函數 | 預設 ByRef 傳址,但複製陣列內容昂貴 | 傳遞陣列參考、或用全域/模組層級變數 |
| 多維陣列記憶體不連續 | VBScript 多維陣列為陣列的陣列,存取較慢 | 攤平為一維陣列:index = row * cols + col |
<%
' Dictionary:鍵值對、動態增減、O(1) 查找、可列舉 Keys/Items
Dim dict : Set dict = Server.CreateObject("Scripting.Dictionary")
dict.CompareMode = 1 ' vbTextCompare
dict.Add "user1", "John"
dict.Add "user2", "Jane"
dict("user3") = "Bob" ' 直接賦值(自動新增/更新)
' 檢查鍵存在
If dict.Exists("user1") Then Response.Write "存在
"
' 移除
dict.Remove "user2"
' 遍歷
For Each key In dict.Keys
Response.Write key & " = " & dict(key) & "
"
Next
' 轉陣列
Dim keysArr, itemsArr
keysArr = dict.Keys ' 回傳一維陣列
itemsArr = dict.Items
%>
<%
Function RecordsetToArray(rs)
' 將 Recordset 轉為二維陣列:GetRows 最高效
If rs.EOF Then
RecordsetToArray = Array()
Exit Function
End If
' GetRows 回傳:二維陣列 (欄位, 列)
Dim data : data = rs.GetRows()
' 轉置為 (列, 欄位) 符合直覺
Dim rows, cols, i, j, result
rows = UBound(data, 2) + 1
cols = UBound(data, 1) + 1
ReDim result(rows - 1, cols - 1)
For i = 0 To rows - 1
For j = 0 To cols - 1
result(i, j) = data(j, i)
Next
Next
RecordsetToArray = result
End Function
' 使用
Dim rs, arr
Set rs = conn.Execute("SELECT * FROM Products")
arr = RecordsetToArray(rs)
rs.Close
' 現在可用 arr(row, col) 存取
Response.Write "第一筆產品:" & arr(0, 1) ' 假設第 1 欄是名稱
%>