中科新闻网新员工转正自我总结:asp 问题
来源：百度文库 编辑：中科新闻网 时间：2024/05/08 06:32:08
<select name="bus_class" id="bus_class">显示车类项目 （值1代表“宝马”值2代表“大众”
<select name="bus_sort" id="bus_class">显示车型项目 属于宝马的（值1代表“跑车型”值2代表“流线型”） 属于大众的（值3代表“快速型”值4代表“慢速型”）
现在我需要实现车型随车类连动的效果，即当车类改变时，车型的下拉框中的菜单项就会随着改变。
有高手懂吗？
<Script language="JavaScript">
var onecount;
subcat = new Array();
<% sql="select * from sheng";
rs=dealsql.executeQuery(sql);
int n=0;
while (rs.next())
{
%>
subcat[<%=n%>]=new Array("<%=rs.getString("s_name")%>","<%=rs.getString("s_id")%>","0")
<%
n=n+1;
}
rs.close();
sql="select * from shi";
rs=dealsql.executeQuery(sql);
while (rs.next())
{
%>
subcat[<%=n%>]=new Array("<%=rs.getString("ss_name")%>","<%=rs.getString("ss_id")%>","<%=rs.getString("s_id")%>")
<%
n=n+1;
}
rs.close();
%>
onecount=398;
function changelocation1(locationid)
{
document.form1.shiyu.length = 0;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][2] == locationid)
{
document.form1.shiyu.options[document.form1.shiyu.length] = new Option(subcat[i][0], subcat[i][1]);
}
}
}
function changelocation11(locationid)
{
document.form1.shiyu1.length = 0;
var locationid=locationid;
var i;
for (i=0;i < onecount; i++)
{
if (subcat[i][2] == locationid)
{
document.form1.shiyu1.options[document.form1.shiyu1.length] = new Option(subcat[i][0], subcat[i][1]);
}
}
}
</SCRIPT>
<SELECT name="diyu1" onchange="changelocation11(document.form1.diyu1.options[document.form1.diyu1.selectedIndex].value)">
<OPTION value="1" selected>省份</OPTION>
<%
sql = "select * from sheng";
rs=dealsql.executeQuery(sql);
while (rs.next())
{
%>
<option value="<%=rs.getString("S_id")%>"><%=rs.getString("S_Name")%></option>
<%
}
rs.close();
%>
</select>
来个二级联动菜单代码，把如下代码加入<body></body>区域中，里面的东西自己去修改：
<!-- 二级联动 Start -->
<script language="JavaScript">
var subcat = new Array();
subcat[0] = new Array('10','1','=1')
subcat[1] = new Array('10','2','=2')
subcat[2] = new Array('10','3','=3')
subcat[3] = new Array('10','4','=4')
subcat[4] = new Array('10','5','=5')
subcat[5] = new Array('10','6','=6')
subcat[6] = new Array('10','7','=7')
subcat[7] = new Array('10','8','=8')
subcat[8] = new Array('10','9','=9')
subcat[9] = new Array('10','10','=10')
subcat[10] = new Array('20','11','=11')
subcat[11] = new Array('20','12','=12')
subcat[12] = new Array('20','13','=13')
subcat[13] = new Array('20','14','=14')
subcat[14] = new Array('20','15','=15')
subcat[15] = new Array('20','16','=16')
subcat[16] = new Array('20','17','=17')
subcat[17] = new Array('20','18','=18')
subcat[18] = new Array('20','19','=19')
subcat[19] = new Array('20','20','=20')
function changeselect1(locationid)
{
document.form1.s2.length = 0;
document.form1.s2.options[0] = new Option('==请选择==','');
for (i=0; i<subcat.length; i++)
{
if (subcat[i][0] == locationid)
{document.form1.s2.options[document.form1.s2.length] = new Option(subcat[i][1], subcat[i][2]);}
}
}
</script>
<form name="form1">
二级联动：
<select name="s1" onChange="changeselect1(this.value)">
<option>==请选择==</option>
<option value="10">1-10</option>
<option value="20">11-20</option>
</select>
<select name="s2" onChange="alert(this.value)">
<option>==请选择==</option>
</select>
</form>
<!-- 二级联动 Over -->
这个不是ASP的东西吧，你可以用javascript来实现~~~
ASP+ACCESS简单实现.
数据库分两个表 表1保存车类(字段:车类) 表2保存车型(字段:车型,所属车类)
然后两个列表分别从数据库中读出两个表.当车类列表onchange时,重读车型数据库.重新列出该车类所有的车型.