Easyui 实现智能模糊查询（智能检索）

<a href="https://s5.51cto.com/wyfs02/M01/9B/90/wKioL1lkhKTChPl4AACgfmL6kNA758.png-wh_500x0-wm_3-wmp_4-s_1896974579.png" target="_blank"></a>

<a href="https://s5.51cto.com/wyfs02/M02/9B/90/wKioL1lkhKXz0eY-AACkCQhGWic989.png-wh_500x0-wm_3-wmp_4-s_3698869973.png" target="_blank"></a>

js代码：

    &lt;input id="proBidSectionone" name="proBidSectionone" value=""&gt;

重点：

//工作标段模糊查询

 $("#proBidSectionone").combobox({  

      valueField: 'uid',  

      textField: 'paramName',  

      url: path+'/admin/dispatcher/searchParam.do',  

      mode: 'remote', //从服务器加载就设置为'remote'

      hasDownArrow: false,  //为true时显示下拉选项图标

      onBeforeLoad: function (parm) {  //在请求加载数据之前触发，返回 false 则取消加载动作         

      var  value = $(this).combobox('getValue');  

      if (value) {  

            parm.paramType = 5;

            parm.paramName = value;

            return true;  

       }  

          return false;  

       },

       onSelect: function(row){    //当用户选择一个列表项时触发。

            //这样赋值便于取值（否则该字段为空）

            document.getElementById("proBidSectionone").value= row.uid;

        }

  })

后代代码：

控制层：

@Controller

@RequestMapping("/admin/dispatcher")

public class DispatcherController extends BaseController{

    @Resource

    private DispatchParamService dispatchParamService;

    private Map&lt;String, Object&gt; params;

    @RequestMapping("searchParam.do")

    @ResponseBody

   public List&lt;DispatchParam&gt; paramList(HttpServletRequest req, String paramName, String paramType){

        params = new HashMap&lt;&gt;();

        params.put("paramType", paramType);

        params.put("paramnametest", paramName);

        List&lt;DispatchParam&gt; list = dispatchParamService.findByMap(params);

        return list;

    }

}

model层:

package com.shangyu.entity.dsz;

public class DispatchParam{

    private String uid;

    private Integer paramType;

    private String paramName;

    public String getUid() {

        return uid;

    public void setUid(String uid) {

        this.uid = uid == null ? null : uid.trim();

    public Integer getParamType() {

        return paramType;

    public void setParamType(Integer paramType) {

        this.paramType = paramType;

    public String getParamName() {

        return paramName;

    public void setParamName(String paramName) {

        this.paramName = paramName == null ? null : paramName.trim();

mapper.xml：

  &lt;select id="findByMap" parameterType="java.util.Map" resultMap="BaseResultMap"&gt;

      select

      &lt;include refid="Base_Column_List"/&gt;

      from yl_pb_dispatch_param

    &lt;trim prefix="where" prefixOverrides="and"&gt;

          &lt;if test="paramType != null"&gt;

              and param_type = #{paramType}

          &lt;/if&gt;

          &lt;if test="paramnametest != null"&gt;

              and param_name like concat('%',#{paramnametest},'%')

      &lt;/trim&gt;

  &lt;/select&gt;

本文转自 沉淀人生 51CTO博客，原文链接:http://blog.51cto.com/825272560/1946371