首页 > 代码库 > 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调用数据库