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