1.组装时间段工具类
/**
* 处理日期段查询条件
* @param yztOrder
*/
public static void seacher(YztOrder yztOrder) {
Date orderTimeStart = yztOrder.getOrderTimeStart();
Date orderTimeEnd = yztOrder.getOrderTimeEnd();
List<String> orderDateStr = new ArrayList<>();
if (orderTimeStart == null && orderTimeEnd == null) {
} else if (orderTimeEnd == null) {
orderDateStr.add(DateUtils.dateToStr(orderTimeStart, DateUtils.YYYY_MM_DD));
yztOrder.setOrderTimeList(orderDateStr);
} else {
yztOrder.setOrderTimeList(DateUtils.getDays(orderTimeStart, orderTimeEnd));
}
}
2.xml中的sql写法
<if test="orderTimeList != null and orderTimeList.size() != 0">
and date_format(create_time,'%Y-%m-%d') in
<foreach item="item" collection="orderTimeList" open="(" separator="," close=")">
#{item}
</foreach>
</if>