不好意思,出差刚回来。楼上老兄让您久等了。代码:<%
   
  
   Statement stmt1 = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
 
    String strOptionkhlb="",strOptionkhxl="";
    String strOptionlb="",strOptionxl="",strOptionxm="",strOptionly="",strOptionqy="",strOptionjb="";
   
    String strHidkhxl="",strHidlb="",strHidxl="",strHidxm="";
    String depart_id="";
    
    String depart_name = "";
    String city_code="";
    String tmpstr="";
    try{
      
      String strCondition;
      ResultSet rs1;
      
      
     
      //城市类别  cc_dictusertype
      strCondition="select CityCode,name from tp_city  ";
      rs1=stmt1.executeQuery(strCondition);
      while(rs1.next() ){
         city_code= rs1.getString("CityCode");
         if(sel_khlb!=null){
         if(city_code.equals(sel_khlb)){         
         strOptionkhlb=strOptionkhlb+"<option selected value='"+rs1.getString("CityCode")+"'>"+rs1.getString("name")+"</option>";
         }
         else{
         strOptionkhlb=strOptionkhlb+"<option value='"+rs1.getString("CityCode")+"'>"+rs1.getString("name")+"</option>";
         }
         }
         else{
         strOptionkhlb=strOptionkhlb+"<option value='"+rs1.getString("CityCode")+"'>"+rs1.getString("name")+"</option>";
         }
         
      }
      
      //客户小类  cc_dictusertype2
      String s_dept ="SELECT * from tp_depart   ";
      rs1=stmt1.executeQuery(s_dept);
      while(rs1.next()){ 
            depart_id = rs1.getString("depart_id");        
           
    depart_name = rs1.getString("depart_name");
    city_code=rs1.getString("city_code");
    tmpstr=city_code+"~"+ depart_id+"~"+depart_name;
    out.println(tmpstr);
    strHidkhxl=strHidkhxl+tmpstr+"^";
    if(sel_khxl!=null){
    if(sel_khxl.equals(depart_id)){
    strOptionkhxl=strOptionkhxl+"<option selected value='"+depart_id+"'>"+depart_name+"</option>";}
    else
    {strOptionkhxl=strOptionkhxl+"<option value='"+depart_id+"'>"+depart_name+"</option>";}
            }
            else{
            strOptionkhxl=strOptionkhxl+"<option value='"+depart_id+"'>"+depart_name+"</option>";}
            
            
     }
   
     
    }catch(Exception e){
     // out.println("ghjhgjhgh" ) ;
      out.println(e.toString() +"<br/>" ) ;
    }finally{
      con.close() ;
    }
    
%>  <table width="100%" border="0">
    <tr> 
      <td width="5%"> 城区: </td>
  <td width="19%"> 
        <select name="sel_khlb" " class="biaoti2" LANGUAGE=javascript onchange="return sel_khlb_onchange()">
          <option>-请选择-</option>
          <% out.println (strOptionkhlb);%>
        </select>
      </td>
      <td width="22%"> 部门: 
        <select name="sel_khxl" " class="biaoti2">
          <option>-请选择-</option>
          <% out.println (strOptionkhxl);%>
        </select>
        <input type="hidden" name="hid_khxl" value="<%out.println(strHidkhxl);%>">
        
      </td>
      <td width="26%"> 生成时间: 
        <select name="startYear" size="1">
        
          <%
                 
                 if(startYear!=null)
                 {
                 for ( i=2000; i<=2030; i++) {
                 out.println(getoption.getoption(String.valueOf(i),startYear));
                   }
                 }
                 else{
                   out.println("<option>-请选择-</option>");
                 for ( i=2000; i<=2030; i++) {
                
                 out.println(getoption.getoption2(String.valueOf(i),"2000"));
                    }
                  
                 }
               %>
        </select>
        年 </td>
      <td width="28%"> 
        <select name="StartMonth" size="1">
        
          <%
                
                 if(startMonth!=null)
                 {
                 for ( i=1; i<=12; i++) {
                 out.println(getoption.getoption(String.valueOf(i),startMonth));
                   }
                 }
                 else{
                 out.println("<option>-请选择-</option>");
                 for ( i=1; i<=12; i++) {
                 
                 out.println(getoption.getoption2(String.valueOf(i),"01"  ));
                    }
                 }
               
               %>
        </select>
        月 </td>
    </tr>
    <tr> 
      <td width="5%">卡号:</td>
      <td colspan="4"> 
      <%if(card!=null){%>
        <input type="text" name="card_id" maxlength="16" value=<%=card%>>
        <%}else {%>
        <input type="text" name="card_id" maxlength="16">
        <%}%>
      </td>
    </tr>
    <tr align="right" bgcolor="#FFFFFF" > 
      <td height="24" colspan="5" nowrap class="biaoti1" background="../image/bg/image_11.gif"> 
        <div align="right"> 
          <input type="image" name="submit" src="../image/confirm.gif"  border="0">
        </div>
      </td>
    </tr>
  </table>