一.前端页面:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>test</title>
<script src="js/jquery-1.7.2.min.js" type="text/javascript"></script>
<script type="text/javascript">
function buttonClick() {
var name = document.getElementById("name").value;
var age = document.getElementById("age").value;
var sex = document.getElementById("sex").value;
alert("姓名" + name + "年龄" + age +"性别:"+sex);
$.ajax({
type: "POST",
url: "Test.ashx?method=getLzr",
data: { name: name, age: age, sex: sex },
success: function (msg) {
document.getElementById("divTest").innerHTML = "<p style='color:red'>" + msg + "</p>";
}
});
}
</script>
</head>
<body>
<div>
<table>
<tr><td><p>姓名:</p></td><td><input type="text" id="name" /></td></tr>
<tr><td><p>年龄:</p></td><td><input type="text" id="age" /></td></tr>
<tr><td><p>性别:</p></td><td><input type="text" id="sex" /></td></tr>
<tr><td>提交:<input type="button" value="添加" onclick="buttonClick()" /></td></tr>
</table>
<br />
<div id="divTest"></div>
</div>
</body>
</html>
二.ashx代码:
public class Handler1 : IHttpHandler, IRequiresSessionState
{
HttpRequest Request;
HttpResponse Response;
public void ProcessRequest(HttpContext context)
{
Request = context.Request;
Response = context.Response;
string method = Request["Method"].ToString();//对应ajax方法的url参数
MethodInfo methodInfo = this.GetType().GetMethod(method);//
methodInfo.Invoke(this, null);
}
public void getLzr() {
string name = Request["name"].ToString();
string age = Request["age"].ToString();
string sex = Request["sex"].ToString();
int i = SqlHelper.ExecuteNonQuery("Insert into lzr_name(name,age,sex) values(@name,@age,@sex)", new SqlParameter("@name",name), new SqlParameter("@age", age), new SqlParameter("@sex", sex));
if (i > 0)
{
//返回的数据
Response.Write("T");
}
else
{
Response.Write("F");
}
}
public bool IsReusable
{
get
{
return false;
}
}
}
三.显示:
点击按钮之前:
点击按钮之后:
ajax、Html、asp调用数据库