http://expert.csdn.net/Expert/topic/2970/2970355.xml?temp=.1002924

解决方案 »

  1.   

    连动问题:newbig:CREATE TABLE [dbo].[newbig] (
    [BigId] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [bigtypes] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL 
    )newmiddle
    CREATE TABLE [dbo].[newmiddle] (
    [middleid] [nvarchar] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [middletypes] [nvarchar] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [bigid] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
    )newsmall
    CREATE TABLE [dbo].[newSmall] (
    [Smallid] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [SmallTypes] [nvarchar] (25) COLLATE Chinese_PRC_CI_AS NULL ,
    [middleid] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
    )<table width="498" border="0" cellspacing="0" cellpadding="0">
                  <tr> 
                    <td > <!-- #include file="conn.asp"--> <script language=javascript>
    function cc(theform5) {
    if ((theform5.txt.value=="") &&(theform5.sheng.value=="")&&(theform5.bigtypes.value==""))
     { alert("查询条件都不能为空。");
       theform5.txt.focus();
       return false; 
      }
       return true;
     }
    </script> <%
    sql = "select shengid,cityid,sheng,city from newcity order by cityid"
    set obj = conn.execute(sql)
    %> <script language = "JavaScript">
    var onecouant;
    onecouant=0;
    subcata = new Array();
            <%
            count1 = 0
            do while not obj.eof 
            %>
    subcata[<%=count1%>] = new Array("<%= trim(obj("City"))%>","<%= trim(obj("shengid"))%>","<%= trim(obj("cityid"))%>");
            <%
            count1 = count1 + 1
            obj.movenext
            loop
            obj.close
            set obj=nothing
            %>
    onecouant=<%=count1%>;function changelocation3(id)
        {
        document.f1.city.length = 0;     var id=id;
        var i;
        document.f1.city.options[0] = new Option('----------请选择城市---------','');
        for (i=0;i < onecouant; i++)
            {
                if (subcata[i][1] == id)
                { 
                    document.f1.city.options[document.f1.city.length] = new Option(subcata[i][0], subcata[i][2]);
                }        
            }
            
        }     
    </script></td>
                  </tr>
                </table>
                <form name="f1" method="post" action="newEnterprise/AllSearch.asp" onsubmit="return cc(f1)">
                  <table width="400" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
                
                    
                    <tr bgcolor="e6e6e6"> 
                      <td width="101" height="35" align="center"><strong>选择省份</strong></td>
                      <td width="349" height="35"><select name="sheng" onChange="changelocation3(document.f1.sheng.options[document.f1.sheng.selectedIndex].value)" size="1">
                          <option value="" selected>----------请选择省份---------</option>
                          <%
            sql1 = "select shengid,sheng from newsheng order by Shengid"
            set obj1 = conn.Execute (sql1)
            do while not obj1.eof
            %>
                          <option value="<%=trim(obj1("Shengid"))%>"><%=trim(obj1("Sheng"))%></option>
                          <%
            obj1.movenext
            loop
            obj1.close
            set obj1 = nothing
            
            %>
                        </select></td>
                    </tr>
                    <tr bgcolor="e6e6e6"> 
                      <td width="101" height="35" align="center"><strong>地区(市)</strong></td>
                      <td width="349" height="35"><select name="city" size="1">
                          <option value="" selected>------请选择城市------</option>
                        </select></td>
                    </tr>
                    <script LANGUAGE="JavaScript">
        changelocation3(document.f1.sheng.options[document.f1.sheng.selectedIndex].value); 
    </script>
                    <tr bgcolor="e6e6e6"> 
                      <td width="101" height="33" align="center"><strong>行业大类</strong></td>
                      <td width="349" height="33"><% 
    sql = "select bigid,middleid,middletypes from newmiddle order by middleid" 
    set rs = conn.execute(sql) 
    %> <script language = "JavaScript"> 
    var onecount; 
    onecount=0; 
    subcat = new Array(); 
    <% 
    count = 0 
    do while not rs.eof 
    %> 
    subcat[<%=count%>] = new Array("<%= trim(rs("middletypes"))%>","<%= trim(rs("bigid"))%>","<%= trim(rs("middleid"))%>"); 
    <% 
    count = count + 1 
    rs.movenext 
    loop 
    rs.close 
    set rs=nothing 
    %> 
    onecount=<%=count%>; function changelocation(locationid) 

    document.f1.middletypes.length = 0; var locationid=locationid; 
    var i; 
    document.f1.middletypes.options[0] = new Option('--中类行业--',''); 
    for (i=0;i < onecount; i++) 

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

    document.f1.middletypes.options[document.f1.middletypes.length] = new Option(subcat[i][0], subcat[i][2]); 

    } } 
    </script> <%sql2 = "select smalltypes,middleid,smallid from newsmall order by smallid" 
    set rs2 = conn.execute(sql2) 
    %> <script language = "JavaScript"> 
    var onecount2; 
    onecount2=0; 
    subcat2 = new Array(); 
    <% 
    count2 = 0 
    do while not rs2.eof 
    %> 
    subcat2[<%=count2%>] = new Array("<%= trim(rs2("smalltypes"))%>","<%= trim(rs2("middleid"))%>","<%= trim(rs2("smallid"))%>"); 
    <% 
    count2 = count2 + 1 
    rs2.movenext 
    loop 
    rs2.close 
    set rs2=nothing 
    %> 
    onecount2=<%=count2%>; function changelocation2(smalltypesid) 

    document.f1.smalltypes.length = 0; var smalltypesid=smalltypesid; 
    var j; 
    document.f1.smalltypes.options[0] = new Option('--小类行业--',''); 
    for (j=0;j < onecount2; j++) 

    if (subcat2[j][1] == smalltypesid) 

    document.f1.smalltypes.options[document.f1.smalltypes.length] = new Option(subcat2[j][0], subcat2[j][2]); 

    } } </script> <select name="bigtypes" onChange="changelocation(document.f1.bigtypes.options[document.f1.bigtypes.selectedIndex].value)" size="1">
                          <option selected value="">--------选择大类行业---------</option>
                          <% 
    sql1 = "select bigid,bigtypes from newbig order by bigid"
    set rs1 = conn.Execute (sql1) 
    do while not rs1.eof 
    %>
                          <option value="<%=trim(rs1("bigid"))%>"><%=trim(rs1("bigtypes"))%></option>
                          <% 
    rs1.movenext 
    loop 
    rs1.close 
    set rs1 = nothing 
     
          conn.close   
         set conn=nothing  
    %>
                        </select></td>
                    </tr>
                    <tr bgcolor="e6e6e6"> 
                      <td width="101" height="35" align="center"><strong>行业中类</strong></td>
                      <td width="349" height="35"><select name="middletypes" onChange="changelocation2(document.f1.middletypes.options[document.f1.middletypes.selectedIndex].value)">
                          <option value="" selected>--------选择中类行业---------</option>
                        </select></td>
                    </tr>
                    <tr bgcolor="e6e6e6"> 
                      <td width="101" height="35" align="center"><strong>行业小类</strong></td>
                      <td width="349" height="35"><select name="smalltypes" size="1">
                          <option value="" selected>--------选择小类行业---------</option>
                        </select></td>
                    </tr>
                    <tr bgcolor="e6e6e6"> 
                      <td width="101" height="35">  </td>
                      <td width="349" height="35"><input type="submit" name="Submit3" value=" 搜索 ">
                             <input type="reset" name="Submit5" value=" 重写 "></td>
                    </tr>
                  
                  
                  </table>
                </form>