mongotemplate分页查询

最新推荐文章于 2024-08-16 09:34:23 发布

在踩坑中前进

最新推荐文章于 2024-08-16 09:34:23 发布

阅读量4k

点赞数

本文链接：https://blog.csdn.net/zhaoyahui_666/article/details/107081805

版权

        Document queryObject = new Document();
        queryObject.put("projectId", vo.getProjectId());

        if(StringUtils.isNotEmpty(vo.getOriginString())){
            queryObject.put("originString", vo.getOriginString());
        }
        if(Objects.nonNull(vo.getFileId())){
            queryObject.put("fileId", vo.getFileId());
        }

        Document fieldsObject = new Document();
        fieldsObject.put("id", true);
        fieldsObject.put("originString", true);
        fieldsObject.put("context", true);

        Query query = new BasicQuery(queryObject, fieldsObject);
        query.with(Sort.by(Sort.Direction.DESC, "createTime"));
        query.skip(vo.getPageSize()*(vo.getPageIndex()-1)).limit(vo.getPageSize());
        List<TranStringMGDO> rows = mongoTemplate.find(query,TranStringMGDO.class,TablesUtils.TRAN_STRING);
        long count = mongoTemplate.count(query, TranStringMGDO.class, TablesUtils.TRAN_STRING);