SpringBootCodeGenerator icon indicating copy to clipboard operation
SpringBootCodeGenerator copied to clipboard

建议添加batchInsert代码生成

Open l543227182 opened this issue 3 years ago • 3 comments

建议添加batchInsert代码生成

l543227182 avatar Apr 16 '22 09:04 l543227182

亲你好,有没有batchInsert的模板可以share一下,这样可以更好的增加

moshowgame avatar Jan 01 '23 15:01 moshowgame

mybatis的批量新增生成,供参考,生成的代码可能需自行移除一些无需的字段。
<insert id="batchInsert" parameterType="${packageName}.entity.${classInfo.className}">
    INSERT INTO ${classInfo.originTableName}
    <#if classInfo.fieldList?exists && classInfo.fieldList?size gt 0>
        (
        <#list classInfo.fieldList as fieldItem >
            <#if fieldItem.columnName != "id" >
                ${fieldItem.columnName}<#if fieldItem_has_next>,</#if>
            </#if>
        </#list>
        )
    </#if>
    VALUES
    <#if classInfo.fieldList?exists && classInfo.fieldList?size gt 0>
        <foreach collection="list" index="index" item="item" separator=",">
            (
            <#list classInfo.fieldList as fieldItem >
                <#if fieldItem.columnName != "id" >
                    ${r"#{item."}${fieldItem.fieldName}${r"}"}<#if fieldItem_has_next>,</#if>
                </#if>
            </#list>
            )
        </foreach>
    </#if>
</insert>

lvgongyi avatar Jul 31 '23 06:07 lvgongyi