mybatis中对时间范围内进行操作，确保一段时间内时间唯一

<where>

    <if test="startTime != null and startTime!= '' and endTime != null and endTime != '' and  meetDate != null and meetDate != '' ">
        and  start_time &lt;#{startTime} and end_time &gt; #{startTime} and  meet_date = #{meetDate}
    </if>
    <if test="endTime != null and endTime != '' and startTime != null and startTime!= '' and  meetDate != null and meetDate != '' ">
        or start_time &lt; #{endTime} and end_time &gt; #{endTime} and  meet_date = #{meetDate}
    </if>

    <if test="endTime != null and endTime != '' and startTime != null and startTime!= '' and  meetDate != null and meetDate != ''  ">
        or start_time &gt;= #{startTime} and end_time &lt;= #{endTime}  and  meet_date = #{meetDate}
    </if>
    <if test="endTime != null and endTime != '' and startTime != null and startTime!= '' and  meetDate != null and meetDate != '' ">
        or end_time &gt; #{startTime} and end_time &lt; #{endTime}  and  meet_date = #{meetDate}
    </if>

</where>