ASP+JSÈý¼¶Áª¶¯ÏÂÀ­²Ëµ¥[µ÷ÓÃÊý¾Ý¿âÊý¾Ý]

´óÄ®

¿Ï¶¨ÏÈÒªÁ¬½ÓÊý¾Ý¿âÁË£¬²»ÓÃ˵ÁË
'Êý¾Ý¿â½á¹¹
'Àà±ð1±íÃû³Æ£ºa  ×ֶΣºID,Name  ËµÃ÷£ºIDΪÖ÷¼üÊÇÀà±ð1µÄIDÖµ£¬NameΪÀà±ð1µÄÃû³Æ
'Àà±ð2±íÃû³Æ£ºaa  ×ֶΣºID,aID,Name  ËµÃ÷£ºIDΪÖ÷¼üÊÇÀà±ð2µÄIDÖµ£¬aIDΪËùÊôÀà±ð1µÄIDÖµ£¬NameΪÀà±ð2µÄÃû³Æ
'Àà±ð3±íÃû³Æ£ºaaa  ×ֶΣºID,aID,aaID,Name  ËµÃ÷£ºIDΪÖ÷¼üÊÇÀà±ð3µÄIDÖµ£¬aIDΪËùÊôÀà±ð1µÄIDÖµ£¬aaIDΪËùÊôÀà±ð2µÄIDÖµ£¬NameΪÀà±ð3µÄÃû³Æ

<!-- Èý¼¶Áª¶¯²Ëµ¥ ¿ªÊ¼ -->
<script language="Javascript">
<!--
<%
'¶þ¼¶Êý¾Ý±£´æµ½Êý×é
Dim count2,rsClass2,sqlClass2
set rsClass2=server.createobject("adodb.recordset")
sqlClass2="select * from aa"
rsClass2.open sqlClass2,conn,1,1
%>
var subval2 = new Array();
//Êý×é½á¹¹£ºÒ»¼¶¸ùÖµ,¶þ¼¶¸ùÖµ,¶þ¼¶ÏÔʾֵ
<%
count2 = 0
do while not rsClass2.eof
%>
subval2[<%=count2%>] = new Array('<%=rsClass2("aID")%>','<%=rsClass2("ID")%>','<%=rsClass2("Name")%>')
<%
count2 = count2 + 1
rsClass2.movenext
loop
rsClass2.close
%>

<%
'Èý¼¶Êý¾Ý±£´æµ½Êý×é
Dim count3,rsClass3,sqlClass3
set rsClass3=server.createobject("adodb.recordset")
sqlClass3="select * from aaa"
rsClass3.open sqlClass3,conn,1,1
%>
var subval3 = new Array();
//Êý×é½á¹¹£º¶þ¼¶¸ùÖµ,Èý¼¶¸ùÖµ,Èý¼¶ÏÔʾֵ
<%
count3 = 0
do while not rsClass3.eof
%>
subval3[<%=count3%>] = new Array('<%=rsClass3("aaID")%>','<%=rsClass3("ID")%>','<%=rsClass3("Name")%>')
<%
count3 = count3 + 1
rsClass3.movenext
loop
rsClass3.close
%>

function changeselect1(locationid)
{
    document.form1.s2.length = 0;
    document.form1.s2.options[0] = new Option('==ÇëÑ¡ÔñÀà±ð==','');
    document.form1.s3.length = 0;
    document.form1.s3.options[0] = new Option('==ÇëÑ¡ÔñרÌâ==','');
    for (i=0; i<subval2.length; i++)
    {
        if (subval2[i][0] == locationid)
        {document.form1.s2.options[document.form1.s2.length] = new Option(subval2[i][2],subval2[i][1]);}
    }
}

function changeselect2(locationid)
{
    document.form1.s3.length = 0;
    document.form1.s3.options[0] = new Option('==ÇëÑ¡ÔñרÌâ==','');
    for (i=0; i<subval3.length; i++)
    {
        if (subval3[i][0] == locationid)
        {document.form1.s3.options[document.form1.s3.length] = new Option(subval3[i][2],subval3[i][1]);}
    }
}
//-->
</script>

<form name="form1" method="post" action="test1.asp">

Èý¼¶Áª¶¯£º
<%
Dim count1,rsClass1,sqlClass1
set rsClass1=server.createobject("adodb.recordset")
sqlClass1="select * from a"
rsClass1.open sqlClass1,conn,1,1
%>
<select name="s1" onChange="changeselect1(this.value)">
<option>==ÇëÑ¡ÔñƵµÀ==</option>
<%
count1 = 0
do while not rsClass1.eof
response.write"<option value="&rsClass1("ID")&">"&rsClass1("Name")&"</option>"
count1 = count1 + 1
rsClass1.movenext
loop
rsClass1.close
%>
</select>

<select name="s2"  onChange="changeselect2(this.value)">
<option>==ÇëÑ¡ÔñÀà±ð==</option>
</select>

<select name="s3">
<option>==ÇëÑ¡ÔñרÌâ==</option>
</select>
<input type="submit" name="Submit" value="Ìá½»"></form>

<!-- Èý¼¶Áª¶¯²Ëµ¥ ½áÊø -->

=====test1.asp Äã¿ÉÒÔ²âÊÔÏ£¬½ÓÊÕµ½µÄ¶¼ÊÇÀà±ðµÄIDÖµ====
<%
response.write"1:"&Request.form("s1")&"<BR>"
response.write"2:"&Request.form("s2")&"<BR>"
response.write"3:"&Request.form("s3")&"<BR>"
%>