Mybatis：updat语句和insert语句用法

update语句用法

    <update id="update" parameterType="java.util.HashMap">
        update basedevice
            <!-- set 语句可以自动去掉最后一个逗号 -->
            <set>
                <if test="new_id !=null and new_id !='' ">
                    id = #{new_id},
                </if>
            </set>
        where id = #{id}
    </update>

insert语句用法

    <insert id="add" parameterType="java.util.HashMap">
        INSERT INTO t_user_bank
        <trim prefix="(" suffix=")" suffixOverrides=",">
            arch_id,
            <if test="bank_id != null">
                bank_id,
            </if>
            <if test="account_name != null">
                account_name,
            </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            #{ arch_id },
            <if test="bank_id != null">
                #{ bank_id},
            </if>
            <if test="account_name != null">
                #{ account_name},
            </if>
        </trim>
    </insert>