mybatis insert语句

<insert id="saveExportField" parameterType="com.seeyii.base.bean.ExportRecord" keyProperty="id" keyColumn="id" useGeneratedKeys="true">

INSERT INTO export_record

<trim prefix="(" suffix=")" suffixOverrides=",">

    <if test="taskId != null">
        taskId,
    </if>
    <if test="userId != null">
        userId,
    </if>
    <if test="ptNo != null">
        ptNo,
    </if>
    <if test="type != null">
        type,
    </if>
    <if test="status != null">
        status,
    </if>
    <if test="inter != null">
        inter,
    </if>
    <if test="queryCondition != null">
        queryCondition,
    </if>
    <if test="conditionName != null">
        conditionName,
    </if>
    <if test="createTime != null">
        createTime,
    </if>
    <if test="finishTime != null">
        finishTime,
    </if>
    <if test="url != null">
        url,
    </if>
    <if test="fileName != null">
        fileName,
    </if>
    <if test="fileType != null">
        fileType,
    </if>
    <if test="requestTotal != null">
        requestTotal,
    </if>
    <if test="resultTotal != null">
        resultTotal,
    </if>
    <if test="exportField != null">
        exportField,
    </if>
    <if test="fingerId != null">
        fingerId,
    </if>
    <if test="queryId != null">
        queryId,
    </if>
</trim>

<trim prefix="VALUES (" suffix=")" suffixOverrides=",">
        <if test="taskId != null" >
            #{taskId},
        </if>
        <if test="userId != null" >
            #{userId},
        </if>
        <if test="ptNo != null" >
            #{ptNo},
        </if>
        <if test="type != null" >
            #{type},
        </if>
        <if test="status != null" >
            #{status},
        </if>
        <if test="inter != null" >
            #{inter},
        </if>
        <if test="queryCondition != null" >
            #{queryCondition},
        </if>
        <if test="conditionName != null" >
            #{conditionName},
        </if>
        <if test="createTime != null" >
            #{createTime},
        </if>
        <if test="finishTime != null" >
            #{finishTime},
        </if>
        <if test="url != null" >
            #{url},
        </if>
        <if test="fileName != null" >
            #{fileName},
        </if>
        <if test="fileType != null" >
            #{fileType},
        </if>
        <if test="requestTotal != null" >
            #{requestTotal},
        </if>
        <if test="resultTotal != null" >
            #{resultTotal},
        </if>
        <if test="exportField != null" >
            #{exportField},
        </if>
        <if test="fingerId != null" >
            #{fingerId},
        </if>
        <if test="queryId != null" >
            #{queryId},
        </if>
    </trim>
</insert>

useGeneratedKeys:是否返回生成的主键,service层用对象.getid()获取主键

keyProperty:传入对象中的主键列名

keyColumn:表中主键名

<trim prefix="(" suffix=")" suffixOverrides=",">:

prefix :需要添加的前缀  , suffix :需要添加的后缀 , suffixOverrides:需要去掉的后缀,因为最后会有一个逗号多余