日期:2014-05-16  浏览次数:20704 次

MongoDB 模糊查询的三种实现方式-morphia实现

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