Java:创建一个方法用来保存主要的方法
public void SelectSizeGroup(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
ISizeGroupDao IS = new SizeGroupImp();
List<SizeGroup>listReg =IS.funilAll();
List<SelectVo> listSelect =new ArrayList<SelectVo>();
SelectVo select = new SelectVo(0,"--------请选择----------");
listSelect.add(select);
for (SizeGroup reg : listReg) {
select = new SelectVo(reg.getSizeGroupID(), reg.getSize());
listSelect.add(select);
}
JsonArr(req,resp,listSelect);
}
//返回JSON数据 需要用到几个jar包-- commons-beanutils-1.9.2.jar ,commons-collections-3.2.1.jar ,commons-lang-2.4.jar ,commons-logging-1.1.1.jar ,
ezmorph-1.0.6.jar ,json-lib-2.4-jdk15.jar
public void JsonArr(HttpServletRequest req, HttpServletResponse resp,List<SelectVo>L) throws ServletException, IOException{
JSONArray Jsonobject=JSONArray.fromObject(L);
resp.getWriter().print(Jsonobject);
resp.getWriter().close();
}
SizeGroup 为一个类,private XXX …… 为数据库中表格的字段,其他的方法都是围绕这些字段的操作的方法
public class SizeGroup {
private int SizeGroupID;
private String Size;
public SizeGroup() {
super();
// TODO Auto-generated constructor stub
}
public SizeGroup(int sizeGroupID, String size) {
super();
SizeGroupID = sizeGroupID;
Size = size;
}
public int getSizeGroupID() {
return SizeGroupID;
}
public void setSizeGroupID(int sizeGroupID) {
SizeGroupID = sizeGroupID;
}
public String getSize() {
return Size;
}
public void setSize(String size) {
Size = size;
}
}
SeletVo为下拉框的一个类,写法基本固定
public class SelectVo {
private int id;
private String text;
public SelectVo(int id, String text) {
super();
this.id = id;
this.text = text;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getText() {
return text;
}
public void setText(String text) {
this.text = text;
}
}
JavaQuery:
var jsonData=JSON.parse(returnJson);把后台返回的封装成一个Object对象
function createSelect(selectId, url, value) {
$.post(url, function (returnJson) {
var jsonData=JSON.parse(returnJson);
if (selectId.indexOf('#') != 0) {
selectId = '#' + selectId;
}
$(selectId).empty();//清空该元素
//创建option
for (k in jsonData) {
$(selectId).append('<option value="' + jsonData[k].id + '">' + jsonData[k].text + '</option>');
}
//设置选中值
if (value != undefined && value != null && value != '') {
$(selectId).val(value);
}
});
}
接下来在JQuery方面调用这个方法即可
例如:createSelect(“RegNum”, “${ctx}/Main?fun=SelectCoding”); createSelect(id,路径);