首页 试题广场 > 试题详情
单选题

【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>

  • A.Address
    addressList
    a_id
  • B.addressList
    Address
    a_id
  • C.addressList
    List
    a_id
  • D.addressList
    Address
    id
提交并查看答案
下一题 上一题
Ke星伙伴们的回答/ 6个回答
关闭
关闭

了解
畅学卡

手机端
学习