先来看两个实体类:
实体类 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 来写明映射关系,代码如下:
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};



