Classic ASP 內建無 JSON 解析器。利用 <script language="JScript" runat="server"> 區塊,借助 JavaScript 原生 eval() 解析 JSON,再轉為 VBScript 可用的 Scripting.Dictionary,是最輕量、無元件的方案。
<script language="JScript" runat="server">
// 將 JSON 字串安全解析為 JS 物件
function parseJSON(jsonStr) {
return eval('(' + jsonStr + ')');
}
// 將 JS 物件/陣列轉為 VBScript Dictionary
function jsObjToDict(jsObj) {
var dict = Server.CreateObject("Scripting.Dictionary");
var enum = new Enumerator(jsObj); // 僅適用陣列/集合
// 通用遞迴轉換
return convertAny(jsObj);
}
function convertAny(val) {
if (val === null || val === undefined) return null;
switch (typeof val) {
case "string": case "number": case "boolean": return val;
case "object":
if (val instanceof Array) {
var arrDict = Server.CreateObject("Scripting.Dictionary");
for (var i = 0; i < val.length; i++) {
arrDict.Add(i, convertAny(val[i]));
}
return arrDict;
} else {
var objDict = Server.CreateObject("Scripting.Dictionary");
for (var key in val) {
if (val.hasOwnProperty(key)) objDict.Add(key, convertAny(val[key]));
}
return objDict;
}
}
}
</script>
<%
' VBScript 輔助函式
Function BytesToBstr(body, charset)
Dim stream: Set stream = Server.CreateObject("ADODB.Stream")
stream.Type = 1: stream.Mode = 3: stream.Open
stream.Write body
stream.Position = 0
stream.Type = 2: stream.Charset = charset
BytesToBstr = stream.ReadText
stream.Close: Set stream = Nothing
End Function
Function HttpGet(url)
Dim xhr: Set xhr = Server.CreateObject("MSXML2.XMLHTTP.3.0")
xhr.Open "GET", url, False
xhr.Send
If xhr.Status = 200 Then
HttpGet = BytesToBstr(xhr.ResponseBody, "UTF-8") ' 依實際編碼調整
Else
Err.Raise vbObjectError + 1001, "HttpGet", "HTTP " & xhr.Status
End If
End Function
' 統一介面:取得遠端 JSON 並轉為 VBScript Dictionary
Function GetRemoteJsonAsDict(url)
Dim jsonStr, jsDict
jsonStr = HttpGet(url)
Set jsDict = parseJSON(jsonStr) ' 呼叫 JScript 函式
Set GetRemoteJsonAsDict = jsObjToDict(jsDict)
End Function
%>
<!--#include file="json_utils.asp"-->
<%
Dim apiUrl, data, item, i
apiUrl = "https://api.example.com/areas?parent=710000"
On Error Resume Next
Set data = GetRemoteJsonAsDict(apiUrl)
If Err.Number = 0 Then
' 假設回傳結構: {resultcode:200, result:[{id:1, province:"陝西省", city:"西安市", area:"灞橋區", address:"狄寨鎮南寨村"}, ...]}
If data.Exists("resultcode") And data("resultcode") = 200 Then
Dim resultArr: Set resultArr = data("result") ' 這是 Dictionary (索引->物件)
For i = 0 To resultArr.Count - 1
Set item = resultArr(i)
Response.Write "ID: " & item("id") & ", 省: " & item("province") & ", 市: " & item("city") & ", 區: " & item("area") & ", 地址: " & item("address") & "
"
Next
Else
Response.Write "API 回傳錯誤: " & data("reason")
End If
Else
Response.Write "請求失敗: " & Err.Description
End If
On Error GoTo 0
%>
MSXML2.XMLHTTP.3.0 或 MSXML2.ServerXMLHTTP.6.0 (支援 HTTPS、憑證驗證設定)。BytesToBstr 的 charset 參數必須與 API 回應 Content-Type 一致 (通常 UTF-8)。若專案允許註冊 COM 元件,可使用 ASPJSON (純 ASP 類別) 或 Chilkat JSON (商業元件),純 VBScript 環境下效能與易用性更佳。