// User.java
public class User {
    private int id;
    private String name;
    private Address address;  // 一對(duì)一關(guān)聯(lián)

    // getters and setters
}

// Address.java
public class Address {
    private int id;
    private String street;
    private String city;

    // getters and setters
}

<!-- Address resultMap -->
<resultMap id="addressResultMap" type="com.example.Address">
    <result property="id" column="address_id"/>
    <result property="street" column="street"/>
    <result property="city" column="city"/>
</resultMap>

<!-- User resultMap -->
<resultMap id="userResultMap" type="com.example.User">
    <id property="id" column="user_id"/>
    <result property="name" column="user_name"/>
    <association property="address" resultMap="addressResultMap"/>
</resultMap>

<select id="findUserWithAddress" resultMap="userResultMap">
    SELECT u.user_id, u.user_name, a.address_id, a.street, a.city
    FROM users u
    LEFT JOIN address a ON u.user_id = a.user_id
    WHERE u.user_id = #{userId}
</select>

User user = new User();
user.setId(1);
user.setName("Alice");

Address address = new Address();
address.setId(1);
address.setStreet("123 Main");
address.setCity("NYC");

user.setAddress(address);

// User.java
public class User {
    private int userId;
    private String userName;

    // getters and setters
}

// Org.java
public class Org {
    private int orgId;
    private String orgName;
    private List<User> users;  // 一對(duì)多關(guān)聯(lián)

    // getters and setters
}

<!-- User resultMap -->
<resultMap id="userResultMap" type="com.example.User">
    <result property="userId" column="user_id"/>
    <result property="userName" column="user_name"/>
</resultMap>

<!-- Org resultMap -->
<resultMap id="orgResultMap" type="com.example.Org">
    <result property="orgId" column="org_id"/>
    <result property="orgName" column="org_name"/>
    <association property="users" resultMap="userResultMap"/>
</resultMap>

<select id="findOrgWithUsers" resultMap="orgResultMap">
    SELECT o.org_id, o.org_name, u.user_id, u.user_name
    FROM org o
    LEFT JOIN users u ON o.org_id = u.org_id
</select>

List<Org> orgs = new ArrayList<>();

// org 1
Org org1 = new Org();
org1.setOrgId(101);
org1.setOrgName("Finance");

User user1 = new User();
user1.setUserId(1);
user1.setUserName("Alice");

User user2 = new User();
user2.setUserId(2);
user2.setUserName("Bob");

org1.setUsers(Arrays.asList(user1, user2));

// org 2
Org org2 = new Org();
org2.setOrgId(102);
org2.setOrgName("HR");

User user3 = new User();
user3.setUserId(3);
user3.setUserName("Carol");

org2.setUsers(Arrays.asList(user3));

// 添加到列表
orgs.add(org1);
orgs.add(org2);