MongoDB的模糊查询
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;
}
}
官网全部写法
更多推荐
已为社区贡献3条内容
所有评论(0)