SpringBootCodeGenerator
SpringBootCodeGenerator copied to clipboard
建议添加batchInsert代码生成
建议添加batchInsert代码生成
亲你好,有没有batchInsert的模板可以share一下,这样可以更好的增加
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>