Wednesday, July 20, 2016

MongoDB 3.2 ISODate Range lte and gte Query with Java Code.


MongoQuery:

db.collectionname.find({"admissstionDate": { $gte : ISODate('2000-09-30 18:30:00') ,$lte :ISODate('2001-09-30 18:30:00')}})

Java Code Query

 import com.mongodb.MongoClient;
import com.mongodb.client.MongoDatabase;

public class DatabaseConnection {
   

    private static MongoDatabase  dbConnection = null;
   
      private DatabaseConnection() {}
      
      @SuppressWarnings("resource")
       public static MongoDatabase getDatabaseConnection() {
         
          if(dbConnection == null) {
            MongoClient mongoClient = new MongoClient("localhost",27017);
              dbConnection = mongoClient.getDatabase("admin");
          }
          return dbConnection;
       }
}




DatabaseConnection.getDatabaseConnection().getCollection("collectionname").
                                            
find(new Document("admissstionDate", new Document("$gte", "26-05-2016 00:00:00")
.append("$lte","26-05-2016 23:59:59")));