Mybatis 批量新增只返回第一主键ID 其他返回null-Toy模板网

这篇具有很好参考价值的文章主要介绍了Mybatis 批量新增只返回第一主键ID 其他返回null。希望对大家有所帮助。如果存在错误或未考虑完全的地方，请大家不吝赐教，您也可以点击"举报违法"按钮提交疑问。

    <insert id="batchInsert" parameterType="java.util.List" useGeneratedKeys="true" keyColumn="subform_id"
            keyProperty="subformId">
        insert into t_form_subf
        (
        form_id,
        subform_no,
        subform_name,
        subform_describe,
        subform_input_type,
        subform_content,
        subform_length,
        subform_width,
        required_yn,
        dict_code,
        table_code,
        field_code,
        regi_state,
        create_by,
        create_time,
        update_by,
        update_time
        )
        values
        <foreach collection="list" item="item" separator=",">
            (
            #{item.formId,jdbcType=BIGINT},
            #{item.subformNo,jdbcType=VARCHAR},
            #{item.subformName,jdbcType=VARCHAR},
            #{item.subformDescribe,jdbcType=VARCHAR},
            #{item.subformInputType,jdbcType=VARCHAR},
            #{item.subformContent,jdbcType=VARCHAR},
            #{item.subformLength,jdbcType=FLOAT},
            #{item.subformWidth,jdbcType=FLOAT},
            #{item.requiredYn,jdbcType=VARCHAR},
            #{item.dictCode,jdbcType=VARCHAR},
            #{item.tableCode,jdbcType=VARCHAR},
            #{item.fieldCode,jdbcType=VARCHAR},
            #{item.regiState,jdbcType=VARCHAR},
            #{item.createBy,jdbcType=VARCHAR},
            #{item.createTime,jdbcType=TIMESTAMP},
            #{item.updateBy,jdbcType=VARCHAR},
            #{item.updateTime,jdbcType=TIMESTAMP}
            )
        </foreach>
        on duplicate key update form_id = values(form_id), subform_no =
        values(subform_no), subform_name =values(subform_name),
        subform_describe =values(subform_describe),
        subform_input_type =values(subform_input_type),
        required_yn =values(required_yn),
        dict_code =values(dict_code),
        table_code =values(table_code),
        field_code =values(field_code),
        regi_state =values(regi_state),
        create_by =values(create_by),
        create_time =values(create_time),
        update_by = values(update_by),
        update_time =values(update_time)