在Java中使用MongoDB中的日期范围进行查询 [英] Query using range of date in MongoDB in Java
本文介绍了在Java中使用MongoDB中的日期范围进行查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我是使用MongoDB的新手.例如,我已将其装满收据:一张收据看起来像这样:
I am new at using MongoDB. I have it filled with receipts, for example: one receipt looks like this :
{
"_id" : {
"$oid" : "510fa057c6f818c2bfd0b279"
} ,
"StoreName" : "Metro" ,
"StoreNumber" : 521 ,
"Items" : [ {
"ItemName" : "Battery" ,
"ItemManufacturer" : "Duracell" ,
"ItemPrice" : 12 ,
"ItemQuantity" : 2 ,
"ItemTotalPrice" : 24
} ,
{
"ItemName" : "TV CRT 25 inch" ,
"ItemManufacturer" : "Toshiba" ,
"ItemPrice" : 1659 ,
"ItemQuantity" : 1 ,
"ItemTotalPrice" : 1659
} ,
{
"ItemName" : "Mobile" ,
"ItemManufacturer" : "Nokia" ,
"ItemPrice" : 2966 ,
"ItemQuantity" : 4 ,
"ItemTotalPrice" : 11864
}
] ,
"Date" : {
"$date" : "2012-06-16T01:21:11.758Z"
} ,
"Total" : 13547
}
我需要进行查询,在其中指定日期范围以获取该范围内的所有收据.我尝试了以下查询,但未返回任何内容.
I need to make a query where I specify a range of dates to get all the receipts in that range. I've tried the following query, but it returns nothing.
BasicDBObject query =
new BasicDBObject(
"Date",
new BasicDBObject(
"$gt",
"2012-06-20T10:05:21.968Z"
).append(
"$lte",
"2012-09-24T05:29:43.031Z"
)
);
推荐答案
MongoDB日期与java.util.Date结合使用.将您的查询更改为类似这样的内容:
MongoDB dates work in conjunction with java.util.Date. Change your query to something like this :
Date start = new java.util.Date(2012, 06, 20, 10, 05);
Date end = new java.util.Date(2012, 06, 20, 10, 30);
BasicDBObject query = new BasicDBObject("Date",
new BasicDBObject("$gt", start)).
append("$lte", end) ));
这篇关于在Java中使用MongoDB中的日期范围进行查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文