querywrapper按日期范围查
QueryWrapper qw = new QueryWrapper();qw.apply(“DATE(createtime) >= STR_TO_DATE(’”+rqq+" 00:00:00’,’%Y-%m-%d %H:%i:%s’)");qw.apply(“DATE(createtime) <= STR_TO_DATE(’”+rqz+" 23:59:59’,’%Y-%m-%d %H
·
QueryWrapper qw = new QueryWrapper();
qw.apply(“DATE(createtime) >= STR_TO_DATE(’”+rqq+" 00:00:00’,’%Y-%m-%d %H:%i:%s’)");
qw.apply(“DATE(createtime) <= STR_TO_DATE(’”+rqz+" 23:59:59’,’%Y-%m-%d %H:%i:%s’)");
Page page = new Page<>(pageIndex, pageSize);
IPage iPage = iXtRzService.page(page,qw);
List list =iPage.getRecords();
更多推荐
已为社区贡献3条内容
所有评论(0)