这是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日志(仅传入分页的数据,并没有传入模糊查询的数据)
并且查询出来了数据
这是传入了模糊查询的参数后,打印的sql日志
然后即不分页,也查询不出数据,就算不分页,数据应该是有的啊,我传的是空字符串啊!