MyBatis中连接查询

数据库中：device表的id_user列参照users表的主键id

    <resultMap type="User" id="userResultMap">
        <id column="id" property="id"/>
        <result column="tel" property="tel"/>
        <result column="num_fan" property="numFan"/>
        <result column="type" property="type"/>
        <result column="is_accept_faned" property="isAcceptFaned"/>
    </resultMap>

    <resultMap type="Device" id="deviceResultMap">
        <id column="id" property="id" />
        <result column="imei" property="imei" />
        <result column="imsi" property="imsi" />
        <result column="channel" property="channel" />
        <association column="id_user" property="user" select="queryUser"/>
    </resultMap>

    <select id="queryUser" resultMap="userResultMap">
        select * from users where id=#{id}
    </select>

在deviceResultMap中添加
<association column="id_user" property="user" select="queryUser"/>
意思是，在device表中查询id_user列，映射为user属性，在映射时通过queryUser查询，select * from users where id=#{id}这里的#{id}可以为任意字符串，#{xxx}，也是可以的。实际上执行的是

select * from users where id = id_user(此处为查询出来的id_user列的值)