Question

Java对mongodb进行正则查询？

{
"_id" : ObjectId("55b74aa9c551a027777eec0b"),
"colkey" : "{timestmp:1438075544181, num:3, ips:[-1079506422,-1079506420]}",
"timeout" : 0,
}
如上mongodb中的一条记录，我想查询colkey里面timestmp大于某个值的所有记录，该如何查询？用正则？

Answer 1

用Java实现MongoDB正则查询小技巧：
//模糊查询
private BasicDBObject getLikeStr(String findStr) {
Pattern pattern = Pattern.compile("^.*" + findStr + ".*$", Pattern.CASE_INSENSITIVE);
return new BasicDBObject("$regex", pattern);
}
DBObject query = new BasicDBObject();
query.put("real_name", getLikeStr(userName));

//endWith文件扩展名
private BasicDBObject endWithStr(String findStr) {
Pattern pattern = Pattern.compile(findStr + "$", Pattern.MULTILINE);
return new BasicDBObject("$regex", pattern);
}
DBObject query = new BasicDBObject();
query.put("filename", endWithStr(“.pdf”));

Answer 2

//模糊查询
private BasicDBObject getLikeStr(String findStr) {
Pattern pattern = Pattern.compile("^.*" + findStr + ".*$", Pattern.MULTILINE);
return new BasicDBObject("$regex", pattern);
}