mongodb java in,使用$或$ in在Java中创建mongodb查询

I am trying to write a java code using mongodb api to create this mongodb query:

{ "$or": [{"prd" : {"$in" : ["1234", "0987"]}} , {"rsin" : "3228742"}]}

Here's the code I am working with so far:

QueryBuilder builder = new QueryBuilder();

if (builder == null) {

builder = QueryBuilder.start();

}

if (mongoKey.equals("prd")){

ArrayList vals = new ArrayList();

for (int i=0; i < prdList; i++){

vals.add(prdList.get(i));

}

DBObject obj = new BasicDBObject (mongoKey, new BasicDBObject("$in", vals));

builder.or(obj);

}else {

builder.and(mongoKey).is(mongoValue);

}

This is currently printing out the wrong syntax:

{ "$or": [{"prd" : {"$in" : ["1234", "0987"]}}] , "rsin" : "3228742"}

Any help?

解决方案

The problem is on else block, you need to use or method instead of and.

...

}else {

builder.or(new BasicDBObject(mongoKey, mongoValue));

}

This will produce the query that you want.