**1.UserMapper.java** ~~~ //根據id查詢用戶及關聯的所有賬戶信息 User findById1(int id); ~~~ **2.UserMapper.xml** ~~~ <resultMap id="findById1Map" 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="accounts" ofType="Account" select="com.nobb.mapper.AccountMapper.findByUid" column="u_id" fetchType="lazy"> </collection> </resultMap> <select id="findById1" resultMap="findById1Map"> select * from t_user where u_id = #{id} </select> ~~~ **3.AccountMapper.java** ~~~ //通過uid 查詢 List<Account> findByUid(int uid); ~~~ **4.AccountMapper.xml** ~~~ <select id="findByUid" resultType="Account"> select * from account where uid = #{uid} </select> ~~~ **5.測試代碼** ~~~ @Test public void testFindById1(){ UserMapper mapper = session.getMapper(UserMapper.class); System.out.println(mapper.findById1(15)); } ~~~