81,090
社区成员
发帖
与我相关
我的任务
分享
{
"response": "cart",
"cart":{
listmap "cartitem": [ //购物车项
:{ ---product
map--> "product":{
"id":"1200001", //商品ID
"name": "雅培金装", //商品名称
"pic":"", //商品图片URL
"price":"89", //商品售价
"number": 0, //商品库存数量,0为缺货或下架
"uplimit":"10" //商品购买数量上限
listmap -------> "product_property":[ //属性
{
"key": "颜色",
"value": "红色",
},
{
"key": "大小",
"value": "M",
}
],
"isgift":"false" //是否赠品
}
"prodNum":3 //商品数量
},
{
"product":{
"id":"1200001", //商品ID
"name": "雅培金装", //商品名称
"pic":"", //商品图片URL
"price":"89", //商品售价
"number": 0, //商品库存数量,0为缺货或下架
"uplimit":"10", //商品购买数量上限
"product_property":[ //属性
{
"key": "颜色",
"value": "红色",
},
{
"key": "大小",
"value": "M",
}
]
"isgift":"true" //是否赠品
},
"prodNum":1 //商品数量
}
],
"prom":[ //享受促销信息
"促销信息一",
"促销信息二"
],
//购物车总计
"totalCount":"3", //商品数量总计
"totalPrice":"230", //商品金额总计
"totalPoint":"230" //商品积分总计
}
}
package com.ithm21.dao;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.MapHandler;
import org.apache.commons.dbutils.handlers.MapListHandler;
import com.ithm21.util.DataSourceManager;
public class CartDaoImpl {
private QueryRunner runner = new QueryRunner(
DataSourceManager.getDataSource());
/**
* 获取购物车里面的数据
*
* @param productId
* @return
*/
public Map<String, Object> getCart(String productId) {
// 购物车
Map<String, Object> cart = new HashMap<String, Object>();
// 购物车条目
List<Map<String, Object>> cartitem = new ArrayList<Map<String, Object>>();
// 商品
Map<String, Object> product = new HashMap<String, Object>();
//多个商品
Map<String,Object> productList = new HashMap<String,Object>();
// 商品属性
List<Map<String, Object>> product_property = new ArrayList<Map<String, Object>>();
try {
// 先查出单个商品
String sql = "SELECT product.id,product.name,pic.pic,product.price,product.number,product.buyLimit FROM product,pic WHERE product.id=pic.product_id AND product.id = ? ";
product = runner.query(sql, new MapHandler(), productId);
//将单个商品添加进入商品集合
productList.put("productlist", product);
// 查出商品的属性,
sql = "SELECT property.key,property.value FROM property WHERE id IN(SELECT property_id FROM product_property_filter WHERE product_id = ?)";
product_property = runner.query(sql, new MapListHandler(),
productId);
// 将属性加入商品里面去
product.put("product_property", product_property);
// 不是促销商品(这里的属性应当定义成变量)
product.put("isgift", "false");
// 将商品添加进入cartitem
cartitem.add(productList);
/**
* "prom":[ //享受促销信息 "促销信息一", "促销信息二" ],
*/
List<String> prom = new ArrayList<String>();
prom.add("促销信息一");
prom.add("促销信息二");
// 将促销信息添加到购物车
cart.put("prom", prom);
// 购物车总计
// "totalCount":"3", //商品数量总计
// "totalPrice":"230", //商品金额总计
// "totalPoint":"230" //商品积分总计
int totalCount = cartitem.size();
int totalPrice =
(int) cart.put("totalCount", totalCount);
cart.put("cartitem", cartitem);
cart.put("response", "cart");
return cart;
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
}