数据库字段:
res_begin_time :开始时间
res_end_time:结束时间
传入的参数:
resBeginTime:开始时间
resEndTime:结束时间
SELECT
*
FROM
table_name
WHERE
(
res_begin_time >= #{resBeginTime} AND res_begin_time <= #{resEndTime}
)
OR (
res_begin_time <= #{resBeginTime} AND res_end_time >= #{resEndTime}
)
OR (
res_end_time >= #{resBeginTime} AND res_end_time <= #{resEndTime}
)