plus.mapper.xml.btl Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of jackpanz-spring-core-jdk17 Show documentation
The newest version!
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="${package.Mapper}.${table.mapperName}">

<% if(enableCache){ %>
    <!-- 开启二级缓存 -->
    <cache type="org.mybatis.caches.ehcache.LoggingEhcache"/>

<% } %>
<% if(baseResultMap){ %>
    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="${package.Entity}.${entity}">
<% for(field in table.fields){ %>
   <% /** 生成主键排在第一位 **/ %>
   <% if(field.keyFlag){ %>
        <id column="${field.name}" property="${field.propertyName}" />
   <% } %>
<% } %>
<% for(field in table.commonFields){ %>
    <% /** 生成公共字段 **/ %>
    <result column="${field.name}" property="${field.propertyName}" />
<% } %>
<% for(field in table.fields){ %>
   <% /** 生成普通字段 **/ %>
   <% if(!field.keyFlag){ %>
        <result column="${field.name}" property="${field.propertyName}" />
   <% } %>
<% } %>
    </resultMap>
<% } %>
<% if(baseColumnList){ %>
    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
<% for(field in table.commonFields){ %>
        ${field.name},
<% } %>
        ${table.fieldNames}
    </sql>

<% } %>

    <sql id="Base_Alias_Column_List">
        <%for(field in table.fields){ %>${cfg.entityName}.${field.name} as ${cfg.entityName}_${field.name}${fieldLP.last?"":"," }<%}%>
    </sql>

    <resultMap id="selectSimpleResultMap" type="java.util.HashMap">
        <id column="id" property="id" jdbcType="INTEGER"/>
        <association  property="${cfg.entityName}" columnPrefix="${cfg.entityName}_"
                      resultMap="${package.Mapper}.${table.mapperName}.BaseResultMap"/>
    </resultMap>

    <select id="selectSimple" resultMap="${package.Mapper}.${table.mapperName}.BaseResultMap" >
        select <include refid="${package.Mapper}.${table.mapperName}.Base_Column_List"/> from ${table.name}
    </select>

    <select id="selectMapSimple" resultMap="${package.Mapper}.${table.mapperName}.selectSimpleResultMap" >
        select <include refid="${package.Mapper}.${table.mapperName}.Base_Alias_Column_List"/> from ${table.name} as ${cfg.entityName}
    </select>

</mapper>