首页 > 代码库 > ajax、Html、asp调用数据库
ajax、Html、asp调用数据库
一.前端页面:
<!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调用数据库
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。