报错原因:
- 映射的子集合如果有字段与上级字段相同,一定要设置别名;
- resultReMap 映射的实体类,如果设置了有参构造,一定要定义一个空参构造。
业务代码示例
resultReMap
<resultMap id="EleResultMap" type="com.xxx.xxx.xxx.xxx.ElementTree">
<id column="id" jdbcType="BIGINT" property="id"/>
<result column="name" jdbcType="VARCHAR" property="name"/>
<collection property="childrens" notNullColumn="eleId,eleName" ofType="com.sumgrowpower.checkpricing.base.dto.ElementTree">
<result column="eleId" jdbcType="BIGINT" property="id" />
<result column="eleName" jdbcType="VARCHAR" property="name" />
</collection>
</resultMap>
查询sql
<select id="selectEleTree" parameterType="java.lang.String" resultMap="EleResultMap">
select t.id,t.name,ti.id as eleId,ti.name as eleName from `tableName_1` t left join `tableName_2` ti
on ti.category_id = t.id
</select>
映射实体类 ElementTree
public class ElementTree {
private Long id;
private String name;
private List<ElementTree> childrens;
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public List<ElementTree> getChildrens() {
return childrens;
}
public void setChildrens(List<ElementTree> childrens) {
this.childrens = childrens;
}
//定义了有参构造,一定要加空参构造!!
public ElementTree() {
super();
}
public ElementTree(Long id, String name, List<ElementTree> childrens) {
super();
this.id = id;
this.name = name;
this.childrens = childrens;
}
@Override
public String toString() {
return "ElementTree{" +
"id=" + id +
", name='" + name + '\'' +
", childrens=" + childrens +
'}';
}
}
结果展示
{
"id": 1,
"name": "建材类",
"childrens": [
{
"id": 1,
"name": "石子",
"childrens": null
},
{
"id": 2,
"name": "沙子",
"childrens": null
},
{
"id": 3,
"name": "水泥",
"childrens": null
}
]
},
{
"id": 2,
"name": "家具类",
"childrens": [
{
"id": 4,
"name": "桌子",
"childrens": null
},
{
"id": 5,
"name": "床",
"childrens": null
},
{
"id": 6,
"name": "洗衣机",
"childrens": null
},
{
"id": 7,
"name": "冰箱",
"childrens": null
}
]
}