{"id":398,"date":"2006-09-04T16:36:19","date_gmt":"2006-09-04T16:36:19","guid":{"rendered":"http:\/\/fanhaijun.com\/?p=398"},"modified":"2006-09-04T16:36:19","modified_gmt":"2006-09-04T16:36:19","slug":"%e5%a4%9a%e7%ba%a7%e5%85%b3%e8%81%94%e8%8f%9c%e5%8d%95%e6%95%b0%e6%8d%ae%e5%ba%93%e7%89%88","status":"publish","type":"post","link":"https:\/\/fanhaijun.com\/?p=398","title":{"rendered":"\u591a\u7ea7\u5173\u8054\u83dc\u5355\u6570\u636e\u5e93\u7248"},"content":{"rendered":"<p>&lt;html&gt;&nbsp;&nbsp;<br \/>&lt;head&gt;&nbsp;&nbsp;<br \/>&lt;meta&nbsp;&nbsp;http-equiv=&quot;Content-Type&quot;&nbsp;&nbsp;content=&quot;text\/html;&nbsp;&nbsp;charset=gb2312&quot;&gt;&nbsp;&nbsp;<br \/>&lt;meta&nbsp;&nbsp;name=&quot;GENERATOR&quot;&nbsp;&nbsp;content=&quot;Microsoft&nbsp;&nbsp;FrontPage&nbsp;&nbsp;4.0&quot;&gt;&nbsp;&nbsp;<br \/>&lt;meta&nbsp;&nbsp;name=&quot;ProgId&quot;&nbsp;&nbsp;content=&quot;FrontPage.Editor.Document&quot;&gt;&nbsp;&nbsp;<br \/>&lt;title&gt;\u591a\u7ea7\u5173\u8054\u83dc\u5355\u6570\u636e\u5e93\u7248&lt;\/title&gt;&nbsp;&nbsp;<br \/>&lt;!&#8211;&nbsp;&nbsp;<br \/>\u6570\u636e\u5e93:test.mdb&nbsp;&nbsp;<br \/>\u8868:dbselect&nbsp;&nbsp;<br \/>\u8868\u7ed3\u6784:id(\u81ea\u589e)&nbsp;&nbsp;school(\u6587\u672c)&nbsp;&nbsp;department(\u6587\u672c)&nbsp;&nbsp;grade(\u6587\u672c)&nbsp;&nbsp;student(\u6587\u672c)&nbsp;&nbsp;<br \/>IE6,NS7,Mozilla\u4e0b\u6d4b\u8bd5\u901a\u8fc7&nbsp;&nbsp;<br \/>&#8211;&gt;&nbsp;&nbsp;<br \/>&lt;\/head&gt;&nbsp;&nbsp;<br \/>&lt;body&gt;&nbsp;&nbsp;<br \/>&lt;form&nbsp;&nbsp;name=&quot;frm&quot;&gt;&nbsp;&nbsp;<br \/>&lt;select&nbsp;&nbsp;name=school&nbsp;&nbsp;onchange=&quot;MulSelect(1)&quot;&gt;&lt;\/select&gt;&nbsp;&nbsp;<br \/>&lt;select&nbsp;&nbsp;name=department&nbsp;&nbsp;onchange=&quot;MulSelect(2)&quot;&gt;&lt;\/select&gt;&nbsp;&nbsp;<br \/>&lt;select&nbsp;&nbsp;name=grade&nbsp;&nbsp;onchange=&quot;MulSelect(3)&quot;&gt;&lt;\/select&gt;&nbsp;&nbsp;<br \/>&lt;select&nbsp;&nbsp;name=student&gt;&lt;\/select&gt;&nbsp;&nbsp;<br \/>&lt;\/form&gt;&nbsp;&nbsp;<br \/>&lt;script&gt;&nbsp;&nbsp;<br \/>var&nbsp;&nbsp;arrSel=[&quot;school&quot;,&quot;department&quot;,&quot;grade&quot;,&quot;student&quot;]&nbsp;&nbsp;<br \/>arrData=[];&nbsp;&nbsp;<br \/>&lt;%&nbsp;&nbsp;<br \/>dim&nbsp;&nbsp;conn,rs&nbsp;&nbsp;<br \/>set&nbsp;&nbsp;conn&nbsp;&nbsp;=&nbsp;&nbsp;Server.CreateObject(&quot;ADODB.Connection&quot;)&nbsp;&nbsp;<br \/>conn.Open&nbsp;&nbsp;&quot;Provider=Microsoft.Jet.OLEDB.4.0;Data&nbsp;&nbsp;Source=&quot;&nbsp;&nbsp;&#038;&nbsp;&nbsp;Server.mappath(&quot;test.mdb&quot;)&nbsp;&nbsp;&#038;&nbsp;&nbsp;&quot;;Persist&nbsp;&nbsp;Security&nbsp;&nbsp;Info=False&quot;&nbsp;&nbsp;<br \/>set&nbsp;&nbsp;rs=conn.execute(&quot;select&nbsp;&nbsp;*&nbsp;&nbsp;from&nbsp;&nbsp;dbselect&quot;)&nbsp;&nbsp;<br \/>do&nbsp;&nbsp;while&nbsp;&nbsp;not&nbsp;&nbsp;rs.eof&nbsp;&nbsp;<br \/>%&gt;&nbsp;&nbsp;<br \/>arrData[arrData.length]=[&quot;&lt;%=trim(rs(&quot;school&quot;))%&gt;&quot;,&quot;&lt;%=trim(rs(&quot;department&quot;))%&gt;&quot;,&quot;&lt;%=trim(rs(&quot;grade&quot;))%&gt;&quot;,&quot;&lt;%=trim(rs(&quot;student&quot;))%&gt;&quot;]&nbsp;&nbsp;<br \/>&lt;%&nbsp;&nbsp;<br \/>rs.movenext&nbsp;&nbsp;<br \/>loop&nbsp;&nbsp;<br \/>rs.close:set&nbsp;&nbsp;rs=nothing&nbsp;&nbsp;<br \/>conn.close:set&nbsp;&nbsp;conn=nothing&nbsp;&nbsp;<br \/>%&gt;&nbsp;&nbsp;<br \/>&lt;\/script&gt;&nbsp;&nbsp;<br \/>&lt;script&gt;&nbsp;&nbsp;<br \/>function&nbsp;&nbsp;MulSelect(num){&nbsp;&nbsp;<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;&nbsp;find=false&nbsp;&nbsp;<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;var&nbsp;&nbsp;i,j,arrTemp=[];&nbsp;&nbsp;<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(i=0;i&lt;num;i++)arrTemp[i]=eval(&quot;document.frm.&quot;+arrSel[i]).value&nbsp;&nbsp;<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(num&lt;arrSel.length)&nbsp;&nbsp;<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;with(eval(&quot;document.frm.&quot;+arrSel[num])){&nbsp;&nbsp;<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;length=0&nbsp;&nbsp;<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(i=0;i&lt;arrData.length;i++){&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(j=0;j&lt;num;j++)if(arrTemp[j]!=arrData[i][j])break;&nbsp;&nbsp;<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(j!=num)continue;&nbsp;&nbsp;<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(length==0&nbsp;&nbsp;\u00a6&nbsp;&nbsp;\u00a6options[length-1].text!=arrData[i][num]){&nbsp;&nbsp;<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for(m=0;m&lt;options.length;m++)if(options[m].text==arrData[i][num])find=true&nbsp;&nbsp;<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if(!find)options[options.length]=new&nbsp;&nbsp;Option(arrData[i][num],arrData[i][num])&nbsp;&nbsp;<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MulSelect((num+1))&nbsp;&nbsp;<br \/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;<br \/>}&nbsp;&nbsp;<br \/>MulSelect(0)&nbsp;&nbsp;<br \/>&lt;\/script&gt;&nbsp;&nbsp;<br \/>&lt;\/body&gt;&nbsp;&nbsp;<br \/>&lt;\/html&gt;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&lt;html&gt;&nbsp;&nbsp;&lt;he&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[100],"tags":[],"class_list":["post-398","post","type-post","status-publish","format-standard","hentry","category-nothing"],"_links":{"self":[{"href":"https:\/\/fanhaijun.com\/index.php?rest_route=\/wp\/v2\/posts\/398","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fanhaijun.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fanhaijun.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fanhaijun.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fanhaijun.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=398"}],"version-history":[{"count":0,"href":"https:\/\/fanhaijun.com\/index.php?rest_route=\/wp\/v2\/posts\/398\/revisions"}],"wp:attachment":[{"href":"https:\/\/fanhaijun.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fanhaijun.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fanhaijun.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}