<%sqlstr="select*fromprolei"setrs=conn.execute(sqlstr)setrs1=server.CreateObject("adodb.recordset")sqlstr1="select*fromsecleiorderbyprolei_iddesc"setrs1=conn.execute(sqlstr1)setrs2=conn.execute("selec" />

日韩久久久精品,亚洲精品久久久久久久久久久,亚洲欧美一区二区三区国产精品 ,一区二区福利

asp實現(xiàn)三級聯(lián)動表單

系統(tǒng) 1993 0
< ! -- #includefile = " conn.asp " -->
< %sqlstr = " select*fromprolei "
set rs = conn.execute(sqlstr)
set rs1 = server.CreateObject( " adodb.recordset " )
sqlstr1
= " select*fromsecleiorderbyprolei_iddesc "
set rs1 = conn.execute(sqlstr1)
set rs2 = conn.execute( " select*fromendleiorderbyseclei_iddesc " )
%
>
< scriptlanguage = " JavaScript " >
varonecount;
onecount
= 0 ;
subcat
= new Array ();
< %
CountLinkAction
= 0
do while not rs1.eof
%
>
subcat[
< % = CountLinkAction% > ] = new Array ( " <%=trim(rs1( " seclei " ))%> " , " <%=trim(rs1( " prolei_id " ))%> " , " <%=trim(rs1( " id " ))%> " );
// subcat[ < % = CountLinkAction% > ] = new Array ( " <%=trim(rs1( " seclei " ))%> " , " <%=trim(rs1( " prolei_id " ))%> " );
< %
CountLinkAction
= CountLinkAction + 1
rs1.movenext
loop
rs1.close
set rs1 = nothing
%
>
onecount
=< % = CountLinkAction% > ;
function changelocation(locationid)
{
document.form1.selectlei2.length
= 0 ;
varlocationid
= locationid;
vari;
document.form1.selectlei2.options[
0 ] = new Option ( ' 請選擇小類','');
for (i = 0 ;i < onecount;i ++ )
{
if (subcat[i][ 1 ] == locationid)
{
document.form1.selectlei2.options[document.form1.selectlei2.length]
= new Option (subcat[i][ 0 ],subcat[i][ 2 ]);
}
}
}
</ script >
< scriptlanguage = " JavaScript " >
varonecount1;
onecount1
= 0 ;
subcat1
= new Array ();
< %
CountLinkAction1
= 0
do while not rs2.eof
%
>
subcat1[
< % = CountLinkAction1% > ] = new Array ( " <%=trim(rs2( " endlei " ))%> " , " <%=trim(rs2( " seclei_id " ))%> " );
< %
CountLinkAction1
= CountLinkAction1 + 1
rs2.movenext
loop
rs2.close
set rs2 = nothing
%
>
onecount1
=< % = CountLinkAction1% > ;
function changelocation1(locationid1)
{
document.form1.selectlei3.length
= 0 ;
varlocationid1
= locationid1;
varj;
document.form1.selectlei3.options[
0 ] = new Option ( ' 請選擇子類','');
for (j = 0 ;j < onecount1;j ++ )
{
if (subcat1[j][ 1 ] == locationid1)
{
document.form1.selectlei3.options[document.form1.selectlei3.length]
= new Option (subcat1[j][ 0 ],subcat1[j][ 0 ]);
}
}
}
</ script >
< formname = " form1 " method = " post " action = " send.asp " onSubmit = " returncheckadd() " >
< tablewidth = " 95% " align = " center " cellpadding = " 5 " cellspacing = " 1 " bgcolor = " A4B6D7 " >
< trbgcolor = " ECF5FF " >
< tdwidth = " 20% " height = " 30 " align = " right " bgcolor = " ECF5FF " > 所屬類別: </ td >
< TDwidth = " 80% " >
< select name = " selectlei " class = " input " onChange = " changelocation(document.form1.selectlei.options[document.form1.selectlei.selectedIndex].value) " >
< option selected > 請選擇大類 </ option >
< % do while not rs.eof
response.write(
" <optionvalue= " & rs( " id " ) & " > " & rs( " prolei " ) & " </option> " )
rs.movenext
loop % >
</ select >
< select name = " selectlei2 " class = " input " id = " selectlei2 " onChange = " changelocation1(document.form1.selectlei2.options[document.form1.selectlei2.selectedIndex].value) " >
< option selected > 請選擇小類 </ option >
</ select >
< select name = " selectlei3 " class = " input " id = " selectlei3 " >
< option selected > 請選擇子類 </ option >
</ select >
</ TD >
</ tr >
< trbgcolor = " ECF5FF " >
< tdheight = " 30 " align = " right " bgcolor = " ECF5FF " > </ td >
< tdbgcolor = " ECF5FF " >
< inputname = " Submit " type = " submit " class = " button " value = " 提交 " onFocus = " blur() " >
< inputname = " reset " type = " reset " class = " button " value = " 重置 " onFocus = " blur() " ></ td >
</ tr >
</ table >
</ form >
三級的聯(lián)動,全是讀數(shù)據(jù)庫里的數(shù)據(jù),級別:prolei--seclei--endlei

asp實現(xiàn)三級聯(lián)動表單


更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主

微信掃碼或搜索:z360901061

微信掃一掃加我為好友

QQ號聯(lián)系: 360901061

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點擊下面給點支持吧,站長非常感激您!手機微信長按不能支付解決辦法:請將微信支付二維碼保存到相冊,切換到微信,然后點擊微信右上角掃一掃功能,選擇支付二維碼完成支付。

【本文對您有幫助就好】

您的支持是博主寫作最大的動力,如果您喜歡我的文章,感覺我的文章對您有幫助,請用微信掃描上面二維碼支持博主2元、5元、10元、自定義金額等您想捐的金額吧,站長會非常 感謝您的哦!!!

發(fā)表我的評論
最新評論 總共0條評論
主站蜘蛛池模板: 麦盖提县| 蕲春县| 柳河县| 穆棱市| 乌兰县| 彝良县| 固镇县| 修水县| 霍邱县| 福鼎市| 勃利县| 左云县| 西昌市| 洮南市| 达孜县| 淮北市| 云浮市| 南川市| 河曲县| 罗田县| 霍城县| 金华市| 潼南县| 左云县| 建瓯市| 凤凰县| 二手房| 普兰店市| 保康县| 蒲城县| 镇巴县| 延安市| 巴东县| 云安县| 新化县| 马鞍山市| 南丰县| 寿阳县| 阜康市| 古丈县| 洪洞县|