一、购物车结算

建立Order与Orderitem实体类

order：

package com.dzl.entity;import java.util.Date;public class Order {private long id;private long uid;private Date orderTime;private String consignee;private String phone;private String postalcode;private String address;private int sendType;private Date sendTime;private float orderPrice;private int orderState;public long getId() {return id;}public void setId(long id) {this.id = id;}public long getUid() {return uid;}public void setUid(long uid) {this.uid = uid;}public Date getOrderTime() {return orderTime;}public void setOrderTime(Date orderTime) {this.orderTime = orderTime;}public String getConsignee() {return consignee;}public void setConsignee(String consignee) {this.consignee = consignee;}public String getPhone() {return phone;}public void setPhone(String phone) {this.phone = phone;}public String getPostalcode() {return postalcode;}public void setPostalcode(String postalcode) {this.postalcode = postalcode;}public String getAddress() {return address;}public void setAddress(String address) {this.address = address;}public int getSendType() {return sendType;}public void setSendType(int sendType) {this.sendType = sendType;}public Date getSendTime() {return sendTime;}public void setSendTime(Date sendTime) {this.sendTime = sendTime;}public float getOrderPrice() {return orderPrice;}public void setOrderPrice(float orderPrice) {this.orderPrice = orderPrice;}public int getOrderState() {return orderState;}public void setOrderState(int orderState) {this.orderState = orderState;}@Overridepublic String toString() {return "Order [id=" + id + ", uid=" + uid + ", orderTime=" + orderTime + ", consignee=" + consignee + ", phone="+ phone + ", postalcode=" + postalcode + ", address=" + address + ", sendType=" + sendType+ ", sendTime=" + sendTime + ", orderPrice=" + orderPrice + ", orderState=" + orderState + "]";}}

Orderitem ：

package com.dzl.entity;public class OrderItem {private long id;private long oid;private String bid;private int quantity;public long getId() {return id;}public void setId(long id) {this.id = id;}public long getOid() {return oid;}public void setOid(long oid) {this.oid = oid;}public String getBid() {return bid;}public void setBid(String bid) {this.bid = bid;}public int getQuantity() {return quantity;}public void setQuantity(int quantity) {this.quantity = quantity;}@Overridepublic String toString() {return "OrderItem [id=" + id + ", oid=" + oid + ", bid=" + bid + ", quantity=" + quantity + "]";}}

OrderDao ：

package com.dzl.dao;import java.util.List;import com.dzl.entity.Order;
import com.zking.util.BaseDao;
import com.zking.util.PageBean;public class OrderDao extends BaseDao<Order>{/*** 购物车结算生成订单* @param t* @throws Exception*/public void add(Order t) throws Exception {String sql="insert into t_easyui_order(uid,orderTime,consignee,phone,postalcode,address,sendType,sendTime,orderPrice,orderState) values(?,now(),?,?,?,?,?,?,?,?)";super.executeUpdate(sql, t, new String[] {"uid","consignee","phone","postalcode","address","sendType","sendTime","orderPrice","orderState"});}/*** 按照订单时间倒序查询* @param order* @param pageBean* @return* @throws Exception*/public List<Order> list(Order order, PageBean pageBean) throws Exception {String sql="select * from t_easyui_order order by orderTime desc";return super.executeQuery(sql, Order.class, pageBean);}
}

OrderItemDao ：

package com.dzl.dao;import com.dzl.entity.OrderItem;
import com.zking.util.BaseDao;public class OrderItemDao extends BaseDao<OrderItem>{/*** 购物车结算订单项入库* @param t* @throws Exception*/public void add(OrderItem t) throws Exception {String sql="insert into t_easyui_orderItem(oid,bid,quantity) values(?,?,?)";super.executeUpdate(sql, t, new String[] {"oid","bid","quantity"});}
}

ShoppingAction ：

package com.dzl.web;import java.io.IOException;
import java.util.ArrayList;
import java.util.List;import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;import com.fasterxml.jackson.core.JsonParseException;
import com.fasterxml.jackson.databind.JsonMappingException;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.dzl.dao.BookDao;
import com.dzl.dao.OrderDao;
import com.dzl.dao.OrderItemDao;
import com.dzl.entity.Book;
import com.dzl.entity.Order;
import com.dzl.entity.OrderItem;
import com.dzl.entity.User;
import com.dzl.vo.ShoppingVo;
import com.zking.framework.ActionSupport;
import com.zking.framework.ModelDriver;
import com.zking.util.ResponseUtil;
import com.zking.util.StringUtils;public class ShoppingAction extends ActionSupport implements ModelDriver<ShoppingVo>{private ShoppingVo vo=new ShoppingVo();private OrderDao orderDao=new OrderDao();private OrderItemDao orderItemDao=new OrderItemDao();private BookDao bookDao=new BookDao();public ShoppingVo getModel() {return vo;}public void createOrder(HttpServletRequest req, HttpServletResponse resp) {/*** 1.数据入订单表* 2.数据入订单项表* 3.下单结束后，要将商品的销售数量发生改变*/User cuser=(User)req.getSession().getAttribute("cuser");if(cuser==null) {return ;}//组装数据Order order=new Order();order.setAddress(vo.getAddress());order.setConsignee(vo.getConsignee());//订单价格总计float orderPrice=0f;String pageStr = vo.getPageStr();if(StringUtils.isNotBlank(pageStr)&&pageStr.length()>1) {for(String item:pageStr.substring(1).split(",")) {String[] itemEle = item.split("-");orderPrice+=Float.valueOf(itemEle[3]);}}order.setOrderPrice(orderPrice);order.setOrderState(1);order.setPhone(vo.getPhone());order.setPostalcode(vo.getPostalcode());order.setSendType(vo.getSendType());order.setUid(cuser.getId());try {orderDao.add(order);Order newest = orderDao.list(null, null).get(0);OrderItem oi=new OrderItem();if(StringUtils.isNotBlank(pageStr)&&pageStr.length()>1) {for(String item:pageStr.substring(1).split(",")) {String[] itemEle = item.split("-");oi.setBid(itemEle[0]);//需要设置当前订单项是属于哪个订单的,思路是查询出最新订单的id//按照订单事件进行倒序查询，取第一条数据即可oi.setOid(newest.getId());oi.setQuantity(Integer.valueOf(2));orderItemDao.add(oi);//当前书籍被购买，那么这本书销量应该＋QuantityBook b=new Book();b.setName(itemEle[0]);b.setSales(Integer.valueOf(itemEle[2]));bookDao.editSales(b);}}} catch (Exception e) {e.printStackTrace();}}/*** 将信息加入购物车*/public String add(HttpServletRequest req, HttpServletResponse resp) {HttpSession session = req.getSession();User cuser = (User)session.getAttribute("cuser");ObjectMapper om=new ObjectMapper();try {if(cuser!=null) {/*** 点击添加传递到后台的是一个对象，然后购物车需要的是list集合进行显示* 1.第一次添加购物车中是没有数据的，也就意味着把vo放到list集合shopGoodsVos中，传递到前台即可* 2.第二次添加到购物车  也就意味着之前有购物车相关信息* 取出原有的购物车list集合，将本次添加购物车的实体类Vo放到原有的购物车list集合shopGoodsVos中*/long uid = cuser.getId();List<ShoppingVo> shopGoodsVos=null;//从session取出当前用户对应的购物车信息String shoppingInfo = (String)session.getAttribute("shopping_"+uid);if(StringUtils.isNotBlank(shoppingInfo)) {//第2/3次添加//shoppingInfo包含了当前用户的购物车信息，也是通过list集合转成的一个Json字符串shopGoodsVos = om.readValue(shoppingInfo, List.class);}else {//第1次添加shopGoodsVos =new ArrayList<ShoppingVo>();}//vo指的是前台点击购物车具体商品内容shopGoodsVos.add(vo);session.setAttribute("shopping_"+uid, om.writeValueAsString(shopGoodsVos));
//			session.setAttribute("shopping_"+uid, vo);req.setAttribute("shopGoodsVos", shopGoodsVos);
//			req.setAttribute("shoppingCar", arg1);}} catch (Exception e) {e.printStackTrace();}return "shoppingCar";}public String list(HttpServletRequest req, HttpServletResponse resp) {HttpSession session = req.getSession();User cuser = (User)session.getAttribute("cuser");ObjectMapper om=new ObjectMapper();//查询当前用户的购物车信息String shoppingInfo = (String)session.getAttribute("shopping_"+cuser.getId());try {List<ShoppingVo> shopGoodsVos=om.readValue(shoppingInfo, List.class);req.setAttribute("shopGoodsVos", shopGoodsVos);} catch (Exception e) {e.printStackTrace();} return "shoppingCar";}public void clear(HttpServletRequest req, HttpServletResponse resp) {HttpSession session = req.getSession();User cuser = (User)session.getAttribute("cuser");session.removeAttribute("shopping_"+cuser.getId());try {ResponseUtil.write(resp, 1);} catch (Exception e) {e.printStackTrace();}}}

前台js代码:

 $(".order_Create").click(function () {var consignee = $("#consignee").val();var phone = $("#phone").val();var postalcode = $("#postalcode").val();var address = $("#address").val();var sendType = $("#sendType").val();var single_tr = "";$(".table tr:gt(0)").not(":last").each(function (index, node) {console.log(index);single_tr = single_tr + "," + $(this).find("th").eq(0).html() + "-" + $(this).find("td").eq(0).html() + "-"+ $(this).find("td").eq(1).find("input").val() + "-" + $(this).find("td").eq(2).html();})console.log(single_tr.substring(1));var param = "consignee=" + consignee + "&phone=" + phone + "&postalcode=" + postalcode + "&address=" + address + "&sendType=" + sendType + "&pageStr=" + single_tr;$.ajax({url: '${pageContext.request.contextPath}/shopping.action?methodName=createOrder',type: "POST",data: param,success: function (data) {var consignee = $("#consignee").val("");var phone = $("#phone").val("");var postalcode = $("#postalcode").val("");var address = $("#address").val("");var sendType = $("#sendType").val("");$('.shop-modal').addClass('modal');$(".table tr:gt(0)").not(":last").remove();$.ajax({url: '${pageContext.request.contextPath}/shopping.action?methodName=clear',success: function (data) {<%--location.href = '${pageContext.request.contextPath}/shopping.action?methodName=list';--%>}});}});});