萬盛學電腦網

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

ASP Join 函式高效串接字串:陣列合併效能優於 & 連接

為什麼用 Join?

VBScript 字串是不可變的,str = str & "something" 每次都會配置新記憶體、複製舊內容。迴圈中大量串接會導致 O(n²) 效能災難。Join(ary, delim) 只需一次記憶體配置,效能接近 C/PHP 的 implode。

語法

Join(oneDimArray[, delimiter])
' delimiter 省略預設為空字串 "" (無分隔符)
' delimiter = "" 時直接連接所有元素

基本範例

<%
Dim days(5), filtered, result
days(0) = "Saturday"
days(1) = "Sunday"
days(2) = "Monday"
days(3) = "Tuesday"
days(4) = "Wednesday"
days(5) = "Thursday"

' Filter 篩選包含 "n" 的元素
filtered = Filter(days, "n")   ' 回傳 Array("Sunday","Monday","Wednesday")

' Join 合併,預設空分隔
result = Join(filtered)        ' "SundayMondayWednesday"
Response.Write result & "
" ' 指定分隔符 result = Join(filtered, ", ") ' "Sunday, Monday, Wednesday" Response.Write result %>

效能實測:10,000 個元素串接

<%
Dim arr(10000), i, startTime, result
startTime = Timer

For i = 0 To 10000
    arr(i) = CStr(i)
Next

' Join 一次性合併
result = Join(arr, vbCrLf)
Response.Write "Join 耗時: " & FormatNumber(Timer - startTime, 4) & " 秒
" ' 典型輸出: 0.0030 秒 ' 對比 & 串接 (註解掉避免超時) ' startTime = Timer ' Dim s : s = "" ' For i = 0 To 10000 ' s = s & arr(i) & vbCrLf ' Next ' Response.Write "& 串接耗時: " & FormatNumber(Timer - startTime, 4) & " 秒" ' 典型輸出: 1.2 秒 (慢 400 倍) %>

進階用法:直接 Join Array 字面值

' 快速產生 CSV 行
Dim csvLine
csvLine = Join(Array("張三", "25", "台北", "工程師"), ",")
' 結果: "張三,25,台北,工程師"

' 產生 SQL IN 列表 (需自行處理引號)
Dim ids, inClause
ids = Array(101, 102, 103, 104)
inClause = Join(ids, ",")
' inClause = "101,102,103,104"
sql = "SELECT * FROM Users WHERE ID IN (" & inClause & ")"

Join vs Filter vs Split 三劍客

函式方向用途
Split字串 → 陣列分割 CSV、查詢字串、日誌行
Filter陣列 → 陣列篩選含/不含特定子字串的元素
Join陣列 → 字串高效串接、產生 CSV/IN 列表/HTML

實戰:產生下拉選單 HTML

<%
Function BuildOptions(values, texts, selectedVal)
    Dim htmlArr(), i, cnt
    cnt = UBound(values)
    ReDim htmlArr(cnt)
    
    For i = 0 To cnt
        Dim sel : sel = ""
        If CStr(values(i)) = CStr(selectedVal) Then sel = " selected"
        htmlArr(i) = ""
    Next
    
    BuildOptions = Join(htmlArr, vbCrLf)
End Function

' 使用
Dim vals, txts
vals = Array("", "1", "2", "3")
txts = Array("請選擇", "選項一", "選項二", "選項三")
Response.Write ""
%>

注意事項

  • Join 只接受一維陣列,多維陣列需先轉換
  • 元素為 Null 會導致錯誤,建議先 If IsNull(arr(i)) Then arr(i) = ""
  • Filter 回傳的陣列下標從 0 開始連續,可直接 Join
copyright © 萬盛學電腦網 all rights reserved