mybatis if 判断

最新推荐文章于 2025-05-08 17:44:50 发布

shixiansen6535

最新推荐文章于 2025-05-08 17:44:50 发布

阅读量301

点赞数

分类专栏： mybatis

本文链接：https://blog.youkuaiyun.com/shixiansen6535/article/details/80361801

版权

mybatis 专栏收录该内容

9 篇文章

订阅专栏

本文介绍了一个使用MyBatis实现的动态SQL示例，包括查询、更新和插入操作。通过条件判断来动态组装SQL语句，提高代码灵活性。

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

查询

<select id="selectOption" resultType="Map" parameterType="com.model.Option">
    select * from system_option

    <where>
    <if test="uuid != null and uuid != ''">
        uuid=#{uuid}
    </if>
    <if test="name != null and name != ''">
        and name=#{name}
    </if>
    <if test="description != null and description != ''">
        and description=#{description}
    </if>
    <if test="url != null and url != ''">
        and url=#{url}
    </if>
    <if test="parentID != null and parentID != ''">
        and parentID=#{parentID}
    </if>
    </where>
</select>

修改

<update id="updateOption" parameterType="com.model.Option">
    update system_option
     set
    <if test="url != null and url !=''">
        url = #{url},
    </if>

    <if test="description != null and description !=''">
    description = #{description},
    </if>
    <if test="name != null and name !=''">
    name = #{name },
    </if>
    <if test="parentID != null and parentID !=''">
        parentID = #{parentID },
    </if>
    <if test="sequence != null and sequence !=''">
        sequence = #{sequence },
    </if>
    uuid=#{uuid}
    where
    uuid = #{uuid}
</update>

插入

<insert id="insertOption" parameterType="com.model.Option">
    insert into system_option
    <trim prefix="(" suffix=")" suffixOverrides="," >
        <if test="name != null" >
            name,
        </if>
        <if test="url != null" >
            url,
        </if>
        <if test="uuid != null" >
            uuid,
        </if>
        <if test="description != null" >
            description,
        </if>
        <if test="parentID != null" >
            parentID
        </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides="," >
        <if test="name != null" >
            #{name},
        </if>
        <if test="url != null" >
            #{url},
        </if>
        <if test="uuid != null" >
            #{uuid},
        </if>
        <if test="description != null" >
            #{description},
        </if>
        <if test="parentID != null" >
            #{parentID}
        </if>
    </trim>


</insert>