tkMybatis使用Example查询昨天的数据信息

Mybatis-Plus使用Example查询昨天的数据信息

@Override
    public int getAllTopicYesterdayUpload() {
        //取时间
        Date date = new Date();
        Calendar calendar = new GregorianCalendar();
        //设置时间
        calendar.setTime(date);
        //天数减1
        calendar.add( Calendar.DATE,-1);
        calendar.set(Calendar.HOUR,0);
        calendar.set(Calendar.MINUTE,0);
        calendar.set(Calendar.SECOND,0);
        calendar.set(Calendar.MILLISECOND,0);
        //获取开始时间，为昨天开始时间
        Date beginDate = calendar.getTime();
        calendar.set(Calendar.HOUR,23);
        calendar.set(Calendar.MINUTE,59);
        calendar.set(Calendar.SECOND,59);
        calendar.set(Calendar.MILLISECOND,999);
        //获取结束时间，为昨天最后时间，精确到毫秒级别
        Date endDate = calendar.getTime();

        Example example = new Example(TopicEntity.class);
        Example.Criteria criteria = example.createCriteria();
        //构建查询条件
        criteria.andNotEqualTo("topicStatus",1);
        criteria.andBetween("commitTime",beginDate,endDate);
        int i = topicDao.selectCountByExample(example);
        return i;
    }