[JSP] jsp从数据库获取数据填充下拉框实现二级联动菜单的方法

<s:select listKey="tsFrom" id="t_tsfrom" cssClass="required" 
listValue="tsFrom" cssStyle="width:90" list="tsfrom1" 
name="tsFrom" theme="simple" headerKey="" 
onchange="getTsFromDescribe(this);" headerValue="--请选择--" />

@Autowired 
private CustomMaManager custommamanager;//注解相当的好用啊，代码都省了一大截 
tsfrom1 = custommamanager.getTsFrom();

//得到投诉来源 
public List<CustomManage> getTsFrom(){ 
  return custommanagedao.getTsFrom(); 
}

/**得到产品类型**/ 
public List<CustomManage> getTsFrom(){ 
  return this.find("SELECT distinct new CustomManage(tsFrom,'2') FROM CustomManage C WHERE C.tsFrom IS NOT NULL ORDER BY tsFrom ASC");
}

SELECT distinct new CustomManage(tsFrom,'2') FROM CustomManage C WHERE C.tsFrom IS NOT NULL ORDER BY tsFrom ASC

public CustomManage(String khname,int s){ 
  this.khname=khname; 
} 
public CustomManage(String cpname,String type){ 
  if("1".equals(type)){ 
   this.cpname=cpname; 
  }else if("2".equals(type)){ 
   this.tsFrom=cpname; 
  }else if("3".equals(type)){ 
   this.khname=cpname; 
  } 
}

//投诉信息来源信息级联 
function getTsFromDescribe(ts_describe){ 
 var tsfrom = $("#t_tsfrom").val(); 
 var tstsFrom = $("#ts_tsFrom").val(); 
 Ext.Ajax.request( { 
  url : '${ctx}/complaints/complaints!getTsFrom.action', 
  params : { 
   tsfrom : tsfrom//通过json形式将前台每次获取到的值传递给后台 
  }, 
  success : function(response) { 
   var json = Ext.util.JSON.decode(response.responseText); 
   if (json.success) { 
  var data = json.<strong>cmList</strong>; 
  if ("" == data) { 
   alert("请选择投诉类型"); 
   inputForm.t_tsfrom.focus(); 
   $("#ts_tsFrom").empty();//每次需要将上一次的数据进行清空 
  } else { 
   $("#ts_tsFrom").empty(); 
   //对获取到的数据进行迭代 
  for ( var i = 0; i < data.length; i++) { 
   var id = data[i]; 
   var name = data[i]; 
   $("#ts_tsFrom").append( 
     "<option value='" + id + "'>" + name + "</option>"); 
  } 
  dwr.util.removeAllOptions('tstsFrom'); 
  dwr.util.addOptions('tstsFrom', data); 
 } 
} 
} 
}); 
}

public void getTsFrom() throws Exception { 
  HttpServletResponse response = ServletActionContext.getResponse(); 
  String ts_names = tsfrom; 
  List<CustomManage> list = complaintsmanager.getTsDescribe(ts_names); 
  response.setContentType("text/javascript"); // 后台控制的代码 
  PrintWriter writer = response.getWriter(); 
  // 将得到的list集合转为JSON对象传给前台处理 
  JSONArray j = JSONArray.fromObject(list); 
  writer.println("{'success':true,'<strong>cmList</strong>':" + j.toString() + "}"); 
}

var op1 = document.getElementById("op1").value; 
if(op1!=null){ 
  $("#cp_validity").val(op1); //将取出来的值塞到下拉框中。一个萝卜一个坑 
} 
<input type="hidden" id="op1" value="${compDisposal.validity}">//使用表达式将存在数据库里的值取出来，放在隐藏域里面