【C017100】现有两个实体类User.java和Address.java,代码片段如下:
public class User {
private Integer id;
private String userName;
private String userCode;
private String userPassword;
private List<Address> addressList;
….
}
public class Address {
private Integer id;
private Integer postCode;
private String addressContent;
….
}
现在需要做一个连表查询(address表中有一个userId的字段,关联user表的主键id),根据用户id来获取该用户的地址列表,部分代码如下,请补全空白处的代码( )。
<resultMap type="User" id="userMap">
<id property="id" column="userId"/>
<collection property="__(1)__" ofType="__(2)__">
<id property="id" column="__(3)__"/>
<result property="postCode" column="postCode"/>
<result property="addressContent" column="addressContent"/>
</collection>
</resultMap>
<select id="getAddressListByUserId" parameterType="User" resultMap="userMap">
select *,a.id as a_id from user u,address a where u.id=a.userId and u.id=#{id}
</select>