jQuery 的 $.ajax() 並不挑後端語言,只要對方會回傳正確格式的資料即可。本文示範如何在經典 ASP 上,用 $.ajax() 載入教師清單並填進下拉選單。
關鍵是關閉快取、指定 gb2312 編碼,並手工把 Recordset 拼成 JSON 字串。這裡用 cmd 參數做簡單的動作分派,方便日後擴充。
<%
response.Expires = -1
response.CacheControl = "no-cache"
%>
<!--#include file="../../conn/conn.asp"-->
<!--#include file="../psw.asp"-->
<!--#include file="../../functions/dofunction.asp"-->
<!--#include file="../../functions/showfunction.asp"-->
<!--#include file="../../fqdb/admin/website.asp"-->
<%
cmd = checkstr(request("cmd"), 2)
if cmd = "loadteacher" then
response.Charset = "gb2312"
set rs = server.CreateObject("adodb.recordset")
sql = "select teacher_id, name from Edu_Person"
rs.open sql, conn, 1, 3
response.write "{""data"":["
i = 0
do until rs.eof
i = i + 1
response.write "{""Id"":" & rs("teacher_id") & ",""Name"":"""& rs("name") & """}"
if i < rs.recordcount then response.write ","
rs.movenext()
loop
response.write "]}"
response.End()
end if
%>
注意 dataType 設為 json 之後,jQuery 會自動幫我們反序列化,success 收到的 json 已經是物件,不需要再呼叫 $.parseJSON()。
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>ASP + jQuery Ajax 範例</title>
<script type="text/javascript" src="../../js/common/jquery-1.8.0.min.js"></script>
<script type="text/javascript">
$(document).ready(function () {
$("#btn1").click(function () {
$.ajax({
url: "ajaxtest.asp?cmd=loadteacher",
dataType: "json",
success: function (json) {
var data = json.data;
for (var i = 0, len = data.length; i < len; i++) {
document.writeln(data[i].Name);
}
}
});
});
});
</script>
</head>
<body>
<form id="myform" method="post" action="ajaxtest.asp">
<select id="tearchers" name="teachers">
<option value="請選擇"></option>
</select>
<input type="button" id="btn1" name="btn1" value="加載老師" />
</form>
</body>
</html>
後端字串拼接 JSON 時,若欄位內容可能出現雙引號或換行,務必先 escape,否則前端會解析失敗。另外 response.Charset