Mybatis的resultmap的继承、关联

1
2
3
4
5
6
7
8
9
10
@Data
@NoArgsConstructor
public class KeyBase {
  private String recseq;
  private String source;
  private String keyPart;
  private String supplier;
  private String comment;
}

1
2
3
4
5
6
7
8
<resultMap id="KeyBaseMap" type="com.xx.yy.KeyBase">
    <id column="b_recseq" jdbcType="VARCHAR" property="recseq" />
    <result column="source" jdbcType="VARCHAR" property="source" />
    <result column="keyPart" jdbcType="VARCHAR" property="keyPart" />
    <result column="supplier" jdbcType="VARCHAR" property="supplier" />
    <result column="comment" jdbcType="VARCHAR" property="comment" />
  </resultMap>

1
2
3
4
5
6
7
8

@NoArgsConstructor
@Data
public class KeyRawDetail extends T96PdLog {
   private KeyBase keyExtInfo;
   private String sn;
}

1
2
3
4
5
6
7
8
9
<resultMap id="RawDataMap" type="com.xx.yy.entity.KeyRawDetail"
             extends="com.xx.yy.dao.T96PdLogMapper.BaseResultMap">
    <result column="sn" jdbcType="VARCHAR" property="sn" />
    <association property="keyExtInfo"
                 column="recseq"
                 resultMap="KeyBaseMap"
                 />
  </resultMap>

1
2
3
4
<select id="getRawData" resultMap="RawDataMap">
        select * from rawdata order by f96_mgtbarcd;
  </select>