[未解决] SSM+Layuimini在表格重载多个属性进行查询时，出现了后台可以查询，传参正常，无法查询的BUG

html

 <fieldset class="table-search-fieldset">
            <legend>搜索信息</legend>
            <div style="margin: 10px 10px 10px 10px">
                <form class="layui-form layui-form-pane" action="">
                    <div class="layui-form-item">
                        <div class="layui-inline">
                            <label class="layui-form-label">用户姓名</label>
                            <div class="layui-input-inline">
                                <input type="text" id="username" name="username" autocomplete="off" class="layui-input">
                            </div>
                        </div>
                        <div class="layui-inline">
                            <label class="layui-form-label required">性别</label>
                            <div class="layui-input-block">
                                <select id="gender" name="gender" >
                                    <option value="">请选择您的性别</option>
                                    <option value="男">男</option>
                                    <option value="女">女</option>
                                </select>
                            </div>
                        </div>
                        <div class="layui-inline">
                            <label class="layui-form-label">用户编号</label>
                            <div class="layui-input-inline">
                                <input type="text" id="userCode" name="userCode" autocomplete="off" class="layui-input">
                            </div>
                        </div>
                        <div class="layui-inline">
                            <label class="layui-form-label required">用户职位</label>
                            <div class="layui-input-block">
                                <select id="rid" name="rid">
                                    <option value="">请选择一个用户职位</option>
                                    <option value="1">管理员</option>
                                    <option value="2">开发者</option>
                                    <option value="3">检验员</option>
                                    <option value="4">安管员</option>
                                    <option value="5">维修人员</option>
                                    <option value="6">场车管理员</option>
                                </select>
                            </div>
                        </div>
                        <div class="layui-inline">
                            <button type="submit" class="layui-btn layui-btn-primary"  lay-submit lay-filter="data-search-btn"><i class="layui-icon"></i> 搜 索</button>
                        </div>
                    </div>
                </form>
            </div>
 </fieldset>

　　　　

js

 //执行搜索重载
            table.reload('currentTableId', {
                page: {
                curr: 1,
            },
                where: {
                    username: username1,
                    gender: gender1,
                    userCode: userCode,
                    rid: rid
                }
            });
            return false;

controller

@RequestMapping("/getLikeUser")
    @ResponseBody
    public Map getLikeUser(@RequestParam int page,@RequestParam("limit") int pageSize,
                           @RequestParam Map<String,Object> map){

        page = (page-1)*pageSize;
        map.put("page",page);
        map.put("pageSize",pageSize);
        System.out.println(map);
        List<User> userList = userService.getLikeUser(map);
        System.out.println(userList.toString());
        //对LayuiJson要求封装
        Map newMap = layuiJsonUtils.getJson(userList);
        return newMap;
    }

mapper

<select id="getLikeUser" resultMap="userRoleName" parameterType="Map">
        select u.*,r.roleName from fact_user u
        inner join fact_role r
        on u.rid = r.id
        <where>
            <if test="username != null and username != '' ">
                 username like "%"#{username}"%"
            </if>
            <if test="gender != null ">
                and gender like "%"#{gender}"%"
            </if>
            <if test="userCode != null and userCode != '' ">
                and userCode like "%"#{userCode}"%"
            </if>
            <if test="rid != null">
                and rid like "%"#{rid}"%"
            </if>
        </where>
        order by u.create_time desc
        limit #{page},#{pageSize}
    </select>

 

需要模糊查询的字段为username和userCode，而gender和rid则不需要模糊查询

最终通过全部修改为模糊查询才能够查询成功。

gender和rid为下拉框属性，理论上选择后是固定属性，不需要模糊查询，百思不得其解。。。。。。