ajax、Html、asp調用資料庫

來源:互聯網
上載者:User

標籤:ajax

一.前端頁面:

<!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個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.