MybatisPlus resultMap标签collection的注解写法

需求，查询用户，用户对象中包含组织机构简称的List（对象的话selectOrgAbbNameByUsersId 方法返回List对象即可）

public class UserListVo extends BaseVo<User> {

    private String usersId;
    private String name;
    private String usersCode;
    private String usersName;
    private List<String> orgAbbNames;
    private Date creationTime;
    private Date updateTime;
}

添加 @Results注解

    @Results(id = "userListVo",value = {
            @Result(id = true,column ="users_id" ,property ="usersId" ),
            @Result(column = "name" ,property = "name"),
            @Result(column = "users_code",property = "usersCode"),
            @Result(column = "users_name",property = "usersName"),
            @Result(column = "users_id", property = "orgAbbNames" ,javaType=List.class ,many = @Many(select = "selectOrgAbbNameByUsersId")),
            @Result(column = "creation_time",property = "creationTime"),
            @Result(column = "update_time",property = "updateTime")
    })
    @Select("select *  " +
            "FROM  base.t00_users  A " +
            " ${ew.customSqlSegment} ")
    IPage<UserListVo> queryUserListByConditions(Page page, @Param(Constants.WRAPPER) QueryWrapper<UserListVo> orgWrapper);
    @Select("select A.orgz_abb_name " +
            "FROM  public.t01_orgz  A " +
            "LEFT JOIN base.t00_dept B  ON (A.orgz_code = B.orgz_code) " +
            "LEFT JOIN base.t00_dept_users_rel C ON (B.dept_id=C.dept_id) " +
            "WHERE C.users_id = #{usersId} ")
    List<String> selectOrgAbbNameByUsersId (@Param("usersId") String usersId);

查询结果

image.png