java的时间段查询，组装查询条件

最新推荐文章于 2024-05-16 10:23:10 发布

来自外太空的鱼-张小张

最新推荐文章于 2024-05-16 10:23:10 发布

阅读量426

点赞数

文章标签： java sql 开发语言

本文链接：https://blog.csdn.net/qq_26144365/article/details/126947583

版权

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>