minidaoUpdateSql.ftl 548 B

12345678910111213141516
  1. UPDATE ${tableName}
  2. SET
  3. <#list columnDatas as item>
  4. <#if item.columnKey !='PRI' >
  5. <#if item.columnType == "datetime" ||item.columnType == "date" || item.columnType == "timestamp">
  6. ${"<#if"} ${lowerName}.${item.domainPropertyName} ${"?exists>"}
  7. ${item.columnName} = :${lowerName}.${item.domainPropertyName},
  8. ${"</#if>"}
  9. <#else>
  10. ${"<#if"} ${lowerName}.${item.domainPropertyName} ${"?exists>"}
  11. ${item.columnName} = :${lowerName}.${item.domainPropertyName},
  12. ${"</#if>"}
  13. </#if>
  14. </#if>
  15. </#list>
  16. WHERE id = ${":"}${lowerName}.id