在使用Criteria做条件查询时,是没有提供类似mysql的between查询的, 但是用Criteria做同一字段的2次条件查询是要报错的,比如
criteria.and("create_time").gt(pojo.getCreateTimeFrom()).and("create_time").lt(pojo.getCreateTimeTo())
或
criteria.and("create_time").gt(pojo.getCreateTimeFrom());
criteria.and("create_time").lt(pojo.getCreateTimeTo());
这样查询会报错,报错的大概意思是同一个字段不能使用2次条件查询
Due to limitations of the com.mongodb.BasicDocument, you can't add a second 'create_time' expression specified as 'create_time : Document{{$lt=2020-09-30 17:03:07}}'. Criteria already contains 'create_time : Document{{$gt=2020-09-03 17:03:07}}'.
但是Criteria提供了一个操作:andOperator,它允许一个字段进行2次条件查询。如
Criteria fromTime = Criteria.where("create_time").gt(pojo.getCreateTimeFrom());
Criteria toTime = Criteria.where("create_time").lt(pojo.getCreateTimeTo());
criteria.andOperator(fromTime, toTime);
由于时间保存到mongodb后会存为格林威治时间,所以查询时需要处理下:
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
sdf.setTimeZone(TimeZone.getTimeZone("GMT+0:00"));
Date startTime = sdf.parse(pojo.getCreateTimeFrom());
Date endTime = sdf.parse(pojo.getCreateTimeTo());
Criteria fromTime = Criteria.where("create_time").gt(startTime);
Criteria toTime = Criteria.where("create_time").lt(endTime);
criteria.andOperator(fromTime, toTime);