mybatis-plus进行分页并模糊查询,当不传入模糊查询的参数时,分页成功,但传入参数的时候,sql语句并不分页而且还查不出数据

这是controller

@GetMapping("/getSendMsg")
    public Result getSendMessage(PageVo pageVo, Message message,
                                                    HttpServletRequest request) {

        if (pageVo.getSize() == 0) {
            pageVo.setSize(10);
        }

        if (pageVo.getCurrent() == 0) {
            pageVo.setCurrent(1);
        }

        MapService userInfo = (MapService) request.getAttribute("userInfo");
        Long visitorId = userInfo.getVal("id", Long.class);
        message.setId(visitorId);
        Page<MessageVo> page = new Page<>(pageVo.getCurrent(), pageVo.getSize());
        ServiceResult<JSONObject> result = messageService.getSendMessages(page,message);
        return Result.ok(result.getServiceResult());
    }

这是service

@Override
    public ServiceResult<JSONObject> getSendMessages(Page<MessageVo> page, Message message) {

        IPage<MessageVo> messages = messagemapper.getSendMessages(page, message);
        logger.info("messages: ",messages);
        JSONObject jsonObject = new JSONObject();
        jsonObject.put("messages",messages);
        ServiceResult<JSONObject> result = new ServiceResultImpl<>(jsonObject);
        return result;
    }

这是打印的sql日志(仅传入分页的数据,并没有传入模糊查询的数据)

img

并且查询出来了数据

img

这是传入了模糊查询的参数后,打印的sql日志

img


然后即不分页,也查询不出数据,就算不分页,数据应该是有的啊,我传的是空字符串啊!