Mybaits 常用语句

<update id="updateFullTbPatientTrackingById" parameterType="java.util.HashMap">
    update ptb.tb_patient_tracking
    <trim prefix="set" suffixOverrides=",">
        <if test="genomicReportId!=null">genomic_report_id=#{genomicReportId,jdbcType=INTEGER},</if>
        <if test="trackingStatus!=null">tracking_status=#{trackingStatus,jdbcType=INTEGER},</if>
        <if test="validatedBy!=null">validated_by=#{validatedBy,jdbcType=BIGINT},</if>
        <if test="validated!=null">validated=#{validated,jdbcType=TIMESTAMP},</if>
        <if test="addedBy!=null">added_by=#{addedBy,jdbcType=BIGINT},</if>
        <if test="added!=null">added#{added,jdbcType=TIMESTAMP},</if>
    </trim>
    WHERE tracking_id = #{trackId,jdbcType=INTEGER}
</update>