%
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 irs.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;ilen ;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>