The Ajax usage of jQuery is implemented in ASP using $. Ajax()

Time:2021-10-21
Copy codeThe code is as follows:
<%
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
%>

Copy codeThe code is as follows:
<html>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=gb2312″ />
< title > Untitled Document < / 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 method=”post” action=”ajaxtest.asp”>
<!–<input type=”hidden” name=”cmd” value=”loadteacher”>–>
<select name=”teachers”>
< option value = “please select” > < / option >
</select>
< input type = “button” name = “BTN1” value = “load teacher” >
<!–< Input type = “submit” value = “submit” > — >
</form>
</body>
</html>

Recommended Today

Swift advanced (XV) extension

The extension in swift is somewhat similar to the category in OC Extension can beenumeration、structural morphology、class、agreementAdd new features□ you can add methods, calculation attributes, subscripts, (convenient) initializers, nested types, protocols, etc What extensions can’t do:□ original functions cannot be overwritten□ you cannot add storage attributes or add attribute observers to existing attributes□ cannot add parent […]