**1.UserMapper.java** ~~~ //查詢用戶和用戶關聯的賬號信息 List<User> findAllWithAccount(); ~~~ **2.UserMapper.xml** ~~~ <resultMap id="userMapperWithAccount" type="User"> <id property="id" column="u_id"></id> <result property="name" column="u_name"></result> <result property="password" column="u_password"></result> <!-- collection:表示將集合進行封裝 property:集合屬性名 ofType:集合中封裝的對象類型 --> <collection property="accounts" ofType="Account"> <id property="id" column="aid"></id> <result property="money" column="money"></result> </collection> </resultMap> <select id="findAllWithAccount" resultMap="userMapperWithAccount"> select *,a.id 'aid' from t_user u left join account a on u.u_id = a.uid </select> ~~~ **3.測試語句** ~~~ @Test public void testFindAllWithAccount(){ UserMapper mapper = session.getMapper(UserMapper.class); System.out.println(mapper.findAllWithAccount()); } ~~~