{"id":30,"date":"2007-08-21T15:16:57","date_gmt":"2007-08-21T07:16:57","guid":{"rendered":"http:\/\/www.cnmiss.cn\/?p=29"},"modified":"2010-12-02T06:32:07","modified_gmt":"2010-12-02T06:32:07","slug":"aspjs%e4%b8%89%e7%ba%a7%e8%81%94%e5%8a%a8%e4%b8%8b%e6%8b%89%e8%8f%9c%e5%8d%95%e8%b0%83%e7%94%a8%e6%95%b0%e6%8d%ae%e5%ba%93%e6%95%b0%e6%8d%ae","status":"publish","type":"post","link":"https:\/\/www.cnmiss.cn\/?p=30","title":{"rendered":"ASP+JS\u4e09\u7ea7\u8054\u52a8\u4e0b\u62c9\u83dc\u5355[\u8c03\u7528\u6570\u636e\u5e93\u6570\u636e]"},"content":{"rendered":"

\"ASP+JS\u4e09\u7ea7\u8054\u52a8\u4e0b\u62c9\u83dc\u5355[\u8c03\u7528\u6570\u636e\u5e93\u6570\u636e]<\/a><\/p>\n

'\u80af\u5b9a\u5148\u8981\u8fde\u63a5\u6570\u636e\u5e93\u4e86\uff0c\u4e0d\u7528\u8bf4\u4e86
'\u6570\u636e\u5e93\u7ed3\u6784
'\u7c7b\u522b1\u8868\u540d\u79f0\uff1aa \u5b57\u6bb5\uff1aID,Name \u8bf4\u660e\uff1aID\u4e3a\u4e3b\u952e\u662f\u7c7b\u522b1\u7684ID\u503c\uff0cName\u4e3a\u7c7b\u522b1\u7684\u540d\u79f0
'\u7c7b\u522b2\u8868\u540d\u79f0\uff1aaa \u5b57\u6bb5\uff1aID,aID,Name \u8bf4\u660e\uff1aID\u4e3a\u4e3b\u952e\u662f\u7c7b\u522b2\u7684ID\u503c\uff0caID\u4e3a\u6240\u5c5e\u7c7b\u522b1\u7684ID\u503c\uff0cName\u4e3a\u7c7b\u522b2\u7684\u540d\u79f0
'\u7c7b\u522b3\u8868\u540d\u79f0\uff1aaaa \u5b57\u6bb5\uff1aID,aID,aaID,Name \u8bf4\u660e\uff1aID\u4e3a\u4e3b\u952e\u662f\u7c7b\u522b3\u7684ID\u503c\uff0caID\u4e3a\u6240\u5c5e\u7c7b\u522b1\u7684ID\u503c\uff0caaID\u4e3a\u6240\u5c5e\u7c7b\u522b2\u7684ID\u503c\uff0cName\u4e3a\u7c7b\u522b3\u7684\u540d\u79f0<\/p>\n

<!– \u4e09\u7ea7\u8054\u52a8\u83dc\u5355 \u5f00\u59cb –>
<script language="JavaScript">
<!–
<%
'\u4e8c\u7ea7\u6570\u636e\u4fdd\u5b58\u5230\u6570\u7ec4
Dim count2,rsClass2,sqlClass2
set rsClass2=server.createobject("adodb.recordset")
sqlClass2="select * from aa"
rsClass2.open sqlClass2,conn,1,1
%>
var subval2 = new Array();
\/\/\u6570\u7ec4\u7ed3\u6784\uff1a\u4e00\u7ea7\u6839\u503c,\u4e8c\u7ea7\u6839\u503c,\u4e8c\u7ea7\u663e\u793a\u503c
<%
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
%><\/p>\n

<%
'\u4e09\u7ea7\u6570\u636e\u4fdd\u5b58\u5230\u6570\u7ec4
Dim count3,rsClass3,sqlClass3
set rsClass3=server.createobject("adodb.recordset")
sqlClass3="select * from aaa"
rsClass3.open sqlClass3,conn,1,1
%>
var subval3 = new Array();
\/\/\u6570\u7ec4\u7ed3\u6784\uff1a\u4e8c\u7ea7\u6839\u503c,\u4e09\u7ea7\u6839\u503c,\u4e09\u7ea7\u663e\u793a\u503c
<%
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
%><\/p>\n

function changeselect1(locationid)
{
document.form1.s2.length = 0;
document.form1.s2.options[0] = new Option('==\u8bf7\u9009\u62e9\u7c7b\u522b==','');
document.form1.s3.length = 0;
document.form1.s3.options[0] = new Option('==\u8bf7\u9009\u62e9\u4e13\u9898==','');
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]);}
}
}<\/p>\n

function changeselect2(locationid)
{
document.form1.s3.length = 0;
document.form1.s3.options[0] = new Option('==\u8bf7\u9009\u62e9\u4e13\u9898==','');
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><\/p>\n

<form name="form1" method="post" action="test1.asp"><\/p>\n

\u4e09\u7ea7\u8054\u52a8\uff1a
<%
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>==\u8bf7\u9009\u62e9\u9891\u9053==<\/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><\/p>\n

<select name="s2" onChange="changeselect2(this.value)">
<option>==\u8bf7\u9009\u62e9\u7c7b\u522b==<\/option>
<\/select><\/p>\n

<select name="s3">
<option>==\u8bf7\u9009\u62e9\u4e13\u9898==<\/option>
<\/select>
<input type="submit" name="Submit" value="\u63d0\u4ea4"><\/form><\/p>\n

<!– \u4e09\u7ea7\u8054\u52a8\u83dc\u5355 \u7ed3\u675f –><\/p>\n

=====test1.asp \u4f60\u53ef\u4ee5\u6d4b\u8bd5\u4e0b\uff0c\u63a5\u6536\u5230\u7684\u90fd\u662f\u7c7b\u522b\u7684ID\u503c====
<%
response.write"1:"&Request.form("s1")&"<BR>"
response.write"2:"&Request.form("s2")&"<BR>"
response.write"3:"&Request.form("s3")&"<BR>"
%><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

'\u80af\u5b9a\u5148\u8981\u8fde\u63a5\u6570\u636e\u5e93\u4e86\uff0c\u4e0d\u7528\u8bf4\u4e86'\u6570\u636e\u5e93\u7ed3\u6784'\u7c7b\u522b1\u8868\u540d … \u7ee7\u7eed\u9605\u8bfb →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[13,20],"class_list":["post-30","post","type-post","status-publish","format-standard","hentry","category-xxbj","tag-asp","tag-javascript"],"_links":{"self":[{"href":"https:\/\/www.cnmiss.cn\/index.php?rest_route=\/wp\/v2\/posts\/30","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cnmiss.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cnmiss.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cnmiss.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cnmiss.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=30"}],"version-history":[{"count":0,"href":"https:\/\/www.cnmiss.cn\/index.php?rest_route=\/wp\/v2\/posts\/30\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.cnmiss.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=30"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cnmiss.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=30"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cnmiss.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=30"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}