SpringBoot+MyBatis多表联合查询如何映射数据传到前端

1.实体类加上对象

private User user;

2.Mapper.xml做映射

<resultMap type="SysTenant" id="SysTenantResult">
   <id     property="tenantId"     column="tenant_id"      />
   <result property="tenantName"   column="tenant_name"      />
   <association property="user(实体类对象)"    column="user_id（相关联字段）" javaType="SysUser" resultMap="userResult" />
</resultMap>

<resultMap id="userResult" type="SysUser">
   <id     property="userId"       column="user_id"      />
   <result property="deptId"       column="dept_id"      />
   <result property="userName"     column="user_name"    />
</resultMap>

3.SQL注意驱动表

SELECT
t.tenant_id,
t.tenant_name,
u.user_name,
u.email,
u.phonenumber
FROM
sys_tenant t left join sys_user u
on t.user_id=u.user_id

left左边为驱动表，sql执行时查询左边所有的数据，右边表来做匹配