JeecgP3demoDao_update.sql 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. UPDATE jeecg_p3demo
  2. SET
  3. <#if jeecgP3demo.createName ?exists>
  4. create_name = :jeecgP3demo.createName,
  5. </#if>
  6. <#if jeecgP3demo.createBy ?exists>
  7. create_by = :jeecgP3demo.createBy,
  8. </#if>
  9. <#if jeecgP3demo.createDate ?exists>
  10. create_date = :jeecgP3demo.createDate,
  11. </#if>
  12. <#if jeecgP3demo.updateName ?exists>
  13. update_name = :jeecgP3demo.updateName,
  14. </#if>
  15. <#if jeecgP3demo.updateBy ?exists>
  16. update_by = :jeecgP3demo.updateBy,
  17. </#if>
  18. <#if jeecgP3demo.updateDate ?exists>
  19. update_date = :jeecgP3demo.updateDate,
  20. </#if>
  21. <#if jeecgP3demo.sysOrgCode ?exists>
  22. sys_org_code = :jeecgP3demo.sysOrgCode,
  23. </#if>
  24. <#if jeecgP3demo.sysCompanyCode ?exists>
  25. sys_company_code = :jeecgP3demo.sysCompanyCode,
  26. </#if>
  27. <#if jeecgP3demo.bpmStatus ?exists>
  28. bpm_status = :jeecgP3demo.bpmStatus,
  29. </#if>
  30. <#if jeecgP3demo.name ?exists>
  31. name = :jeecgP3demo.name,
  32. </#if>
  33. <#if jeecgP3demo.sex ?exists>
  34. sex = :jeecgP3demo.sex,
  35. </#if>
  36. <#if jeecgP3demo.age ?exists>
  37. age = :jeecgP3demo.age,
  38. </#if>
  39. <#if jeecgP3demo.address ?exists>
  40. address = :jeecgP3demo.address,
  41. </#if>
  42. <#if jeecgP3demo.phone ?exists>
  43. phone = :jeecgP3demo.phone,
  44. </#if>
  45. <#if jeecgP3demo.memo ?exists>
  46. memo = :jeecgP3demo.memo,
  47. </#if>
  48. WHERE id = :jeecgP3demo.id