相关代码如下:

private static Date getStartTime() {
	Calendar todayStart = Calendar.getInstance();
	todayStart.set(Calendar.HOUR_OF_DAY,0);
	todayStart.set(Calendar.MINUTE,0);
	todayStart.set(Calendar.SECOND,0);
	todayStart.set(Calendar.MILLISECOND,0);
	return todayStart.getTime();
}

private static Date getEndTime() {
	Calendar todayEnd = Calendar.getInstance();
	todayEnd.set(Calendar.HOUR_OF_DAY,23);
	todayEnd.set(Calendar.MINUTE,59);
	todayEnd.set(Calendar.SECOND,59);
	todayEnd.set(Calendar.MILLISECOND,999);
	return todayEnd.getTime();
}


User answerRecord = userTemplate.findOne(Query.query(where("createtime")
		.gte(getStartTime())
		.lte(getEndTime())
		.and("id").is("12456")), User.class);

对应的查询语句为:

{ "createtime" : { "$gte" : { "$date" : "2018-10-16T16:00:00.000Z"} , "$lte" : { "$date" : "2018-10-17T15:59:59.999Z"}} , "id" : "12456"}

 

Logo

讨论HarmonyOS开发技术,专注于API与组件、DevEco Studio、测试、元服务和应用上架分发等。

更多推荐