java 时间段sql查询

xnian_

已于 2024-08-22 15:31:01 修改

阅读量323

点赞数

文章标签： java 前端服务器

于 2023-09-18 10:02:44 首次发布

本文链接：https://blog.csdn.net/xnian_/article/details/132965903

版权

if (StringUtils.isNotBlank(MapUtils.getString(params, "addTime", "")) && MapUtils.getString(params, "addTime", "").contains("~")) {
            params.put("startTime", MapUtils.getString(params, "addTime", "").split("~")[0].trim() + " 00:00:00");
            params.put("endTime", MapUtils.getString(params, "addTime", "").split("~")[1].trim() + " 23:59:59");
        }

select * from table where 1=1
<if test="startTime != null and startTime != '' and endTime != null and endTime != ''">
   <![CDATA[ and startTime >= #{startTime} and  startTime <= #{endTime} ]]>
</if>

<if test="sCreateTime != null and sCreateTime != '' and eCreateTime != null and eCreateTime != ''">
                and DATE_FORMAT(create_time,'%Y-%m-%d') between #{sCreateTime} and #{eCreateTime}
            </if>