mapper.xml.ftl 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  3. <mapper namespace="${package.Mapper}.${table.mapperName}">
  4. <#if enableCache>
  5. <!-- 开启二级缓存 -->
  6. <cache type="org.mybatis.caches.ehcache.LoggingEhcache"/>
  7. </#if>
  8. <#if baseResultMap>
  9. <!-- 通用查询映射结果 -->
  10. <resultMap id="BaseResultMap" type="${package.Entity}.${entity}">
  11. <#list table.fields as field>
  12. <#if field.keyFlag><#--生成主键排在第一位-->
  13. <id column="${field.name}" property="${field.propertyName}" />
  14. </#if>
  15. </#list>
  16. <#list table.commonFields as field><#--生成公共字段 -->
  17. <result column="${field.name}" property="${field.propertyName}" />
  18. </#list>
  19. <#list table.fields as field>
  20. <#if !field.keyFlag><#--生成普通字段 -->
  21. <result column="${field.name}" property="${field.propertyName}" />
  22. </#if>
  23. </#list>
  24. </resultMap>
  25. </#if>
  26. <#if baseColumnList>
  27. <!-- 通用查询结果列 -->
  28. <sql id="Base_Column_List">
  29. <#list table.commonFields as field>
  30. ${field.name},
  31. </#list>
  32. ${table.fieldNames}
  33. </sql>
  34. </#if>
  35. </mapper>