JeecgMinidaoDao_getAllEntities.sql 881 B

12345678910111213141516171819202122232425262728
  1. SELECT * FROM jeecg_demo WHERE 1=1
  2. <#if jeecgDemo.name ?exists && jeecgDemo.name ?length gt 0>
  3. and name = :jeecgDemo.name
  4. </#if>
  5. <#if jeecgDemo.age ?exists && jeecgDemo.age ?length gt 0>
  6. and age = :jeecgDemo.age
  7. </#if>
  8. <#if jeecgDemo.depId ?exists && jeecgDemo.depId ?length gt 0>
  9. and dep_id = :jeecgDemo.depId
  10. </#if>
  11. <#if jeecgDemo.email ?exists && jeecgDemo.email ?length gt 0>
  12. and email = :jeecgDemo.email
  13. </#if>
  14. <#if jeecgDemo.phone ?exists && jeecgDemo.phone ?length gt 0>
  15. and phone = :jeecgDemo.phone
  16. </#if>
  17. <#if jeecgDemo.salary ?exists && jeecgDemo.salary ?length gt 0>
  18. and salary = :jeecgDemo.salary
  19. </#if>
  20. <#if jeecgDemo.sex ?exists && jeecgDemo.sex ?length gt 0>
  21. and sex = :jeecgDemo.sex
  22. </#if>
  23. <#if jeecgDemo.status ?exists && jeecgDemo.status ?length gt 0>
  24. and status = :jeecgDemo.status
  25. </#if>
  26. <#if authSql ?exists && authSql ?length gt 0>
  27. ${authSql}
  28. </#if>