Java 实现对mongodb and or 和and or联合查询操作

AND:

[java]  view plain  copy

1. public void testAnd(){      
2.     //agender='female' AND age > 27        
3.     DBObject queryCondition = new BasicDBObject();      
4.     queryCondition.put("agender", "female");      
5.     queryCondition.put("age", new BasicDBObject("$gt", 27));      
6.     DBCursor dbCursor = coll.find(queryCondition);      
7.     while(dbCursor.hasNext()){
       DBObject dbObj= cursor.next();
       System.out.println(dbObj.get("age"));
      }
8. }      

OR:

[java]  view plain  copy

1. public void testOrSingleField(){      
2.     DBObject queryCondition = new BasicDBObject();            
3.     //age<15 OR age>27      
4.     queryCondition = new BasicDBObject();      
5.     BasicDBList values = new BasicDBList();      
6.     values.add(new BasicDBObject("age", new BasicDBObject("$gt", 27)));      
7.     values.add(new BasicDBObject("age", new BasicDBObject("$lt", 15)));      
8.     queryCondition.put("$or", values);      
9.           
10.     DBCursor dbCursor = coll.find(queryCondition);      
11.     while(dbCursor.hasNext()){
        DBObject dbObj= cursor.next();
        System.out.println(dbObj.get("age"));
       }
12.  
13. }      

OR:

[java]  view plain  copy

1. public void testOrMultiFields(){      
2.     DBObject queryCondition = new BasicDBObject();            
3.     //agender=female OR age<=23      
4.     queryCondition = new BasicDBObject();      
5.     BasicDBList values = new BasicDBList();      
6.     values.add(new BasicDBObject("agender", "female"));      
7.     values.add(new BasicDBObject("age", new BasicDBObject("$lte", 23)));      
8.     queryCondition.put("$or", values);      
9.           
10.     DBCursor dbCursor = coll.find(queryCondition);      
11.          while(dbCursor.hasNext()){
        DBObject dbObj= cursor.next();
        System.out.println(dbObj.get("age"));
       }
12. }    

in:

[java]  view plain  copy

1. public void testIn(){      
2.     DBObject queryCondition = new BasicDBObject();            
3.     //age in [13, 47]      
4.     queryCondition = new BasicDBObject();      
5.     BasicDBList values = new BasicDBList();      
6.     values.add(13);      
7.     values.add(47);      
8.     queryCondition.put("age", new BasicDBObject("$in", values));      
9.           
10.     DBCursor dbCursor = coll.find(queryCondition);      
11.      while(dbCursor.hasNext()){
        DBObject dbObj= cursor.next();
        System.out.println(dbObj.get("age"));
       }
12. }    

自己的:

and 和or的联合查询条件 (换成sql 这个查询条件就是  m=1 and (a=0 or a=1) and (b=1 or c=1))

[java]  view plain  copy

1. public  DBObject getWhereField(){  
2.         DBObject wheremap = new BasicDBObject();  
3.         wheremap.put("m", 1);  
4. //        
5.           
6.         DBObject[] orDbj = new BasicDBObject[2];  
7.         orDbj[0] = new BasicDBObject("a", 0);  
8.         orDbj[1] = new BasicDBObject("a", 1);  
9.           
10.         DBObject[] orDbj1 = new BasicDBObject[2];  
11.         orDbj1[0] = new BasicDBObject("b", 1);  
12.         orDbj1[1] = new BasicDBObject("c", 1);  
13.           
14.         BasicDBList values = new BasicDBList();      
15.         values.add(new BasicDBObject("$or", orDbj));  
16.         values.add(new BasicDBObject("$or", orDbj1));  
17.           
18.         wheremap.put("$and", values);  
19.         return wheremap;  
20.     }