Federated query with and, or multiple conditions
Age condition (and condition)
Basicdblist condlist = new Basicdblist ();
Basicdbobject cond = new Basicdbobject ();
Cond.put ("$gt", 0);
Cond.put ("$lte", 40);
Basicdbobject composecod = new Basicdbobject ();
Composecod.put ("Age", cond);
Condlist.add (COMPOSECOD);
Name condition
Basicdbobject Namecond = new Basicdbobject ();
Namecond.put ("name", "name");
Condlist.add (Namecond);
Query condition combination (or condition)
Basicdbobject Searchcond = new Basicdbobject ();
Searchcond.put ("$or", condlist);
Dbcursor Findrefresult = Coll.find (Searchcond);
int i=1;
while (Findrefresult.hasnext ()) {
System.out.println ("Inserted Document:" +i);
System.out.println (Findrefresult.next ());
i++;
}
Sort operations
dbcursor cursor = Collection.find (filter_dbobject). Limit (New Basicdbobject ("Create_time",-1));
MONGO and, or multi-condition queries in Java