mapper时间条件查询

最新推荐文章于 2024-04-24 09:31:08 发布

打酱油的张起灵

最新推荐文章于 2024-04-24 09:31:08 发布

阅读量5.6k

点赞数 1

分类专栏： java 项目相关

本文链接：https://blog.youkuaiyun.com/Pashudeanan/article/details/74497114

版权

java 项目相关专栏收录该内容

12 篇文章

订阅专栏

  select
    <include refid="Base_Column_List" />
    from meet_room
    where
   <![CDATA[ mr_open_time <= #{startTime,jdbcType=VARCHAR} and
     mr_close_time >= #{startTime,jdbcType=VARCHAR} and
     mr_open_time <= #{lastTime,jdbcType=VARCHAR} and mr_close_time >= #{lastTime,jdbcType=VARCHAR} and mr_count >= #{counts,jdbcType=INTEGER} and
     mr_id not in (select or_mr_id from order_record
    where
    (or_time < #{dateTime,jdbcType=TIMESTAMP }
    and or_use_time > #{dateTime,jdbcType=TIMESTAMP })
    or (or_time < #{dateUseTime,jdbcType=TIMESTAMP}
    and  or_use_time> #{dateUseTime,jdbcType=TIMESTAMP})
    )
    ]]>
    order by mr_count