用MP很久了,每次时间查询总想写SQL,记录一下wrapper使用时间查詢,以后找代码也方便
话不多说,万能Wrapper,上代码
QueryWrapper<DemandPlanHeader> wrapper = new QueryWrapper<>();
if (StringUtil.isNotBlank(demandPlanHeader.getDocNo())) {
wrapper.like("DOC_NO", demandPlanHeader.getDocNo());
}
if (demandPlanHeader.getStartDate() != null) {
wrapper.apply("date_format(CREATE_DATE,'%Y-%m-%d')>{0}", demandPlanHeader.getStartDate());
}
if (demandPlanHeader.getEndDate() != null) {
wrapper.apply("date_format(CREATE_DATE,'%Y-%m-%d')<{0}", demandPlanHeader.getEndDate());
}