 
<% 
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 
%> 

復(fù)制代碼代碼如下:

 
<html> 
<head> 
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> 
<title>無標題文檔</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(){ 
//alert("click"); 
$.ajax({ 
url:"ajaxtest.asp?cmd=loadteacher", 
dataType:"json", 
success:function(json){ 
//var odata = $.parseJSON(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"> 
<!--<input type="hidden" name="cmd" value="loadteacher">--> 
<select id="tearchers" name="teachers"> 
<option value="請選擇"></option> 
</select> 
<input type="button" id="btn1" name="btn1" value="加載老師"> 
<!--<input type="submit" value="提交">--> 
</form> 
</body> 
</html> 