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. }

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);
10. DBCursor dbCursor = coll.find(queryCondition);
11. while(dbCursor.hasNext()){
    DBObject dbObj= cursor.next();
    System.out.println(dbObj.get("age"));
    }
13. }

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);
10. DBCursor dbCursor = coll.find(queryCondition);
11. while(dbCursor.hasNext()){
    DBObject dbObj= cursor.next();
    System.out.println(dbObj.get("age"));
    }
12. }

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));
10. DBCursor dbCursor = coll.find(queryCondition);
11. while(dbCursor.hasNext()){
    DBObject dbObj= cursor.next();
    System.out.println(dbObj.get("age"));
    }
12. }

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

AND:[java] view plain copypublic void testAnd(){          //agender='female' AND age &amp;gt; 27            DBObject queryCondition = new BasicDBObject();          queryCondition.put(&quot;agender&quot;, &quot;female&quot;);... 1 //条件 startsAt< curr and endsAt > curr 2 long curr = new Date().getTime()/1000; 3 DBObject query = new BasicDBObject(); 4 query.put("start...