mongoDB : javaAPI : gt(>), lt(<) example

BasicDBObject query = new BasicDBObject();

query.put("_id", new BasicDBObject("$gt", 2).append("$lt", 15));

               

DBCursor cursor = collection.find(query);

               

Above snippet query for all documents, where “_id” is > 2 and < 15.

import java.net.UnknownHostException;

import com.mongodb.BasicDBObject;
import com.mongodb.DBCursor;
import com.mongodb.MongoClient;
import com.mongodb.DB;
import com.mongodb.DBCollection;

public class FindDocument {

 /* Step 1 : get mongoClient */
 public static MongoClient getMongoClient(){
  MongoClient mongoClient = null;
   try {
    mongoClient = new MongoClient( "localhost" , 27017 );
  } catch (UnknownHostException e) {
   e.printStackTrace();
  }
   return mongoClient;
 }
 
 public static void main(String args[]){
  MongoClient mongoClient = getMongoClient();
  
  /* Step 2: Connect to DB */
  DB db = mongoClient.getDB("sample");
  
  /*Step 3 : Get collection */
  DBCollection collection = db.getCollection("employee");
  
  /* Step 4 : Create Query object */
  BasicDBObject query = new BasicDBObject();
  query.put("_id", new BasicDBObject("$gt", 2).append("$lt", 15));
  
  /* Step 5 : Get all documents */
  DBCursor cursor = collection.find(query);
  
  /* Step 6 : Print all documents */
  while(cursor.hasNext()){
   System.out.println(cursor.next());
  }
 }
 
}

Output

{ "_id" : 3.0 , "firstName" : "Gopi" , "lastName" : "Battu"}
{ "_id" : 4.0 , "firstName" : "Ritwik" , "lastName" : "Mohenthy"}

Prevoius                                                 Next                                                 Home