ajax的简单应用select（一）

最新推荐文章于 2022-08-23 23:49:36 发布

ysf871104

最新推荐文章于 2022-08-23 23:49:36 发布

阅读量627

点赞数

分类专栏： ajax 文章标签： ajax xmlhttprequest dataset function class string

本文链接：https://blog.csdn.net/ysf871104/article/details/4992973

版权

ajax 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

<%@ WebHandler Language="C#" Class="Handler" %>

using System;
using System.Web;
using System.Data;
using System.Data.SqlClient;
public class Handler : IHttpHandler {

   public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";
        string majorid = context.Request.Params["major"].ToString().Trim();
        string major = "";
        //避免不识别汉字
        if (majorid == "1")
        {
            major = "一年级";
        }
        else if (majorid == "2")
        {
            major = "二年级";
        }
        //从数据库提取数据
        SqlConnection conn = new SqlConnection("server=.;database=checkattendance;uid=chenxiuhong;pwd=123456;");
        SqlDataAdapter da = new SqlDataAdapter("select gradename from tab_grade where gradename like '" + major + "%'", conn);
        DataSet ds = new DataSet();
        da.Fill(ds);
        //定义响应文本的格式，以返回

        string result = "";
        foreach (DataRow row in ds.Tables[0].Rows)
        {
            result += row[0].ToString().Trim() + " ";
        }
        context.Response.Write(result.Trim());

    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}

------------------------------------------------

<!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 runat="server">
    <title>无标题页</title>
    <script type ="text/javascript" >
    var xmlHttp;
var requesttype="";
    function createXmlHttp()
    {
    if(window.XMLHttpRequest)
    {
        xmlHttp=new XMLHttpRequest();//mozilla浏览器
    }
    else if(window.ActiveXObject)
    {
        try
        {
            xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");//ＩＥ旧版本
        }
        catch(e)
        {
        }
        try
        {
            xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");//ＩＥ新版本
        }
        catch(e)
        {
        }
        if(!xmlHttp)
        {
            window.alert("不能创建XMLHTTPREQUEST对象!");
            return false;
        }
    }
}
function startRequest()
{
    createXmlHttp();
    //使用ＧＥＴ方式
    var url="Handler.ashx?major="+document.getElementById("major").options.value;
    xmlHttp.open("GET",url,true);
    xmlHttp.onreadystatechange=bindclass;
    xmlHttp.send(null);

}
function bindclass()
{
    if(xmlHttp.readyState==4)
    {
        if(xmlHttp.status==200)
        {
              var selclass=document.getElementById("class");
              //如果被动（被激发的）下拉有内容，要首先清空
              while(selclass.hasChildNodes())
              {
                 var node=selclass.children(0)
                 selclass.removeChild(node);
              }
              //获取响应内容
              var result=xmlHttp.responseText;
              //分割以方便绑定
              var optiontext=result.split(' ');
              //将分割后的内容绑定到被动下拉列表
              for(var i=0;i<optiontext.length;i++)
              {
                    var optionnode=document.createElement("OPTION");
                    optionnode.text=optiontext[i];
                    selclass.add(optionnode);
              }
        }
    }
}

    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <select id="major" onchange ="startRequest();">
            <option value ="1">一年级</option>
            <option value ="2" >二年级</option>
        </select>
        <select id="class">
        </select>
    </div>
    </form>
</body>

</html>