问题总结:
1查询带上id数据库显示null,
原因 productId在定义的Schema中定义的String类型,但是mongoDB数据库中定义的是integer类型,导致查不到。
解决:修改数据库id的类型为String
2
总结一下:
加入购物车的思路
users表的商品信息是来源于goods表,我们需要根据productId拿到商品信息,最终把这个商品信息一次性插入我们的购物车里面
用户表:
users表字段
userid
username
password
orderList 订单列表(加入购物车下完单生成的订单)
0
orderId
orderTotal
orderStatus
_id
createDate
cardList 购物车列表
addresslist 地址
0
addressId
username
streetName
posCode
tel
isDefault
数据库字段
{
"userId": 1,
"username": 1,
"password": 1,
"orderList": [
{
"orderId": 1,
"orderTotal": 1,
"orderStatus": 1,
"_id": 1,
"createDate": 1
}
],
"cartList": [{
"userId": 1,
"productId": 1,
"productName": 1,
"salePrice": 1,
"productImage": 1,
"checked": 1,
"productNum": 1
}],
"addressList": []
}
var userSchma = new mongoose.Schema({
"userId": String,
"username": String,
"password": String,
"orderList": [{
"orderId": String,
"orderTotal": String,
"orderStatus": String,
"_id": String,
"createDate": String
}],
"cartList": [{
"userId": String,
"productId": String,
"productName": String,
"salePrice": String,
"productImage": String,
"checked": String,
"productNum": String
}],
"addressList": Array
})
<