【MongoDB】-Java實現對mongodb的And、Or、In操作

標籤：

1）And（同時滿足多個條件時用And）

public void testAnd(){          DBObject queryCondition = new BasicDBObject();        //agender=‘female‘ AND age > 27        queryCondition.put("agender", "female");        queryCondition.put("age", new BasicDBObject("$gt", 27));        DBCursor dbCursor = coll.find(queryCondition);       }    

2）Or（兩個條件滿足其中一個）

public void testOrSingleField(){        DBObject queryCondition = new BasicDBObject();              //age<15 OR age>27         BasicDBList values = new BasicDBList();        values.add(new BasicDBObject("age", new BasicDBObject("$gt", 27)));        values.add(new BasicDBObject("age", new BasicDBObject("$lt", 15)));        queryCondition.put("$or", values);        DBCursor dbCursor = coll.find(queryCondition);       }    

3）In（需要某個欄位的值在某個範圍時）

public void testIn(){        DBObject queryCondition = new BasicDBObject();              //age in [13, 47]        BasicDBList values = new BasicDBList();        values.add(13);        values.add(47);        queryCondition.put("age", new BasicDBObject("$in", values));        DBCursor dbCursor = coll.find(queryCondition);       }    

著作權聲明：本文為博主原創文章，未經博主允許不得轉載。

【MongoDB】-Java實現對mongodb的And、Or、In操作