mybatis 连表查询

xml:

<resultMap type="com.ExportStaffDto" id="StaffDto">
     <result property="appointCityName" column="appoint_city_name"/>
 </resultMap>



 <select id="ExportStaffList" resultMap="StaffDto">
    SELECT s.id                    AS id,
          c.name                  AS appoint_city_name
       FROM staff s
                     LEFT JOIN customer_appoint ca ON s.appoint = ca.id
</select>

java:

import cn.afterturn.easypoi.excel.annotation.Excel;

public class ExportStaffDto {

    @ApiModelProperty("委托地")
    @Excel(name = "委托地", fixedIndex = 3, orderNum = "3")
    private String appointCityName;

}