日期:2014-05-16 浏览次数:20721 次
MongoDB 模糊查询的三种实现方式-morphia实现如下:
方式一:正则表达式-单个值模糊查询
?
?
Pattern pattern = Pattern.compile("^" + treeIndex + ".*$", Pattern.CASE_INSENSITIVE);
assetInfoDao.createQuery().filter("treeIndexes", pattern);
方式二:正则表达式-多个值模糊查询
?
String[] categorys = category.split(",");
List<Pattern> patterns = Lists.newArrayList();
for (String treeIndex : categorys) {
Pattern pattern = Pattern.compile("^" + treeIndex + ".*$", Pattern.CASE_INSENSITIVE);
patterns.add(pattern);
}
query.filter("treeIndexes all", patterns);
方式三:contains模糊查询方式
?
if (StringUtils.isNotBlank(title)) {
query = query.field("title").contains(title);
}
方式四:精确查询
?
String[] categorys = category.split(",");
query.filter("treeIndexes all", Arrays.asList(categorys));
?
imports:
import java.util.regex.Pattern;
import?com.google.code.morphia.DatastoreImpl;
import?com.google.code.morphia.query.Query;
?
PS:
/**
* <p>Create a filter based on the specified condition and value.
* </p><p>
* <b>Note</b>: Property is in the form of "name op" ("age >").
* </p><p>
* Valid operators are ["=", "==","!=", "<>", ">", "<", ">=", "<=", "in", "nin", "all", "size", "exists"]
* </p>
* <p>Examples:</p>
*?
* <ul>
* <li>{@code filter("yearsOfOperation >", 5)}</li>
* <li>{@code filter("rooms.maxBeds >=", 2)}</li>
* <li>{@code filt