<%
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
%>
<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>
本文地址:https://www.stayed.cn/item/21026
转载请注明出处。
本站部分内容来源于网络,如侵犯到您的权益,请 联系我