改变一个下拉框的内容，让另一个下拉框动态从数据库提取数据？

续：
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>工作日历</title>
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr valign="top"> 
    <td colspan="2" height="0"> 
      <jsp:include page="logo.htm"/>
    </td>
  </tr>
  <tr> 
    <td valign="top" width="52" background="image/jcbj-1.jpg"> 
      <jsp:include page="leftmanu.htm"/>
    </td>
    <td  style="BACKGROUND-ATTACHMENT: fixed; BACKGROUND-IMAGE:    url(image/page.jpg); 
  BACKGROUND-POSITION: 100% 0%; BACKGROUND-REPEAT: no-repeat" valign="top"> 
      <br>
      <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
        <tr> 
          <td class="p4" height="35" width="35"> </td>
          <td class="p4" height="35" background="image/titleb.jpg" width="250" valign="middle"> 
            <div align="center"><strong>工作日历</strong> </div>
            </td>
          <td class="p4" height="35">&nbsp;</td>
        </tr>
      </table>
      <br>
      <form name="form1" method="post" action="base_workcalender_save.jsp">
        <br>
        <table width="700" border="1" align="center" cellspacing="1" bordercolor="#33CCFF">
          <tr> 
            <td width="17%" class="p2"> <div align="right">部门：</div></td>
            <td width="16%" class="p2"><select name="c_dep" id="c_dep" onChange="fun_find(this.form)" >
     <option ></option>
    <% while (rs1.next()){
                     String dep=new String();
                     dep=charConvert.AsciiToChineseString(rs1.getString("c_dep")); 
%>
<option value="<%=dep %>"><%=dep %></option>
                <% } %>
                </select> </td>
            <td width="67%" class="p2"> <div align="left">员工姓名： 
                <select name="c_name" id="c_name">
                </select>

                <font color="#FFCC33">(请先选择员工所在的部门)</font></div></td>
          </tr>
          <tr> 
            <td class="p2"> <div align="right">日期：</div></td>
            <td colspan="2" class="p2"> <select name="c_year" id="c_year" >
                <option> </option>
                <option value="2000">2000</option>
                <option value="2001">2001</option>
                <option value="2002">2002</option>
                <option value="2003">2003</option>
                <option value="2004">2004</option>
                <option value="2005">2005</option>
                <option value="2006">2006</option>
                <option value="2007">2007</option>
                <option value="2008">2008</option>
                <option value="2009">2009</option>
                <option value="2010">2010</option>
                <option selected><%=year %></option>
              </select>
              年 
              <select name="c_month" id="select2">
                <option> </option>
                <option>01</option>
                <option>02</option>
                <option>03</option>
                <option>04</option>
                <option>05</option>
                <option>06</option>
                <option>07</option>
                <option>08</option>
                <option>09</option>
                <option>10</option>
                <option>11</option>
                <option>12</option>
                <option selected><%=month %></option>
              </select>
              月 
              <select name="c_day" id="select3">
                <option> </option>
                <option>01</option>
                <option>02</option>
                <option>03</option>
                <option>04</option>
                <option>05</option>
                <option>06</option>
                <option>07</option>
                <option>08</option>
                <option>09</option>
                <option>10</option>
                <option>11</option>
                <option>12</option>
                <option>13</option>
                <option>14</option>
                <option>15</option>
                <option>16</option>
                <option>17</option>
                <option>18</option>
                <option>19</option>
                <option>20</option>
                <option>21</option>
                <option>22</option>
                <option>23</option>
                <option>24</option>
                <option>25</option>
                <option>26</option>
                <option>27</option>
                <option>28</option>
                <option>29</option>
                <option>30</option>
                <option>31</option>
                <option selected><%=day %></option>
              </select>
              日 </td>
          </tr>
          <tr> 
            <td class="p2"> <div align="right">序号：</div></td>
            <td colspan="2" class="p2"> <input name="c_serial" type="text" id="c_serial" size="20" maxlength="20" > 
            </td>
          </tr>
          <tr> 
            <td class="p2"> <div align="right">服务部门：</div></td>
            <td colspan="2" class="p2"><select name="c_serverdep" id="c_serverdep">
      <option ></option>
    <% rs1.absolute(1);%>
   <option ><%=charConvert.AsciiToChineseString(rs1.getString("c_dep"))%></option>
  <% while (rs1.next()){
                     String dep=new String();
                     dep=charConvert.AsciiToChineseString(rs1.getString("c_dep")); %>
                <option ><%=dep %></option>
                <% } %>
              </select></td>
          </tr>
          <tr> 
            <td class="p2"> <div align="right">客户名称：</div></td>
            <td colspan="2" class="p2"> <input name="c_customer" type="text" id="c_customer" size="20" maxlength="20" > 
            </td>
          </tr>
          <tr> 
            <td height="47" class="p2"> <div align="right">工作内容：</div></td>
            <td colspan="2" class="p2"> <textarea name="c_work" cols="50" rows="2" id="c_work"></textarea> 
            </td>
          </tr>
          <tr> 
            <td class="p2"> <div align="right">工作成果：</div></td>
            <td colspan="2" class="p2"> <textarea name="c_result" cols="50" rows="4" id="c_result"></textarea></td>
          </tr>
          <tr> 
            <td class="p2"> <div align="right">开销：</div></td>
            <td colspan="2" class="p2"> ￥ 
              <input name="c_spend" type="text" id="c_spend" size="10" maxlength="40"> 
            </td>
          </tr>
          <tr> 
            <td class="p2"> <div align="right">备注：</div></td>
            <td colspan="2" class="p2"> <textarea name="c_re" cols="50" rows="2" id="textarea"></textarea> 
              <font color="#FFCC33">(最多可输入50个汉字) </font></td>
          </tr>
        </table>
        <p align="center"> 
          <input type="submit" name="Submit" value="提交">
          <input type="reset" name="Submit2" value="重置">
        </p>
        <p align="center">&nbsp;</p>
      </form>
      <p align="center">&nbsp;</p> </td>
  </tr>
</table>
</body>
</html>

解决方案 »

  1.   

    你的问题大着呢。
    首先前边的javascript写的就不对，好多句子没有分号。
    用remove删除option，当remove(0)以后，下一条option(1)将
    自动变成option(0),所以始终使用remove(0)即可
      

  2.   

    我改过试了，还是不行。
    主要问题是在js中的  alert(c_name[i]);都不能执行
      

  3.   

    看看http://expert.csdn.net/Expert/top_expert/ExpertTopList.asp
      

  4.   

    我现在改为：在页面前面一次提取员工姓名，放在数组c_name[]，但在下拉框c_name中，竟然不能识别c_name[]变量。这是什么原因...<% 
     String dep2=new String();
     dep2=request.getParameter("term1");
     //out.println("dep:"+dep2);
     if (dep2 !=null){
    String sql2=new String();
        sql2="select * from com_humanbase where c_dep='"+dep2+"'";
    //out.println(sql2);
    ResultSet rs2=MysqlConn.executeQuery(sql2);
        int rowcount,i;
    rs2.last();
    rowcount=rs2.getRow();//结果集的总记录数
    out.println(rowcount);
    String[] c_name=new String[15];
      for (i=1;i<=rowcount;i++){
        if (rs2.absolute(i)){
           c_name[i]=charConvert.AsciiToChineseString(rs2.getString("c_name"));
       //out.println(c_name[i]);
     }
       }
      //rs2.close();
    }else{
    dep2="";
    } 
     %>
    <select name="c_name" id="c_name">

    <% 
     out.println(c_name[1]);
             %>
      <option ></option>
                    </select>运行提示：cannot resolve symbol   c_name[i]
      

  5.   

    //javaScript函数，用于实现备选参与人和部门选择的同步变化。
          function deptChange(){
    deptManArry=new Array();//定义一个保存所有参与人的数组
    joinManCount=0;          //存放参与人个数<%
          int joinCount=0;
          //docset.Open();
          personSet.Open();//打开所有记录
          while(personSet.Next()){
    String name="";
    String Armyman_id="";
    String dept_code="";
    name=personSet.GetPersonnel().getFullName();
    Armyman_id=String.valueOf(personSet.GetPersonnel().getPersonnelID());
    dept_code=String.valueOf(personSet.GetPersonnel().getDepartment().getDepartmentID());
    out.println("deptManArry"+"["+joinCount+"]"+"=new Array();"); //新建二维数组
    out.println("deptManArry"+"["+joinCount+"]"+"[0]"+"="+"'"+name+"'"+";"); //人员姓名
    out.println("deptManArry"+"["+joinCount+"]"+"[1]"+"="+Armyman_id+";"); //人员编号
    out.println("deptManArry"+"["+joinCount+"]"+"[2]"+"="+dept_code+";"); //部门编号
    joinCount++;
        }
        out.println("joinManCount="+joinCount+";"); //获得参与人个数
      %>    form.Armyman_id.length = 0; //重新选择的话，将两个LIST清空
        indexDept=form.Dept_id.selectedIndex; //被选择部门的索引号
        optionJoinNew=document.createElement("Option");
        optionJoinNew.text="(全部)";
        optionJoinNew.value="all";
        form.Armyman_id.add(optionJoinNew);
        for(joinCount=0;joinCount<joinManCount;joinCount++){ //判断是选择了哪个部门，或者是选择了"全部"。
          if(deptManArry[joinCount][2]==form.Dept_id.options[indexDept].value || form.Dept_id.options[indexDept].value=="depart"){
    optionJoinNew=document.createElement("Option"); //在备选参与人中添加一个符合规定的记录
    optionJoinNew.text=deptManArry[joinCount][0];
    optionJoinNew.value=deptManArry[joinCount][1];
    form.Armyman_id.add(optionJoinNew);
          }
        }
          }
      -->
    </script>
      

  6.   

    再页面不能实现：  只用了：
            <script language="JavaScript" type="text/javascript">
            optionJoinNew=document.createElement("Option"); //在备选参与人中添加一个符合规定的记录
    optionJoinNew.text="所有";
    optionJoinNew.value="all";
    form.Armyman_id.add(optionJoinNew);
             </script>都不能显示？？？帮忙....
      

  7.   

    解决方法是一位高人提供的代码，忘记谁了
    下面是我得页面代码：
    <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
    <jsp:useBean id="MysqlConn" scope="page" class="DBFuction.MysqlConn" />
    <jsp:useBean id="charConvert" scope="page" class="DBFuction.Convert" />
    <%
    int year,month,day;
    String month1,day1;
    java.util.Date dt = new java.util.Date();
    year=dt.getYear()+1900;
    month=dt.getMonth()+1;
    day=dt.getDate();
    month1=Integer.toString(month);
    if (month1.length() == 1) 
       month1="0" + month1;
    day1=Integer.toString(day);
    if (day1.length() == 1)
       day1="0" + day1;
     %>  <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    <title>工作日历</title>
    <link rel="stylesheet" href="css.css" type="text/css">
    </head>
    <script language="javascript">
       //数据联动
       function addOption(Des,oText,oValue){
             var oOption = document.createElement("Option");
                     oOption.text=oText;
                     oOption.value=oValue;
                     document.all(Des).add(oOption);
               }
               function DelOption(Des){
             j=document.all(Des).length;
                     while(j>0){
                        document.all(Des).remove(j-1);
                        j--;
                     }
       }
               
               function change(parentstr,curstr){   //parentstr,curstr 父类 子类
                 if( document.all("c_"+parentstr).value!=""){
                 //子类
                DelOption("c_"+curstr);
                str=document.all("hid_"+curstr).value ;
                var ss;
                ss=str.split("^");
                addOption("c_"+curstr,"-请选择-","");
                for(i=0;i<ss.length;i++){
                           tmpstr=ss[i].split("~");
                           if (tmpstr[1]== document.all("c_"+parentstr).value){ 
                               addOption("c_"+curstr,tmpstr[2],tmpstr[0]);
                           }
                        }
           }
                }
       function sel_dep_onchange(){     //客户类别的变动引起客户小类的变化
            change("dep","name");
           
       }   
    </script>

    <%  
        //DBService dbs=new DBService(SysConfig.DBYW );
     
        String strOptionkhlb="",strOptionkhxl="";
        String strOptionlb="",strOptionxl="",strOptionxm="",strOptionly="",strOptionqy="",strOptionjb="";
       
        String strHidkhxl="",strHidlb="",strHidxl="",strHidxm="";
        String tmpstr;
        try{
          
          String strCondition;
          ResultSet rs;
         
          //部门  dep
          strCondition="select distinct c_dep from com_humanbase";
          rs=MysqlConn.executeQuery(strCondition);
          while(rs.next() ){
             strOptionkhlb=strOptionkhlb+"<option value='"+charConvert.AsciiToChineseString(rs.getString("c_dep"))+"'>"+charConvert.AsciiToChineseString(rs.getString("c_dep"))+"</option>";
      }
          
          //员工  name
      strCondition="select c_name,c_dep from com_humanbase";
          rs=MysqlConn.executeQuery(strCondition);
          while(rs.next() ){
             tmpstr=charConvert.AsciiToChineseString(rs.getString("c_name"))+"~"+charConvert.AsciiToChineseString(rs.getString("c_dep"))+"~"+charConvert.AsciiToChineseString(rs.getString("c_name"));
             strHidkhxl=strHidkhxl+tmpstr+"^";
             strOptionkhxl=strOptionkhxl+"<option value='"+charConvert.AsciiToChineseString(rs.getString("c_name"))+"'>"+charConvert.AsciiToChineseString(rs.getString("c_name"))+"</option>";
          }
       
         
        }catch(Exception e){
          out.println(e.toString() +"<br/>" ) ;
        }finally{
          // rs1.close();
           MysqlConn.CloseConn();
        }
       %>
      

  8.   

    续：
    <body bgcolor="#FFFFFF" leftmargin="0" topmargin="0">
    <table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr valign="top"> 
        <td colspan="2" height="0"> 
          <jsp:include page="logo.htm"/>
        </td>
      </tr>
      <tr> 
        <td valign="top" width="52" background="image/jcbj-1.jpg"> 
          <jsp:include page="leftmanu.htm"/>
        </td>
        <td  style="BACKGROUND-ATTACHMENT: fixed; BACKGROUND-IMAGE:    url(image/page.jpg); 
      BACKGROUND-POSITION: 100% 0%; BACKGROUND-REPEAT: no-repeat" valign="top"> 
          <br>
          <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
            <tr> 
              <td class="p4" height="35" width="35"> </td>
              <td class="p4" height="35" background="image/titleb.jpg" width="250" valign="middle"> 
                <div align="center"><strong>工作日历</strong> </div>
                </td>
              <td class="p4" height="35">&nbsp;</td>
            </tr>
          </table>
          <br>
          <form name="form1" method="post" action="base_workcalender_save.jsp">
            <br>
            <table width="700" border="1" align="center" cellspacing="1" bordercolor="#33CCFF">
              <tr> 
                <td width="17%" class="p2"> <div align="right">部门：</div></td>
                <td width="16%" class="p2"><select name="c_dep" id="c_dep" onChange="return sel_dep_onchange()" >
         <option>-请选择-</option>
                   <% out.println (strOptionkhlb);%>
                    </select> </td>
                <td width="67%" class="p2"> <div align="left">员工姓名： 
                    <select name="c_name" id="c_name">
    <option>-请选择-</option>
                    </select>

                    <font color="#FFCC33">(请先选择员工所在的部门)</font></div></td>
              </tr>
      <tr>
      <input type="hidden" name="hid_name" value="<%out.println(strHidkhxl);%>">
      </tr>
              <tr> 
                <td class="p2"> <div align="right">日期：</div></td>
                <td colspan="2" class="p2"> <select name="c_year" id="c_year" >
                    <option> </option>
                    <option value="2000">2000</option>
                    <option value="2001">2001</option>
                    <option value="2002">2002</option>
                    <option value="2003">2003</option>
                    <option value="2004">2004</option>
                    <option value="2005">2005</option>
                    <option value="2006">2006</option>
                    <option value="2007">2007</option>
                    <option value="2008">2008</option>
                    <option value="2009">2009</option>
                    <option value="2010">2010</option>
                    <option selected><%=year %></option>
                  </select>
                  年 
                  <select name="c_month" id="select2">
                    <option> </option>
                    <option>01</option>
                    <option>02</option>
                    <option>03</option>
                    <option>04</option>
                    <option>05</option>
                    <option>06</option>
                    <option>07</option>
                    <option>08</option>
                    <option>09</option>
                    <option>10</option>
                    <option>11</option>
                    <option>12</option>
                    <option selected><%=month %></option>
                  </select>
                  月 
                  <select name="c_day" id="select3">
                    <option> </option>
                    <option>01</option>
                    <option>02</option>
                    <option>03</option>
                    <option>04</option>
                    <option>05</option>
                    <option>06</option>
                    <option>07</option>
                    <option>08</option>
                    <option>09</option>
                    <option>10</option>
                    <option>11</option>
                    <option>12</option>
                    <option>13</option>
                    <option>14</option>
                    <option>15</option>
                    <option>16</option>
                    <option>17</option>
                    <option>18</option>
                    <option>19</option>
                    <option>20</option>
                    <option>21</option>
                    <option>22</option>
                    <option>23</option>
                    <option>24</option>
                    <option>25</option>
                    <option>26</option>
                    <option>27</option>
                    <option>28</option>
                    <option>29</option>
                    <option>30</option>
                    <option>31</option>
                    <option selected><%=day %></option>
                  </select>
                  日 </td>
              </tr>
              <tr> 
                <td class="p2"> <div align="right">序号：</div></td>
                <td colspan="2" class="p2"> <input name="c_serial" type="text" id="c_serial" size="20" maxlength="20" > 
                </td>
              </tr>
              <tr> 
                <td class="p2"> <div align="right">服务部门：</div></td>
                <td colspan="2" class="p2"><select name="c_serverdep" id="c_serverdep">
          <option>-请选择-</option>
          <% out.println (strOptionkhlb);%>
                  </select></td>
              </tr>
              <tr> 
                <td class="p2"> <div align="right">客户名称：</div></td>
                <td colspan="2" class="p2"> <input name="c_customer" type="text" id="c_customer" size="20" maxlength="20" > 
                </td>
              </tr>
              <tr> 
                <td height="47" class="p2"> <div align="right">工作内容：</div></td>
                <td colspan="2" class="p2"> <textarea name="c_work" cols="50" rows="2" id="c_work"></textarea> 
                </td>
              </tr>
              <tr> 
                <td class="p2"> <div align="right">工作成果：</div></td>
                <td colspan="2" class="p2"> <textarea name="c_result" cols="50" rows="4" id="c_result"></textarea></td>
              </tr>
              <tr> 
                <td class="p2"> <div align="right">开销：</div></td>
                <td colspan="2" class="p2"> <font size="4">￥</font> 
                  <input name="c_spend" type="text" id="c_spend" size="10" maxlength="40"> 
                </td>
              </tr>
              <tr> 
                <td class="p2"> <div align="right">备注：</div></td>
                <td colspan="2" class="p2"> <textarea name="c_re" cols="50" rows="2" id="textarea"></textarea> 
                  <font color="#FFCC33">(最多可输入50个汉字) </font></td>
              </tr>
            </table>
            <p align="center"> 
              <input type="submit" name="Submit" value="提交">
              <input type="reset" name="Submit2" value="重置">
            </p>
            <p align="center">&nbsp;</p>
          </form>
          <p align="center">&nbsp;</p> </td>
      </tr>
      <%
      //rs1.close();
      MysqlConn.CloseConn();
        %>
    </table>
    </body>
    </html>