MyIbatis使用trim灵活的插入

1.美图

 <insert id="insert" useGeneratedKeys="true" keyProperty="rId" parameterType="com.dtwave.dipper.megrez.server.entity.HdfsUserActionEntity">
        insert into hdfs_authoritry(
        <trim suffix="" suffixOverrides=",">
            <if test="tenantId != null"> tenant_id,</if>
            <if test="path != null"> path,</if>
            <if test="permissions != null"> permissions,</if>
            <if test="linuxName != null"> linux_name,</if>
            <if test="linuxGroup != null"> linux_group,</if>
            <if test="userPermission != null"> user_permission,</if>
            <if test="isAllow != null"> is_allow,</if>
            <if test="userId != null"> user_id,</if>
        </trim>
        )
        values (
        <trim suffix="" suffixOverrides=",">
            <if test="tenantId != null">  #{tenantId},   </if>
            <if test="path != null">  #{path},   </if>
            <if test="permissions != null">  #{permissions},   </if>
            <if test="linuxName != null">  #{linuxName},   </if>
            <if test="linuxGroup != null">  #{linuxGroup},   </if>
            <if test="userPermission != null">  #{userPermission},   </if>
            <if test="isAllow != null">  #{isAllow},   </if>
            <if test="userId != null">  #{userId},   </if>
        </trim>
        )

    </insert>

这样的话，只有不为空的才插入进去，很方便