我的資料分為三個表，但是其中一個表的資料用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欄位合并起來，求大神支招
uj5u.com熱心網友回復：
應該是你的結構定義的可能還有些問題吧，我看你的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"
}
]
}
]
uj5u.com熱心網友回復：
我就是想把cartes合并起來，但是我現在無論怎么修改，都合并不起來，求大神支招
uj5u.com熱心網友回復：
我的GroupOfOrde里面有list 有普通資料 也有物件，現在是完全不知道該怎么解決
uj5u.com熱心網友回復：
就正常映射啊，屬性對應欄位，物件用單個的物件映射，list就用collection映射
uj5u.com熱心網友回復：
謝謝大佬耐心指點，我已經解決了，謝謝
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/132022.html
標籤：Web 開發