public class User implements Serializable{
    private Integer id;
    private String username;
    private String address;
    private String sex;
    private Date birthday;

    //一對(duì)多映射關(guān)系，主表實(shí)體含有從表實(shí)體的集合引用
    private List<Account> accounts;

    public List<Account> getAccounts() {
        return accounts;
    }

    public void setAccounts(List<Account> accounts) {
        this.accounts = accounts;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", address='" + address + '\'' +
                ", sex='" + sex + '\'' +
                ", birthday=" + birthday +
                '}';
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }
}

public interface IUserDao {
    /**
     * 查詢所有操作,并攜帶賬戶信息
     * @return
     */
    List<User> findAll();

    /**
     * 根據(jù)id查詢一個(gè)用戶
     * @param uid
     */
    User findById(Integer uid);


}

public interface IAccountDao {
    /**
     * 查詢所有賬戶
     * @return
     */
    List<Account> findAll();

    /**
     * 根據(jù)用戶id查詢賬戶
     * @param uid
     * @return
     */
    List<Account> findByUid(Integer uid);

}

<mapper namespace="com.cc.dao.IUserDao">
    <!--定義resultMap-->
    <!--因?yàn)樵谥髋渲梦募信渲昧薲omain包下的所有實(shí)體類別名，所以這里封裝類型只需要寫實(shí)體類名即可，不分大小寫-->
    <resultMap id="userWithAccount" type="user">
        <!--封裝user對(duì)象-->
        <id property="id" column="id"></id>
        <result property="username" column="username"></result>
        <result property="address" column="address"></result>
        <result property="sex" column="sex"></result>
        <result property="birthday" column="birthday"></result>
        <!--配置user隊(duì)形中account集合的映射-->
        <!--定義一對(duì)多的關(guān)系映射，實(shí)現(xiàn)對(duì)account的封裝，用collection標(biāo)簽
        ofType屬性指定內(nèi)容：要封裝的實(shí)體對(duì)象類型
        select屬性指定內(nèi)容：查詢用戶的唯一標(biāo)識(shí)
        column屬性指定內(nèi)容：用戶根據(jù)id查詢是所需要的參數(shù)
        -->
        <collection property="accounts" ofType="account" column="id" select="com.cc.dao.IAccountDao.findByUid"></collection>
    </resultMap>
    <!--查詢所有-->
    <select id="findAll" resultMap="userWithAccount">
        select * from user
    </select>
    <!--根據(jù)id查詢一個(gè)用戶-->
    <select id="findById" parameterType="java.lang.Integer" resultType="user">
        select * from user where id=#{uid};
    </select>
</mapper>

<!--配置參數(shù)-->
    <settings>
        <!--開(kāi)啟Mybatis支持延時(shí)加載-->
        <setting name="lazyLoadingEnabled" value="true"/>
        <setting name="aggressiveLazyLoading" value="false"></setting>
    </settings>
    <!--配置domain包下所有實(shí)體類別名-->
    <typeAliases>
        <!--<typeAlias type="com.cc.domain.User" alias="user"></typeAlias>-->
        <package name="com.cc.domain"></package>
    </typeAliases>

public class UserTest {
    private InputStream in;
    private SqlSessionFactory factory;
    private SqlSession sqlSession;
    private IUserDao userDao;
    @Before//在測(cè)試方法執(zhí)行之前執(zhí)行
    public void init() throws IOException {
        //1.讀取配置文件，生成字節(jié)輸入流
         in = Resources.getResourceAsStream("SqlMapConfig.xml");
        //2.生成SqlSessionFactory
         factory = new SqlSessionFactoryBuilder().build(in);
        //3.獲取SqlSession
         sqlSession = factory.openSession();
        //4.獲取dao的代理對(duì)象
         userDao = sqlSession.getMapper(IUserDao.class);
    }
    @After//在測(cè)試方法執(zhí)行之后執(zhí)行
    public void destory() throws IOException {
        //提交事務(wù)
        sqlSession.commit();
        //關(guān)閉資源
        sqlSession.close();
        in.close();
    }

    /**
     * 測(cè)試查詢所有賬戶
     */
    @Test
    public void TestFindAll() {
        //5.執(zhí)行查詢所有方法
        List<User> userList = userDao.findAll();
       for (User user : userList) {
           System.out.println(user);
            System.out.println(user.getAccounts());
        }

    }

}

public class Account implements Serializable {
    private Integer id;
    private Integer uid;
    private Double money;
    //從表實(shí)體應(yīng)該包含一個(gè)主表實(shí)體的對(duì)象引用
    private User user;

    public User getUser() {
        return user;
    }

    public void setUser(User user) {
        this.user = user;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public Integer getUid() {
        return uid;
    }

    public void setUid(Integer uid) {
        this.uid = uid;
    }

    public Double getMoney() {
        return money;
    }

    public void setMoney(Double money) {
        this.money = money;
    }

    @Override
    public String toString() {
        return "Account{" +
                "id=" + id +
                ", uid=" + uid +
                ", money=" + money +
                '}';
    }
}

<mapper namespace="com.cc.dao.IAccountDao">
    <!--開(kāi)啟account支持二級(jí)緩存-->
    <cache/>
    <!--定義封裝account和user的resultMap-->
    <resultMap id="accountAndUser" type="account">
        <id property="id" column="aid"></id>
        <result property="uid" column="uid"></result>
        <result property="money" column="money"></result>
        <!--定義一對(duì)一的關(guān)系映射，實(shí)現(xiàn)對(duì)user的封裝
        select屬性指定內(nèi)容：查詢用戶的唯一標(biāo)識(shí)
        column屬性指定內(nèi)容：用戶根據(jù)id查詢是所需要的參數(shù)
        fetchType屬性指定內(nèi)容：lazy延時(shí)加載，eager立即加載。
        -->
        <association property="user" column="uid" javaType="user" select="com.cc.dao.IUserDao.findById" fetchType="eager"></association>
    </resultMap>
    <!--查詢所有-->
    <select id="findAll" resultMap="accountAndUser">
        SELECT * from account
    </select>
    <!--根據(jù)用戶id查詢-->
    <select id="findByUid" parameterType="java.lang.Integer" resultType="account" useCache="true">
        select * from account where uid = #{uid}
    </select>
</mapper>