MongoDB的模糊查询

springboot  data 整合mongo之后代码模糊查询写法

代码中的方法是自己写的一个查询类。支持链式编程

@Resource
    private MongoTemplate mongoTemplate;


public Order findOrder(Condition condition){

QueryExtension query = new QueryExtension();
     
        query.addCriteria(condition.hasUserId(), Criteria.where("userId").is(condition.getUserId()));
        query.addCriteria(condition.hasUserName(),
            Criteria.where("userName").regex(Pattern.compile(".*" + condition.getUserName() + ".*", Pattern.CASE_INSENSITIVE)));
        query.addCriteria(condition.hasUserMobile(), Criteria.where("userMobile").is(condition.getUserMobile()));


query.addCriteria(condition.hasName(),
            Criteria.where("mallName").regex(Pattern.compile("^.*" + condition.getName() + ".*$", Pattern.CASE_INSENSITIVE)));


//db.order.find({ userName : { $regex : "^.*wang.*$","$options" : "i" } });



return mongoTemplate.find(query, Order.class);
}

 

import org.springframework.data.domain.Pageable;
import org.springframework.data.domain.Sort;
import org.springframework.data.mongodb.core.query.CriteriaDefinition;
import org.springframework.data.mongodb.core.query.Query;

public class QueryExtension extends Query {
    public QueryExtension() {
    }

    public static QueryExtension build() {
        return new QueryExtension();
    }

    public QueryExtension addCriteria(boolean condition, CriteriaDefinition criteriaDefinition) {
        return condition ? (QueryExtension)super.addCriteria(criteriaDefinition) : this;
    }

    public QueryExtension with(boolean condition, Sort sort) {
        return condition ? (QueryExtension)super.with(sort) : this;
    }

    public QueryExtension with(boolean condition, Pageable pageable) {
        return condition ? (QueryExtension)super.with(pageable) : this;
    }
}

官网全部写法

官网地址 ：Spring Data MongoDB - Reference Documentation