在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
复制代码 代码如下: <% 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> |
请发表评论