使用JQuery中的$.get()获取json数据 

<!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></title>
    <script src="jquery-1.4.1.min.js" type="text/javascript"></script>
    <script type="text/javascript">
        $(function () {
            $("#btn_load").click(function () {
               // 使用一般处理程序，处理返回的JSON数据,类型标不标JSON都无影响，关键是一般处理程序的返回格式必须是JSON
                $.get(
                    "test.ashx",
                    { name: $("#username").val() },
                    function (data) {
                        var str = "";
                        str += "编号：" + data.ID + "<br/>";
                        str += "姓名：" + data.Name + "<br/>";
                        str += "性别：" + data.Sex + "<br/>";
                        str += "职称：" + data.Position + "<br/>";
                        str += "院系：" + data.Dept + "<br/>";
                        $("#content").html(str);
                    }   
                );
                //使用aspx页面，处理返回的html数据（aspx只能返回html数据，即使ContentType是json也没用）
                $.get(
                    "Reponse.aspx",
                    { name: $("#username").val() },
                    function (data) {
                        $("#content").html(data);
                    }
                );
            });
        })
    </script>
</head>
<body>
姓名：<input type="text" id="username"/>&nbsp;
<input type="button" value="查询" id="btn_load"/>
<div id="content"></div>
</body>
</html>

一般处理程序代码

public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/json";
            string username = context.Request.QueryString["name"].ToString();
            string strcon = "server=.;database=ProjectApplication;uid=sa;pwd=123;";
            string strsql = string.Format("select [AppId],[AppName],[AppSex],[AppPosition],[AppDept] from ApplicatorInfo where AppName=@name", username);
            using (SqlConnection con = new SqlConnection(strcon))
            {
                con.Open();
                using (SqlCommand cmd = new SqlCommand(strsql, con))
                {
                    cmd.Parameters.AddWithValue("@name", username);
                    SqlDataReader reader = cmd.ExecuteReader();         
                    Dictionary<string, string> dicts = new Dictionary<string, string>();
                    while (reader.Read())
                    {
                        dicts.Add("ID", reader[0].ToString());
                        dicts.Add("Name", reader[1].ToString());
                        dicts.Add("Sex", reader[2].ToString());
                        dicts.Add("Position", reader[3].ToString().Trim());
                        dicts.Add("Dept", reader[4].ToString().Trim());
                    }
                    JavaScriptSerializer serializer = new JavaScriptSerializer();
                    context.Response.Write(serializer.Serialize(dicts));
                }
            }
        }

 

posted @ 2014-01-14 14:52  刘朝样  阅读(1488)  评论(0)    收藏  举报