querldsl将String类型日期转换为Date类型
public QueryResults<Holiday> list(Predicate predicate, Pageable pageable, String startTime, String endTime) {
Date startDate = DateUtils.parseDate(startTime);
Date endDate = DateUtils.parseDate(endTime);
DateTemplate dateTemplate = Expressions.dateTemplate(Date.class, "STR_TO_DATE({0},'{1s}')", holiday.date, ConstantImpl.create("%Y-%m-%d"));
BooleanBuilder builder = new BooleanBuilder();
if (startDate == null || endDate == null) {
startDate = DateUtils.truncate(new Date(), Calendar.DAY_OF_MONTH);
endDate = DateUtils.addDays(startDate, 1);
}
builder.and(dateTemplate.between(startDate, endDate));
return jpaQueryFactory.selectFrom(holiday).where(predicate, builder).orderBy(holiday.date.desc()).limit(pageable.getPageSize()).offset(pageable.getOffset()).fetchResults();