mongodb java 查询 日期_如何在Java中对MongoDB按日期进行查询统计?

慕函数4003404

方法一：通过构造BasicDBObject对象来进行查询[java] view plain copyint startYear=2015,endYear=2016;int startMonth=12,endMonth=1;int startDay=1,endDay=1;BasicDBObject query= new BasicDBObject("applydate", new BasicDBObject("$gte", new Date(startYear - 1900, startMonth - 1, startDay)).append("$lt", new Date(endYear - 1900, endMonth -1, endDay)));//因为无法确知当前月有多少天，所以就从当月的1号(包含)计到下月1号(不包含)int iCount = cltApplies.find(query).count();System.out.println(iCount);经测试上述代码执行完毕后iCount为9。也就是在2016-1-1至2016-1-31期间有9条记录。方法二：通过BasicDBObjectBuilder对象来查询：[java] view plain copyint startYear=2016,endYear=2016;int startMonth=1,endMonth=2;int startDay=1,endDay=1;BasicDBObject query= new BasicDBObject();query