**********************(一)打开记录集,创建数组,把记录集的值赋给数组.

<%

Dimcount

setRs=server.createobject("adodb.recordset")

Sql="select*fromBookBoardorderbyClassIddesc"

Rs.openSql,cn,1,1%>

<scriptlanguage="JavaScript">

varonecount;

onecount=0;

subcat=newArray();

<%count=0

dowhilenotRs.eof%>

subcat[<%=count%>]=newArray("<%=trim(Rs("BoardName"))%>","<%=trim(Rs("ClassId"))%>","<%=trim(Rs("BoardId"))%>");

<%count=count+1

Rs.movenext

loop

Rs.close%>

onecount=<%=count%>;

functionchangelocation(locationid)

{document.form1.BoardId.length=0;

varlocationid=locationid;

vari;

for(i=0;i<onecount;i++)

{if(subcat[i][1]==locationid)

{document.form1.BoardId.options[document.form1.BoardId.length]=newOption(subcat[i][0],subcat[i][2]);

}}}

</script>

**********************(二)显示分组,并编写列表框的OnChange事件.

<%setRs=server.CreateObject("adodb.recordset")

Sql="select*fromBookClassorderbyClassIddesc"

Rs.openSql,cn,1,1

ifRs.eofandRs.bofthen

response.write"请先添加总类。"

response.end

else%>

<selectname="ClassId"onChange="changelocation(document.form1.ClassId.options[document.form1.ClassId.selectedIndex].value)">

<optionselectedvalue="">==请选择大类==</option>

<%dountilRs.eof%>

<optionvalue="<%=trim(Rs("ClassId"))%>"><%=trim(Rs("ClassName"))%></option>

<%Rs.movenext

loop

endif

Rs.close

setRs=nothing%>

</select>

<selectname="BoardId"><optionselectedvalue="">==请选择小类==</option>

</select>