1.最近在做一个功能,就是mongodb的模糊查询
想要实现对多列的模糊查询,我们试着搜索“表面处理_OSP+金手指”发现搜索不到,如图:
mongo模糊查询的代码如下:
Query query = new Query();
Criteria criteria =new Criteria();
criteria.orOperator(
Criteria.where("parts").regex("^.*"+ruleName+".*$"),
Criteria.where("ruleName").regex("^.*"+ruleName+".*$"),
Criteria.where("description").regex("^.*"+ruleName+".*$"),
Criteria.where("effectiveDate").regex("^.*"+ruleName+".*$"),
Criteria.where("expireDate").regex("^.*"+ruleName+".*$"),
Criteria.where("revision").regex("^.*"+ruleName+".*$"),
Criteria.where("ruleNum").regex("^.*"+ruleName+".*$"),
Criteria.where("status").regex("^.*"+ruleName+".*$"),
Criteria.where("isPublished").regex("^.*"+ruleName+".*$")
);
query.addCriteria(criteria);
List<RuleItem> ruleItems = mongoTemplate.find(query, RuleItem.class);
发现使我们携带了+号,影响正则匹配,加上如下代码:
/**
* 正则表达式有以下特殊字符。需要转义 * . ? + $ ^ [ ] ( ) { } | \ /
*/
public static StringBuffer changeMean(String str) {
String str1 = "*.?+$^[](){}|\\/";
StringBuffer sf = new StringBuffer();
for (int i = 0; i < str.length(); i++) {
String ss = String.valueOf(str.charAt(i));
if (str1.contains(ss)) {
ss = "\\" + ss;
}
sf.append(ss);
}
return sf;
}
过滤我们需要搜索的字符串:
大功告成