Mybatis（7）：返回结果封装ResulMap的高级属性--Collection标签

Address.java：

package com.smbms.entities;import java.util.Date;public class Address { private Integer id; private String postCode; private String contact; private String tel; private Integer createBy; private Date creationDate; private String modify; private Date modifyDate; private String AddressDesc; public String getAddressDesc() { return AddressDesc; } public void setAddressDesc(String addressDesc) { AddressDesc = addressDesc; } public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getPostCode() { return postCode; } public void setPostCode(String postCode) { this.postCode = postCode; } public String getContact() { return contact; } public void setContact(String contact) { this.contact = contact; } public String getTel() { return tel; } public void setTel(String tel) { this.tel = tel; } public Integer getCreateBy() { return createBy; } public void setCreateBy(Integer createBy) { this.createBy = createBy; } public Date getCreationDate() { return creationDate; } public void setCreationDate(Date creationDate) { this.creationDate = creationDate; } public String getModify() { return modify; } public void setModify(String modify) { this.modify = modify; } public Date getModifyDate() { return modifyDate; } public void setModifyDate(Date modifyDate) { this.modifyDate = modifyDate; } @Override public String toString() { return "Address [id=" + id + ", postCode=" + postCode + ", contact=" + contact + ", tel=" + tel + ", createBy=" + createBy + ", creationDate=" + creationDate + ", modify=" + modify + ", modifyDate=" + modifyDate + "]"; } public Address(Integer id, String postCode, String contact, String tel, Integer createBy, Date creationDate, String modify, Date modifyDate) { super(); this.id = id; this.postCode = postCode; this.contact = contact; this.tel = tel; this.createBy = createBy; this.creationDate = creationDate; this.modify = modify; this.modifyDate = modifyDate; } public Address() { super(); // TODO 自动生成的构造函数存根 } }

（2）在接口类UserMapper.java中进行方法定义：

package com.smbms.dao;import java.util.List;import java.util.Map;import org.apache.ibatis.annotations.Param;import com.smbms.entities.User;public interface UserMapper { public List getAddressListByUserId(@Param("id") Integer userId); }

（3）在sql映射文件 UserMapper.xml 完成配置：

select u.* , a.id as a_id ,a.contact,a.addressDesc,a.tel,a.postCode from smbms_user u,smbms_address a where u.userRole=#{UserRole} and u.userRole=r.id

（4）在全局配置文件注册映射文件：

（5）编写单元测试UserTest：

package com.smbms.entities;import java.io.IOException;import java.io.InputStream;import java.text.ParseException;import java.text.SimpleDateFormat;import java.util.ArrayList;import java.util.Date;import java.util.HashMap;import java.util.List;import java.util.Map;import org.apache.ibatis.annotations.Param;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import org.junit.Test;import com.smbms.dao.ProviderMapper;import com.smbms.dao.UserMapper;public class UserTest { public SqlSession getSqlSession() throws IOException{ String resource = "mybatis-config.xml"; InputStream inputStream = Resources.getResourceAsStream(resource); SqlSessionFactory build = new SqlSessionFactoryBuilder().build(inputStream); SqlSession openSession = build.openSession(); return openSession; } //collection标签对应于User的一个对象属性的列表 @Test public void test12() throws IOException{ System.out.println("===============test add!"); List userlist = new ArrayList (); User user = new User(); int count = 0; SqlSession sqlSession = getSqlSession(); UserMapper mapper = sqlSession.getMapper(UserMapper.class); try{ userlist = mapper.getAddressListByUserId(4); for(User u: userlist){ List