mybatis的if

最新推荐文章于 2025-06-19 21:39:43 发布

9栋108

最新推荐文章于 2025-06-19 21:39:43 发布

阅读量131

点赞数

CC 4.0 BY-SA版权

文章标签： java

原文链接：http://www.cnblogs.com/lijiasnong/p/9843797.html

本文详细解析了MyBatis中复杂SQL查询的构建过程，包括动态SQL元素的使用，如<if>条件判断和<where>子句的正确闭合技巧。通过具体示例，展示了如何根据不同条件动态拼接SQL语句，实现灵活的数据筛选。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<select id="findList" resultType="BndExport">
        SELECT 
            <include refid="bndExportColumns"/>
        FROM bnd_export a
        <include refid="bndExportJoins"/>
        <where>
            a.del_flag = #{DEL_FLAG_NORMAL}
            <if test="createDate != null and createDate != ''">
                AND a.create_date = #{createDate}
            </if>
            <if test="createDateStart!=null and createDateStart!='' and createDateEnd!=null and createDateEnd!=''">
                AND a.create_date between to_date('${createDateStart}','yyyy-mm-dd hh24:mi:ss') and to_date('${createDateEnd}','yyyy-mm-dd hh24:mi:ss')
            </if>
            <if test="company != null and company != ''">
                AND a.company = #{company}
            </if>
            <if test="bndExportFreight != null and bndExportFreight != '' and bndExportFreight.vessel != null and bndExportFreight.vessel != ''">
                AND b.vessel= #{bndExportFreight.vessel}
            </if>
            <if test="bndExportFreight != null and bndExportFreight != '' and bndExportFreight.voyage != null and bndExportFreight.voyage != ''">
                AND b.vessel= #{bndExportFreight.voyage}
            </if>
        </where>

转载于:https://www.cnblogs.com/lijiasnong/p/9843797.html