插入语句insert 在mybatis写动态sql if

最新推荐文章于 2025-05-12 12:44:00 发布

小白浩、

最新推荐文章于 2025-05-12 12:44:00 发布

阅读量1.4k

点赞数

分类专栏： # mybatis 文章标签： mybatis sql java

小白浩、的版权

本文链接：https://blog.youkuaiyun.com/weixin_45716754/article/details/128672150

版权

mybatis 专栏收录该内容

6 篇文章

订阅专栏

插入语句insert 在mybatis写动态sql if
可以用动态的sql标签外部引入

    <sql id="field">
        <trim suffixOverrides=",">
            <if test="username != null and username != ''">
                username,
            </if>
            <if test="password != null and password != ''">
                password,
            </if>
            <if test="email">
                email,
            </if>
            <if test="nickname != null and nickname != ''">
                nickname,
            </if>
            <if test="phone != null and phone != ''">
                phone,
            </if>
            <if test="address != null and address != ''">
                address
            </if>
        </trim>
    </sql>

    <sql id="value">
        <trim suffixOverrides=",">
            <if test="username != null and username != ''">
                #{username},
            </if>
            <if test="password != null and password != ''">
                #{password},
            </if>
            <if test="email">
                #{email},
            </if>
            <if test="nickname != null and nickname != ''">
                #{nickname},
            </if>
            <if test="phone != null and phone != ''">
                #{phone},
            </if>
            <if test="address != null and address != ''">
                #{address}
            </if>
        </trim>
    </sql>

    <!-- 新增用户 -->
    <insert id="insert" parameterType="com.xiaohao.pojo.User">
        INSERT INTO sys_user (<include refid="field" />) VALUES (<include refid="value" />)
    </insert>

    <!-- 编辑用户 -->
    <update id="edit">
        UPDATE sys_user
        <set>
            <if test="username != null and username != ''">
                username = #{username},
            </if>
            <if test="email">
                email = #{email},
            </if>
            <if test="nickname != null and nickname != ''">
                nickname = #{nickname},
            </if>
            <if test="phone != null and phone != ''">
                phone = #{phone},
            </if>
            <if test="address != null and address != ''">
                address = #{address}
            </if>
        </set>
        <where>
            id = #{id}
        </where>
    </update>