对同一字段的复选框，模糊查询_表单复选框模糊搜索-优快云博客

本文链接：https://blog.youkuaiyun.com/zs391077005/article/details/103667493

本文详细介绍了如何在前端使用隐藏框记录信息，并通过JavaScript将数据发送到后端。后端采用Java处理请求，利用Spring框架进行参数接收，再通过MyBatis实现数据库查询。文章还展示了如何在控制器中接收并处理这些数据，最后将处理结果反馈给前端。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

效果：

首先加入隐藏框记录信息

<div class="form-inline mr20">
                        <label class="inline-block w88">
                            <span class="normal" >维度</span>
                        </label>
                        <input name="need_dimension" id="need_dimension" title="" class="w150" type="hidden" placeholder="">
                        <select name="need_dimension_select" id="need_dimension_select" class="selectpicker show-tick form-control select2 select2-drop-mask"  multiple="multiple"  >
                        </select>
                    </div>

然后把消息在js里传出去：

var need_dimension = $("#need_dimension").val();
    var need_index = $("#need_index").val();
    $.ajax({
        type: "POST",
        url: "/base_service/ar_monitor_out_log/need_dimension/ajax",
        data: 'need_dimension='+need_dimension + '&need_index='+need_index,
        success: function (data) {
        }
    });

controller接收：

    @RequestMapping(value = "/ar_monitor_out_log/need_dimension/ajax", method = RequestMethod.POST)
    public void get_dimension(RerunOutLogInfo obj, HttpServletResponse response, HttpServletRequest request) {
        String need_dimension = request.getParameter("need_dimension");
        String need_index = request.getParameter("need_index");

        this.need_dimension_sql = need_dimension;
        this.need_index_sql = need_index;

        JsonUtil<RerunOutLogInfo> jsonUtil = new JsonUtil<RerunOutLogInfo>();
        jsonUtil.writeResponse(response, Boolean.TRUE.toString());
    }
    String need_dimension_sql;
    String need_index_sql;

传给列表查询：

    @RequestMapping(value = "/ar_monitor_out_log/list/ajax", method = RequestMethod.POST)
    @ResponseBody
    public Page<RerunOutLogInfo> showList(@ModelAttribute("rerunOutLogInfo") RerunOutLogInfo rerunOutLogInfo, HttpServletResponse response) {
        response.setCharacterEncoding("UTF-8");
        rerunOutLogInfo.setNeed_dimension_sql(this.need_dimension_sql);
        logger.info(rerunOutLogInfo.getNeed_dimension_sql());
        Page<RerunOutLogInfo> page = rerunOutLogInfoService.findListToPage(rerunOutLogInfo);
        return page;
    }

mybatis:

        <if test="need_dimension_sql != null  and need_dimension_sql != '' "> AND
            <foreach item="need_dimension_item" collection="need_dimension_sql.split(',')" open="(" separator="and" close=")">
                need_dimension LIKE CONCAT('%', #{need_dimension_item}, '%')
            </foreach>
        </if>