mongodb相关的查询

开着宝马放鸭子

于 2018-07-30 20:38:17 发布

阅读量212

点赞数 1

分类专栏： mongodb

本文链接：https://blog.csdn.net/Walvins/article/details/81291555

版权

mongodb 专栏收录该内容

1 篇文章

订阅专栏

        Criteria criteria = new Criteria();
        if (StringUtils.isNotBlank(keywords)) {
            criteria.orOperator(Criteria.where("name").regex(keywords, "i"),
                    Criteria.where("comment").regex(keywords, "i"),
                    Criteria.where("referName").regex(keywords, "i")
            );
        }
        Query query = new Query(criteria).with(new Sort(Sort.Direction.DESC, new String[]{ "orderNo","gmtCreated"})).skip(start).limit(limit);

mongoTemplate 模糊匹配查询

Criteria criteria = new Criteria();
if (StringUtils.isNotBlank(keywords)) {
    criteria.orOperator(Criteria.where("name").regex(keywords, "i"),
            Criteria.where("comment").regex(keywords, "i"),
            Criteria.where("referName").regex(keywords, "i")
    );
}
   根据字段排序
Query query = new Query(criteria).with(
    new Sort(Sort.Direction.DESC, new String[]{ "orderNo","gmtCreated"}))
.skip(start).limit(limit);