mongodb java in,如何在mongodb中使用$ in运算符和java中的两个字段

I would like to retrieve the following information:

select names from database where address like 'colombo' and age>20;

but for MongoDB in Java. Essentially, it should return all names that contain the word colombo ang age greater than 20 in them. I know that there is the $in operator in MongoDB, but how do I do the same in Java, using the Java driver? I've been trying to look for it everywhere but am getting nothing. I've tried:

query = new BasicDBObject("names", new BasicDBObject("$in", "colombo"), new BasicDBObject("age", "$gt20"));

But it didn't worked :( Please help!

解决方案

The

In your case you need a

db.collection.find({

"names": { "$regex": /colombo/, "$options": "i" },

"age": { "$gt": 20 }

})

or

db.collection.find({

"names": /colombo/i },

"age": { "$gt": 20 }

})

which can be implemented in Java as

Pattern pattern = Pattern.compile("colombo", Pattern.CASE_INSENSITIVE);

BasicDBObject query = new BasicDBObject("names", pattern)

.append("$age", new BasicDBObject("$gt", 20));

DBCursor result = coll.find(query);

If using the 3.0.x and newer drivers:

Document regx = new Document();

regx.append("$regex", "(?)" + Pattern.quote("colombo"));

regx.append("$options", "i");

Document query = new Document("names", regx).append("$age", new Document("$gt", 20));

FindIterable iterable = db.getCollection("coll").find(query);