java - Mybatis+查询的结果集难道还要经过二次处理？不会吧？怎么优化？

Question

能不能把另一个表（deparment）的字段dname，放到和用户表（Users）的字段id、name、did同级的地方？？？？

Answer 1

改一下 UsersMapper.xml:

<mapper namespace="com.xujl.myspring.mapper.UsersMapper">
    <select id="findById" resultMap="UserList" parameterType="java.lang.Long">
        select u.*, d.dname from users u 
        left join deparment d on u.did=d.id 
        where u.did = #{id}
    </select>

    <resultMap id="UserList" type="com.xujl.myspring.entity.Users">
        <result property="id" column="id"/>
        <result property="name" column="name"/>
        <result property="did" column="did"/>
        <result property="dname" column="dname"/>
    </resultMap>
</mapper>

Users类:

public class Users {
    private Long id;
    private String name;
    private Long did;
    private String dname;  // 新增字段
    
    // getter和setter方法
}