mybatisPlus根据起止时间作为条件进行查询
SimpleDateFormat wrapperSdf1 = new SimpleDateFormat(
"yyyy-MM-dd HH:mm:ss");
//当前时间
Date dzDateObj = new Date();
String nowTime = wrapperSdf1.format(dzDateObj);
//当天0.00点
Calendar calendar = Calendar.getInstance();
calendar.setTime(new Date());
calendar.set(Calendar.HOUR_OF_DAY, 0);
calendar.set(Calendar.MINUTE, 0);
calendar.set(Calendar.SECOND, 0);
Date zero = calendar.getTime();
String startTime = wrapperSdf1.format(zero);
//IndoorAirDataDO 自己的实体类
List<IndoorAirDataDO> indoorAirDataList = indoorAirDataMapper
.selectList(new QueryWrapper<IndoorAirDataDO>().lambda()
//create_time 自己数据库的时间字段
.apply("UNIX_TIMESTAMP(create_time) >= UNIX_TIMESTAMP('" + startTime + "')")
.apply("UNIX_TIMESTAMP(create_time) < UNIX_TIMESTAMP('" + nowTime + "')"));