ajax、Html、asp调用数据库

一.前端页面：

    
    <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("pTest").innerHTML = "
" + msg + "
";
                }
            });
        }
    </script>


   

        

           
姓名：
     
           
年龄：
   
           
性别：
 
           
提交：
   
        
        

        

   

二.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;
            }
        }
    }

三.显示：

点击按钮之前：

点击按钮之后：

<喎?http://www.weiyer.com/Search.asp?KeyWord=/kf/ware/vc/" target="_blank" class="keylink">vcD4KPHA+PGltZyBzcmM9"/uploadfile/Collfiles/20140914/20140914092624107.png" alt="">