1、初始化combobox控件
//生产厂家
$("#manufacturers").combobox({
//是否允许输入:允许输入时可以根据输入的内容进行自动查询
editable: true,
panelHeight: 'auto',
valueField: 'id',
textField: 'name',
//数据源查询路径
url: "${pageContext.request.contextPath}/mt/manufacturers/queryNameList",
//模糊匹配
//这里改成>=0即可在任意地方匹配
filter: function (q, row) {
var opts = $(this).combobox('options');
return row[opts.textField].indexOf(q) >= 0; }
});
2、数据查询方法(注意:返回List类型数据)
@ResponseBody
@RequestMapping("/queryNameList")
public List<Manufacturers> queryNameList(ManufacturersBean bean) {
List<Manufacturers> list = new ArrayList<Manufacturers>();
try {
list = manufacturersService.queryNameList(bean);
} catch (Exception e) {
log.error(message, e);
}
return list;
}
3、实现方法
@Override
public List<Manufacturers> queryNameList(ManufacturersBean bean) throws Exception {
StringBuffer hql = new StringBuffer("from Manufacturers o where o.status > 0 ");
StringBuffer params = new StringBuffer("");
if(StringUtils.isNotEmpty(bean.getKeyWords())){
params.append(" and (o.name like '%" + bean.getKeyWords() + "%')");
}
hql.append(params);
List<Manufacturers> rows = query(hql.toString());
return rows;
}