Mybatis 数据表的一对多查询

1、给用户数据类添加接受账户表数据的集合

因为是一条用户可以对应多个账户，所以我们需要创建一个集合来接受账户数据。

public class User implements Serializable{

    private Integer id;
    private String username;
    private Date birthday;
    private String sex;
    private String address;
    private List<Account> accounts;

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

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

    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 Date getBirthday() {
        return birthday;
    }

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

    public String getSex() {
        return sex;
    }

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

    public String getAddress() {
        return address;
    }

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

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

2、修改映射文件来对一对多进行配置

使用左外连接查询用户表和账户表数据：

select *from user u left outer join account a on u.id=a.uid;

查询出如下信息

<resultMap id="resultfindAll" type="com.itheima.domain.User">
        <id property="id" column="id"></id>
        <result property="username" column="username"></result>
        <result property="sex" column="sex"></result>
        <result property="birthday" column="birthday"></result>
        <result property="address" column="address"></result>
        <collection property="accounts" ofType="com.itheima.domain.Account">
            <id property="id" column="aid"></id>
            <result property="uid" column="uid"></result>
            <result property="money" column="money"></result>
        </collection>
    </resultMap>
    <!--配置查询所有-->
    <select id="findAll" resultMap="resultfindAll">
        select *from user u left outer join account a on u.id=a.uid;
    </select>

2.1 使用注解版一对多查询

具体解释见一对一查询博客
这里使用Many，而不再使用One，同时使用延迟加载

@Select("select * from user")
    @Results(id = "accountMap", value = {
            @Result(id = true, column = "id", property = "id"),
            @Result(column = "username", property = "username"),
            @Result(column = "sex",property = "sex"),
            @Result(column = "birthday", property = "birthday"),
            @Result(column = "sex", property = "sex"),
            @Result(column = "address", property = "address"),
            @Result(column = "id", property = "accounts",many = @Many(select = "com.itheima.dao.IAccount.findByUid", fetchType = FetchType.LAZY))
    })
    List<User> findAll();

3、测试

 @Test
    public void testSearchById() throws IOException {

        //5.使用代理对象执行方法
        List<User> users = userDao.findAll();
        for(User user : users){
            System.out.println(user);
            System.out.println(user.getAccounts());
        }

    }

结果如下所示，有的用户有两个账户，有的一个，有的没有账户。