1.问题
将 Wed Sep 14 00:00:00 CST 2022 这种时间格式转化为 2022-09-14 00:00:00 这种时间格式。
2.处理
@PostMapping(value = "/query")
public ResponseResult query(@RequestBody Map<String, Object> paramMap) {
try {
String planStartDate = String.valueOf(paramMap.getOrDefault("planStartDate",""));
String planEndDate = String.valueOf(paramMap.getOrDefault("planEndDate",""));
SimpleDateFormat sdf = new SimpleDateFormat("EEE MMM dd HH:mm:ss zzz yyyy", Locale.US);
String startTimeFormat ="";
String endTimeFormat ="";
if (StringUtils.isNotEmpty(planStartDate)){
Date startParse = sdf.parse(planStartDate);
Date endParse = sdf.parse(planEndDate);
sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
startTimeFormat = sdf.format(startParse);
endTimeFormat = sdf.format(endParse);
}
LambdaQueryWrapper<Count> lambdaQueryWrapper = new LambdaQueryWrapper<>();
lambdaQueryWrapper
.ge(StringUtils.isNotEmpty(startTimeFormat),Count::getPlanStartDate,startTimeFormat)
.le(StringUtils.isNotEmpty(endTimeFormat),Count::getPlanEndDate,endTimeFormat)
.orderByDesc(Count::getPlanStartDate);
List<Count> list = CountService.list(lambdaQueryWrapper);
return result(list);
} catch (Exception e) {
e.printStackTrace();
return resultError(e.getMessage());
}
}