mybatis中resultMap无法合并部分数据

[景培培哎]

我的数据分为三个表，但是其中一个表的数据用resultMap无法合并起来，想请教各位大神，这应该怎么解决？
代码如下：
mapper：

<resultMap id="GroupOfOrder" type="com.chenjiabao.takeaway.entity.GroupOfOrder">
        <id property="id" column="id" jdbcType="INTEGER"/>
        <result property="orderId" column="order_id" jdbcType="VARCHAR"/>
        <result property="note" column="note" jdbcType="VARCHAR"/>
        <result property="openid" column="openid" jdbcType="VARCHAR"/>

        <collection property="cartes" ofType="com.chenjiabao.takeaway.entity.SysCarte">
            <id column="carte_id" property="id" jdbcType="INTEGER"/>
            <result property="dishname" column="carte_dishName" jdbcType="VARCHAR"/>
            <result property="price" column="carte_price" jdbcType="NUMERIC"/>
            <result property="material" column="carte_Material" jdbcType="VARCHAR"/>
            <result property="classification" column="carte_classification" jdbcType="VARCHAR"/>
            <result property="specification" column="carte_specification" jdbcType="VARCHAR"/>
            <result property="photourl" column="carte_photoUrl" jdbcType="VARCHAR"/>
            <result property="carteNum" column="carte_num" jdbcType="VARCHAR"/>
        </collection>

        <collection property="address" ofType="com.chenjiabao.takeaway.entity.UserAddress">
            <id column="address_id" property="id" jdbcType="INTEGER"/>
            <result property="name" column="address_name" jdbcType="VARCHAR"/>
            <result property="phone" column="address_phone" jdbcType="VARCHAR"/>
            <result property="province" column="address_province" jdbcType="VARCHAR"/>
            <result property="city" column="address_city" jdbcType="VARCHAR"/>
            <result property="area" column="address_Area" jdbcType="VARCHAR"/>
            <result property="address" column="address_Address" jdbcType="VARCHAR"/>
            <result property="sex" column="address_sex" jdbcType="VARCHAR"/>
        </collection>
    </resultMap>



   <!-- 查询语句 -->
 <select id="query" resultMap="GroupOfOrder">
        select so.id,
               so.order_id,

               sc.id as 'carte_id',
               sc.dishName as 'carte_dishName',
               sc.price as 'carte_price',
               sc.Material as 'carte_Material',
               sc.classification as 'carte_classification',
               sc.specification as 'carte_specification',
               sc.photoUrl as 'carte_photoUrl',

               ua.id as 'address_id',
               ua.name as 'address_name',
               ua.phone as 'address_phone',
               ua.province as 'address_province',
               ua.city as 'address_city',
               ua.Area as 'address_Area',
               ua.Address as 'address_Address',
               ua.sex as 'address_sex',

               so.carte_num,
               so.note,
               so.openid
        from sys_order so,
             sys_carte sc,
             user_address ua
        where so.carte_id = sc.id
          and so.address_id = ua.id
    </select>

GroupOfOrder实体类：

   /**
     * 地址
     */
    private UserAddress address;
    /**
     * 主键
     */
    private Integer id;
    /**
     * 订单编号
     */
    private String orderId;
    /**
     * 所选菜品及个数
     */
    private List<SysCarte> cartes;
    /**
     * 总价
     */
    private Double totalprice;
    /**
     * 备注
     */
    private String note;
    /**
     * openid
     */
    private String openid;

    public UserAddress getAddress() {
        return address;
    }

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

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getOrderId() {
        return orderId;
    }

    public void setOrderId(String orderId) {
        this.orderId = orderId;
    }

    public List<SysCarte> getCartes() {
        return cartes;
    }

    public void setCartes(List<SysCarte> cartes) {
        this.cartes = cartes;
    }

    public Double getTotalprice() {
        return totalprice;
    }

    public void setTotalprice(Double totalprice) {
        this.totalprice = totalprice;
    }

    public String getNote() {
        return note;
    }

    public void setNote(String note) {
        this.note = note;
    }

    public String getOpenid() {
        return openid;
    }

    public void setOpenid(String openid) {
        this.openid = openid;
    }

    @Override
    public boolean equals(Object o) {
        if (this == o) return true;

        if (!(o instanceof GroupOfOrder)) return false;

        GroupOfOrder that = (GroupOfOrder) o;

        return new EqualsBuilder()
                .append(getAddress(), that.getAddress())
                .append(getId(), that.getId())
                .append(getOrderId(), that.getOrderId())
                .append(getCartes(), that.getCartes())
                .append(getTotalprice(), that.getTotalprice())
                .append(getNote(), that.getNote())
                .append(getOpenid(), that.getOpenid())
                .isEquals();
    }

    @Override
    public int hashCode() {
        return new HashCodeBuilder(17, 37)
                .append(getAddress())
                .append(getId())
                .append(getOrderId())
                .append(getCartes())
                .append(getTotalprice())
                .append(getNote())
                .append(getOpenid())
                .toHashCode();
    }

    @Override
    public String toString() {
        return "GroupOfOrder{" +
                "address=" + address +
                ", id=" + id +
                ", orderId='" + orderId + '\'' +
                ", cartes=" + cartes +
                ", totalprice=" + totalprice +
                ", note='" + note + '\'' +
                ", openid='" + openid + '\'' +
                '}';
    }

(SysCarte)实体类：

public class SysCarte implements Serializable {
    private static final long serialVersionUID = -79961121051443787L;
    /**
    * 主键
    */
    private Integer id;
    /**
    * 菜名
    */
    private String dishname;
    /**
    * 价格
    */
    private Double price;
    /**
    * 所用材料
    */
    private String material;
    /**
    * 菜品分类
    */
    private String classification;
    /**
    * 菜品规格
    */
    private String specification;
    /**
    * 菜品图片
    */
    private String photourl;

    /**
     * 菜品个数
     */
    private String carteNum;


    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getDishname() {
        return dishname;
    }

    public void setDishname(String dishname) {
        this.dishname = dishname;
    }

    public Double getPrice() {
        return price;
    }

    public void setPrice(Double price) {
        this.price = price;
    }

    public String getMaterial() {
        return material;
    }

    public void setMaterial(String material) {
        this.material = material;
    }

    public String getClassification() {
        return classification;
    }

    public void setClassification(String classification) {
        this.classification = classification;
    }

    public String getSpecification() {
        return specification;
    }

    public void setSpecification(String specification) {
        this.specification = specification;
    }

    public String getPhotourl() {
        return photourl;
    }

    public void setPhotourl(String photourl) {
        this.photourl = photourl;
    }

    public String getCarteNum() {
        return carteNum;
    }

    public void setCarteNum(String carteNum) {
        this.carteNum = carteNum;
    }

输出结果：

{
  "status": 200,
  "msg": "OK",
  "data": [
    {
      "address": {
        "id": 1,
        "openid": null,
        "name": "张晓明",
        "phone": "334455",
         "province": "北京",
        "city": "北京",
        "area": "海淀区",
        "sex": "男"
      },
      "id": 1,
      "orderId": "df123456",
      "cartes": [
        {
          "id": 1,
          "dishname": "银耳粥",
          "price": 10.0,
          "material": "1",
          "classification": "2",
          "specification": "3",
          "photourl": "4",
          "carteNum": "1"
        }
      ],
      "totalprice": null,
      "note": null,
      "openid": "123456"
    },
    {
      "address": {
        "id": 2,
        "openid": null,
        "name": "李云龙",
        "phone": "112233",
         "province": "北京",
        "city": "北京",
        "area": "海淀区",
        "address": "秀丽王府",
        "sex": "女"
      },
      "id": 2,
      "orderId": "df456789",
      "cartes": [
        {
          "id": 2,
          "dishname": "辣椒炒肉",
          "price": 15.0,
          "material": "1",
          "classification": "2",
          "specification": "3",
          "photourl": "4",
          "carteNum": "2"
        }
      ],
      "totalprice": null,
      "note": null,
      "openid": "456789"
    },
    {
      "address": {
        "id": 2,
        "openid": null,
        "name": "李云龙",
        "phone": "112233",
        "province": "北京",
        "city": "北京",
        "area": "海淀区",
        "address": "秀丽王府",
        "sex": "女"
      },
      "id": 3,
      "orderId": "df456789",
      "cartes": [
        {
          "id": 1,
          "dishname": "银耳粥",
          "price": 10.0,
          "material": "1",
          "classification": "2",
          "specification": "3",
          "photourl": "4",
          "carteNum": "1"
        }
      ],
      "totalprice": null,
      "note": null,
      "openid": "456789"
    }
  ],
  "ok": null
}

应该怎样才能吧cartes字段合并起来，求大神支招

[景培培哎]

引用 1 楼 亦夜 的回复:

应该是你的结构定义的可能还有些问题吧，我看你的map映射除了address那里应该用对象映射，其他好像没什么问题，我猜你想返回的结构应该是 多个GroupOfOrder对象所以返回类型应该是 List<GroupOfOrder> 而每一个GroupOfOrder里面有自己的属性，以及每一个对应的address对象，同时还有List<Carte>对象 正常的结构应该是这样

 "data": [
    {
      "id": 1,
      "orderId": "df123456",
      "totalprice": null,
      "note": null,
      "openid": "123456",
      "address": {
        "id": 1,
        "openid": null,
        "name": "张晓明",
        "phone": "334455",
         "province": "北京",
        "city": "北京",
        "area": "海淀区",
        "sex": "男"
      },
      "cartes": [
        {
          "id": 1,
          "dishname": "银耳粥",
          "price": 10.0,
          "material": "1",
          "classification": "2",
          "specification": "3",
          "photourl": "4",
          "carteNum": "1"
        },
         {
          "id": 2,
          "dishname": "小米粥",
          "price": 10.0,
          "material": "1",
          "classification": "2",
          "specification": "3",
          "photourl": "4",
          "carteNum": "1"
        }
      ]
    }
  ]

我就是想把cartes合并起来，但是我现在无论怎么修改，都合并不起来，求大神支招

[景培培哎]

引用 1 楼 亦夜 的回复:

应该是你的结构定义的可能还有些问题吧，我看你的map映射除了address那里应该用对象映射，其他好像没什么问题，我猜你想返回的结构应该是 多个GroupOfOrder对象所以返回类型应该是 List<GroupOfOrder> 而每一个GroupOfOrder里面有自己的属性，以及每一个对应的address对象，同时还有List<Carte>对象 正常的结构应该是这样

 "data": [
    {
      "id": 1,
      "orderId": "df123456",
      "totalprice": null,
      "note": null,
      "openid": "123456",
      "address": {
        "id": 1,
        "openid": null,
        "name": "张晓明",
        "phone": "334455",
         "province": "北京",
        "city": "北京",
        "area": "海淀区",
        "sex": "男"
      },
      "cartes": [
        {
          "id": 1,
          "dishname": "银耳粥",
          "price": 10.0,
          "material": "1",
          "classification": "2",
          "specification": "3",
          "photourl": "4",
          "carteNum": "1"
        },
         {
          "id": 2,
          "dishname": "小米粥",
          "price": 10.0,
          "material": "1",
          "classification": "2",
          "specification": "3",
          "photourl": "4",
          "carteNum": "1"
        }
      ]
    }
  ]

我的GroupOfOrde里面有list 有普通数据 也有对象，现在是完全不知道该怎么解决

[亦夜]

引用 4 楼 景培培哎 的回复:

[quote=引用 1 楼 亦夜 的回复:] 应该是你的结构定义的可能还有些问题吧，我看你的map映射除了address那里应该用对象映射，其他好像没什么问题，我猜你想返回的结构应该是 多个GroupOfOrder对象所以返回类型应该是 List<GroupOfOrder> 而每一个GroupOfOrder里面有自己的属性，以及每一个对应的address对象，同时还有List<Carte>对象 正常的结构应该是这样

 "data": [
    {
      "id": 1,
      "orderId": "df123456",
      "totalprice": null,
      "note": null,
      "openid": "123456",
      "address": {
        "id": 1,
        "openid": null,
        "name": "张晓明",
        "phone": "334455",
         "province": "北京",
        "city": "北京",
        "area": "海淀区",
        "sex": "男"
      },
      "cartes": [
        {
          "id": 1,
          "dishname": "银耳粥",
          "price": 10.0,
          "material": "1",
          "classification": "2",
          "specification": "3",
          "photourl": "4",
          "carteNum": "1"
        },
         {
          "id": 2,
          "dishname": "小米粥",
          "price": 10.0,
          "material": "1",
          "classification": "2",
          "specification": "3",
          "photourl": "4",
          "carteNum": "1"
        }
      ]
    }
  ]

我的GroupOfOrde里面有list 有普通数据 也有对象，现在是完全不知道该怎么解决[/quote] 就正常映射啊，属性对应字段，对象用单个的对象映射，list就用collection映射

[亦夜]

应该是你的结构定义的可能还有些问题吧，我看你的map映射除了address那里应该用对象映射，其他好像没什么问题，我猜你想返回的结构应该是 多个GroupOfOrder对象所以返回类型应该是 List<GroupOfOrder> 而每一个GroupOfOrder里面有自己的属性，以及每一个对应的address对象，同时还有List<Carte>对象 正常的结构应该是这样

 "data": [
    {
      "id": 1,
      "orderId": "df123456",
      "totalprice": null,
      "note": null,
      "openid": "123456",
      "address": {
        "id": 1,
        "openid": null,
        "name": "张晓明",
        "phone": "334455",
         "province": "北京",
        "city": "北京",
        "area": "海淀区",
        "sex": "男"
      },
      "cartes": [
        {
          "id": 1,
          "dishname": "银耳粥",
          "price": 10.0,
          "material": "1",
          "classification": "2",
          "specification": "3",
          "photourl": "4",
          "carteNum": "1"
        },
         {
          "id": 2,
          "dishname": "小米粥",
          "price": 10.0,
          "material": "1",
          "classification": "2",
          "specification": "3",
          "photourl": "4",
          "carteNum": "1"
        }
      ]
    }
  ]

[景培培哎]

引用 5 楼 亦夜 的回复:

[quote=引用 4 楼 景培培哎 的回复:] [quote=引用 1 楼 亦夜 的回复:] 应该是你的结构定义的可能还有些问题吧，我看你的map映射除了address那里应该用对象映射，其他好像没什么问题，我猜你想返回的结构应该是 多个GroupOfOrder对象所以返回类型应该是 List<GroupOfOrder> 而每一个GroupOfOrder里面有自己的属性，以及每一个对应的address对象，同时还有List<Carte>对象 正常的结构应该是这样

 "data": [
    {
      "id": 1,
      "orderId": "df123456",
      "totalprice": null,
      "note": null,
      "openid": "123456",
      "address": {
        "id": 1,
        "openid": null,
        "name": "张晓明",
        "phone": "334455",
         "province": "北京",
        "city": "北京",
        "area": "海淀区",
        "sex": "男"
      },
      "cartes": [
        {
          "id": 1,
          "dishname": "银耳粥",
          "price": 10.0,
          "material": "1",
          "classification": "2",
          "specification": "3",
          "photourl": "4",
          "carteNum": "1"
        },
         {
          "id": 2,
          "dishname": "小米粥",
          "price": 10.0,
          "material": "1",
          "classification": "2",
          "specification": "3",
          "photourl": "4",
          "carteNum": "1"
        }
      ]
    }
  ]

我的GroupOfOrde里面有list 有普通数据 也有对象，现在是完全不知道该怎么解决[/quote] 就正常映射啊，属性对应字段，对象用单个的对象映射，list就用collection映射[/quote] 谢谢大佬耐心指点，我已经解决了，谢谢