easyui-combobox根据数据库查询绑定数据,如下:
1、html
<select id="st_cmpy" editable="false" class="easyui-combobox" name="compyId" data-options="label:'公司:'"></select>
2、JS:绑定查询:
//下拉框值加载
$("#st_cmpy").combobox({
url: basePath+'/compy/getCompyNameList',
method : "post",
valueField: 'value',
textField: 'text',
selected: 'selected'
});
3、后台Controller,返回Json格式数据
// 查询公司名称列表
@PostMapping("/getCompyNameList")
@ResponseBody
public List<ComboBoxUtils> getCompyNameList() {
List<ComboBoxUtils> dataList = heiniuCompyService.getCompyNameList();
return dataList;
}
4、Service实现:(设置selected属性,默认第一个选中)
@Override
public List<ComboBoxUtils> getCompyNameList() {
List<ComboBoxUtils> list = new ArrayList<ComboBoxUtils>();
try {
List<Compy> result = compyDao.selectCompanyNameList();
if (result != null && result.size() > 0) {
boolean selected = false;
for (int i = 0; i < result.size(); i++) {
Compy obj = result.get(i);
String value = obj.getCompyId();
String text = obj.getCompyName();
if (i == 0) {
selected = true;
} else {
selected = false;
}
ComboBoxUtils item = new ComboBoxUtils(i + "", value, text, selected);
list.add(item);
}
}
} catch (Exception e) {
e.printStackTrace();
}
return list;
}
5、ComboBoxUtils下拉框工具类:
/**
* @ClassName: ComboBoxUtils
* @Description: easyui下拉框工具类
* @author sam
* @date 2018年9月24日 下午12:59:55
*/
public class ComboBoxUtils {
private String id;
private String value;
private String text;
private boolean selected;
public ComboBoxUtils(String id, String value, String text) {
super();
this.id = id;
this.value = value;
this.text = text;
}
public ComboBoxUtils(String id, String value, String text, boolean selected) {
super();
this.id = id;
this.value = value;
this.text = text;
this.selected = selected;
}
public ComboBoxUtils() {
super();
// TODO Auto-generated constructor stub
}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getValue() {
return value;
}
public void setValue(String value) {
this.value = value;
}
public String getText() {
return text;
}
public void setText(String text) {
this.text = text;
}
public boolean isSelected() {
return selected;
}
public void setSelected(boolean selected) {
this.selected = selected;
}
}
数据库查询省略,主要配置完成!