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")));
Subscribe to:
Comments (Atom)