<select id="findAll" resultType="AdminEmp">
select *from
emp e
LEFT JOIN admin a on
e.ename =a.username
</select>
<resultMap id="AdminEmp" type="AdminEmp">
<!-- 多对多关联 -->
<association property="Admin" column="id" javaType="Admin" ></association>
<collection property="Admin" ofType="Admin">
<id property="id" column="id"/>
<result property="id" column="id"/>
<result property="username" column="username"/>
<result property="password" column="password"/>
<result property="nickname" column="nickname"/>
</collection>
</resultMap>
```xml配置
domin里面代码
public class AdminEmp extends Emp{ private Admin admin; public Admin getAdmin() { return admin; } public void setAdmin( Admin admin) { this.admin = admin; }
} ```运行不报错,就是只能取到emp的属性,无法自动获取或者封装admin,求一个正确的xml
改一下然后有问题再联系
public class AdminEmp extends Emp{
private List<Admin> listAdmin;
public List<Admin> getAdmin() {
return listAdmin;
}
public void setAdmin(List<Admin> listAdmin) {
this.listAdmin = listAdmin;
} ;
}
<mapper namespace="cn.****.mapper.AdminEmpMapper">
<!-- List<"AdminEmp"> findAll(); -->
<select id="findAll" resultMap="AdminEmp">
select *from
emp e
LEFT JOIN admin a on
e.ename =a.username
</select>
<resultMap id="AdminEmp" type="cn.****.domain.AdminEmp">
<!-- 多对多关联 -->
<collection property="admin" ofType="admin">
<id property="id" column="id"/>
<result property="username" column="username"/>
<result property="password" column="password"/>
<result property="nickname" column="nickname"/>
</collection>
</resultMap>
查询结果[Emp[eid=null, ename=null, sex=null, address=null, tel=null, card=null]]****** 麻烦您了再给看看,谢谢哈