springboot-mybatis该如何映射实体类中包含的实体类
先来看两个实体类:
实体类 ProductInfo.java 如下:
package com.hkl.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.springframework.stereotype.Component;
@Component
@Data
@AllArgsConstructor
@NoArgsConstructor
public class ProductInfo {
private int id;
private String code;
private String name;
private ProductType tid;
}
实体类 ProductType .java 如下:
package com.hkl.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.springframework.stereotype.Component;
@Component
@Data
@AllArgsConstructor
@NoArgsConstructor
public class ProductType {
private int id;
private String name;
private String type_id;
}
我们可以使用 resultMap 中的 association 来写明映射关系,代码如下:
<resultMap id="ProductInfoMap" type="ProductInfo">
<id column="id" property="id" />
<result column="code" property="code" />
<result column="name" property="name" />
<!-- association中 ,property:tid在ProductInfo对应的属性名,javaType:tid属于哪个类 -->
<association column="tid" property="tid" javaType="com.hkl.pojo.ProductType">
<!-- 下面的result中,column:数据库type的字段名,property:在实体类ProductType中属性名,这两者相互对应 -->
<result column="type_id" property="type_id" />
</association>
</resultMap>
<select id="queryProductInfoByCode" resultMap="ProductInfoMap" parameterType="String">
select id,code,name,type.type_id
from removed,type
where type.type_id = (select tid from removed_products where code = #{code})
and code = #{code};
</select>