minidaoInsertSql.ftl 767 B

12345678910111213141516171819202122
  1. INSERT INTO
  2. ${tableName}
  3. (
  4. <#list columnDatas as item>
  5. <#assign x="${item.columnName?length}" />
  6. <#if item_index==0>
  7. ${" "}${item.columnName}${" "?substring(item.columnName?length)}
  8. <#elseif item_index gt 0>
  9. ${" "},${item.columnName}${" "?substring(item.columnName?length)}
  10. </#if>
  11. </#list>
  12. )
  13. values
  14. (
  15. <#list columnDatas as item>
  16. <#if item_index==0>
  17. ${" "}${":"}${lowerName}.${item.domainPropertyName}${" "?substring(item.domainPropertyName?length)}
  18. <#elseif item_index gt 0>
  19. ${" "},${":"}${lowerName}.${item.domainPropertyName}${" "?substring(item.domainPropertyName?length)}
  20. </#if>
  21. </#list>
  22. )