MyBatil批量查询

最新推荐文章于 2022-07-12 10:11:07 发布

江南一棵树。

最新推荐文章于 2022-07-12 10:11:07 发布

阅读量119

点赞数

分类专栏： MyBatils

本文链接：https://blog.youkuaiyun.com/shassd/article/details/119870490

版权

MyBatils 专栏收录该内容

2 篇文章

订阅专栏

 <select id="selectByAuntIds" resultMap="BaseResultMap" >
        select
        <include refid="Base_Column_List"/>
        from aunt_leave_info
        where leave_end_time > #{startDate}
        and <![CDATA[ leave_start_time < #{endDate} ]]>
        and yn = 1
        and aunt_Id in
        <foreach collection="list" item="auntId" open="(" close=")" separator=",">
           #{auntId}
        </foreach>
    </select>

 <select id="selectByAuntIds" resultMap="BaseResultMap" >
        select
        <include refid="Base_Column_List"/>
        from aunt_leave_info
        where leave_end_time > #{startDate}
        and <![CDATA[ leave_start_time < #{endDate} ]]>
        and yn = 1
        and aunt_Id in
        <foreach collection="list" item="auntId" open="(" close=")" separator=",">
           #{auntId}
        </foreach>
    </select>