java mongodb求某天的记录

可爱的中可爱

已于 2022-03-11 11:22:05 修改

阅读量294

点赞数

分类专栏： java 文章标签： java mongodb

于 2021-08-12 16:00:40 首次发布

本文链接：https://blog.csdn.net/qq_47870876/article/details/119646602

版权

java 专栏收录该内容

39 篇文章 2 订阅

订阅专栏

java mongodb求某天的记录

 			Criteria criteria = new Criteria();


            Query query = new Query();
            if (time != null && !time.equals("")) {
                SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");

                Date date = null;
                try {
                    date = format.parse(time);
                } catch (ParseException e) {
                    e.printStackTrace();
                }

                //设置开始时间

                Calendar todayStart = Calendar.getInstance();
                todayStart.setTime(date);
                todayStart.set(Calendar.HOUR_OF_DAY, 0);
                todayStart.set(Calendar.MINUTE, 0);
                todayStart.set(Calendar.SECOND, 0);
                todayStart.set(Calendar.MILLISECOND, 0);
                Date todayStartTime = todayStart.getTime();


                //设置结束时间
                Calendar todayEnd = Calendar.getInstance();
                todayEnd.setTime(date);
                todayEnd.set(Calendar.HOUR_OF_DAY, 23);
                todayEnd.set(Calendar.MINUTE, 59);
                todayEnd.set(Calendar.SECOND, 59);
                todayEnd.set(Calendar.MILLISECOND, 999);
                Date todayEndTime = todayEnd.getTime();
                query.addCriteria(Criteria.where("DateTime").gte(todayStartTime).lte(todayEndTime));

            }

            query.with(Sort.by(Sort.Direction.DESC, "DateTime"));

            query.skip(size * (page - 1)).limit(size);


            List<Map> results = mongoTemplate.find(query, Map.class, "log_Manager");