ajax、Html、asp调用数据库

当前位置 : 首页 > 网页制作 > CSS > ajax、Html、asp调用数据库

ajax、Html、asp调用数据库

来源: 作者: 时间:2016-01-23 10:51
一 前端页面: test function buttonClick() { var name = document getElementById( name ) value;

一.前端页面:




    test
    <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 = "

" + 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.2cto.com/kf/ware/vc/" target="_blank" class="keylink">vcD4KPHA+PGltZyBzcmM9"http://www.2cto.com/uploadfile/Collfiles/20140914/20140914092624107.png" alt="">


Tag:
网友评论

<