时间：2021-07-01 10:21:17 帮助过：40人阅读
- <br><% <br>response.Expires=-1 <br>response.CacheControl="no-cache" <br>%> <br><!--#include file="../../conn/conn.asp"--> <br><!--#include file="../psw.asp"--> <br><!--#include file="../../functions/dofunction.asp"--> <br><!--#include file="../../functions/showfunction.asp"--> <br><!--#include file="../../fqdb/admin/website.asp"--> <br><% <br>cmd = checkstr(request("cmd"),2) <br>if cmd="loadteacher" then <br>response.Charset = "gb2312" <br>set rs=server.CreateObject("adodb.recordset") <br>sql="select teacher_id,name from Edu_Person" <br>rs.open sql,conn,1,3 <br>response.write "{""data"":[" <br>i = 0 <br>do until rs.eof <br>i = i + 1 <br>response.write "{""Id"":"&rs("teacher_id")&",""Name"":"""&rs("name")&"""}" <br>if i<rs.recordcount then response.write "," <br>rs.movenext() <br>loop <br>response.write "]}" <br>response.End() <br>end if <br>%> <br> <br><span><u></u></span> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br><html> <br><head> <br><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> <br><title>无标题文档</title> <br><script type="text/javascript" src="../../js/common/jquery-1.8.0.min.js"></script> <br><script type="text/javascript"> <br>$(document).ready(function(){ <br>$("#btn1").click(function(){ <br>//alert("click"); <br>$.ajax({ <br>url:"ajaxtest.asp?cmd=loadteacher", <br>dataType:"json", <br>success:function(json){ <br>//var odata = $.parseJSON(json); <br>var data = json.data; <br>for(var i = 0,len = data.length;i<len ;i++){ <br>document.writeln(data[i].Name); <br>} <br>} <br>}); <br>}); <br>}); <br></script> <br></head> <br><body> <br><form id="myform" method="post" action="ajaxtest.asp"> <br><!--<input type="hidden" name="cmd" value="loadteacher">--> <br><select id="tearchers" name="teachers"> <br><option value="请选择"></option> <br></select> <br><input type="button" id="btn1" name="btn1" value="加载老师"> <br><!--<input type="submit" value="提交">--> <br></form> <br></body> <br></html> <br></li><li> </li><li> </li></ol></pre>