java web基于ssm框架+jsp的网上商城项目+mysql数据库脚本java毕业设计

package com.controller; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.HashMap; import java.util.Iterator; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import com.pojo.Goods; import com.pojo.Orderitem; import com.pojo.Torder; import com.pojo.Userinfo; import com.service.GoodsService; import com.service.OrderitemService; import com.service.TorderService; import com.service.UserinfoService; import com.util.Cart; @Controller public class BuyController { @Autowired private GoodsService goodsService; @Autowired private OrderitemService orderitemService; @Autowired private TorderService torderService; @Autowired private UserinfoService userinfoService; @RequestMapping(value = "/addToCart") public String addToCart(HttpServletResponse response, HttpServletRequest request) throws Exception { int goodsId = Integer.parseInt(request.getParameter("goodsId")); int quantity = Integer.parseInt(request.getParameter("quantity")); Goods goods = goodsService.queryGoodsById(goodsId); Orderitem orderItem = new Orderitem(); orderItem.setGoods(goods); orderItem.setGoodsQuantity(quantity); Object obj = request.getSession().getAttribute("cart"); Cart cart = null; if (obj == null) { cart = new Cart(); } else { cart = (Cart) obj; } cart.addGoods(goodsId, orderItem); request.getSession().setAttribute("cart", cart); request.setAttribute("path", "myCart.action"); return "/common/succeed.jsp"; } @RequestMapping(value = "/myCart") public String myCart(HttpServletResponse response, HttpServletRequest request) throws Exception { return "/qiantai/myCart/myCart.jsp"; } @RequestMapping(value = "/orderQueren") public String orderQueren(HttpServletRequest request) throws Exception { Userinfo user = (Userinfo) request.getSession().getAttribute("user"); if (user != null) { //生成订单 Cart cart = (Cart) request.getSession().getAttribute("cart"); Map<String, List<Orderitem>> map = new HashMap<String, List<Orderitem>>(); for (Iterator it = cart.getItems().values().iterator(); it.hasNext();) { Orderitem orderItem = (Orderitem) it.next(); int goodid = orderItem.getGoods().getGoodsId(); String shid = "1"; if (map.containsKey(shid)) { List<Orderitem> list = map.get(shid); list.add(orderItem); } else { List<Orderitem> list = new ArrayList<Orderitem>(); list.add(orderItem); map.put(shid, list); } } Torder order =null; for (Map.Entry<String, List<Orderitem>> entry : map.entrySet()) { String key = entry.getKey(); List<Orderitem> list = entry.getValue(); try { Thread.sleep(500); } catch (InterruptedException e) { // TODO Auto-generated catch block e.printStackTrace(); } order = new Torder(); order.setOrderBianhao(new SimpleDateFormat("yyyyMMddHHmmss") .format(new Date())); order.setOrderDate(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss") .format(new Date())); order.setOrderZhuangtai("未付款"); order.setOrderUserId(user.getUserId()); order.setOrderJine(getTotalPrice(list)); order.setSjfk(cart.getfkPrice(list)); order.setStore("0"); order.setJifen(ppJifen(order.getOrderJine())); order.setShid(Integer.parseInt(key)); torderService.insertTorder(order); for (Iterator it = list.iterator(); it.hasNext();) { Orderitem orderItem = (Orderitem) it.next(); orderItem.setOrderId(order.getOrderId()); orderItem.setGoodsId(orderItem.getGoods().getGoodsId()); orderitemService.insertOrderitem(orderItem); Goods goods = goodsService.queryGoodsById(orderItem.getGoodsId()); int kucun = goods.getKucun()-orderItem.getGoodsQuantity(); kucun = kucun<0?0:kucun; goods.setKucun(kucun); goodsService.updateGoods(goods); } } cart.getItems().clear(); cart.setSjfk(0); request.getSession().setAttribute("cart", cart); request.setAttribute("order", order); return "/qiantai/order/orderQueren.jsp"; } else { return "/qiantai/userlogin/userlogin.jsp"; } } @RequestMapping(value = "/toorderSubmit") public String toorderSubmit(HttpServletRequest request) throws Exception { Integer orderId = Integer.parseInt(request.getParameter("orderId")) ; Torder order = torderService.queryTorderById(orderId); request.setAttribute("order", order); return "/qiantai/order/orderQueren.jsp"; } @RequestMapping(value = "/orderSubmit") public String orderSubmit(HttpServletRequest request) throws Exception { Userinfo user = (Userinfo) request.getSession().getAttribute("user"); //通过id查询 Integer orderId = Integer.parseInt(request.getParameter("orderId")) ; Torder order = torderService.queryTorderById(orderId); String odderFukuangfangshi = request.getParameter("odderFukuangfangshi"); String odderSonghuodizhi = request.getParameter("odderSonghuodizhi"); int tjifen = order.getJifen(); order.setOrderZhuangtai("已付款"); order.setOrderFukuangfangshi(odderFukuangfangshi); order.setOrderSonghuodizhi(odderSonghuodizhi); torderService.updateTorder(order); user.setJifen(user.getJifen() + tjifen); userinfoService.updateUserinfo(user); request.getSession().setAttribute("user", user); return "/qiantai/order/orderSubmit.jsp"; } // 添加物流 /** * 积分按照1:10 进行累计 * * @param orderJine * @return */ private int ppJifen(Integer orderJine) { int jifen = orderJine / 10; // 余数不需要 return jifen; } public int getTotalPrice(List list) { int totalPrice = 0; for (Iterator it = list.iterator(); it.hasNext();) { Orderitem orderItem = (Orderitem) it.next(); Goods goods = orderItem.getGoods(); int quantity = orderItem.getGoodsQuantity(); totalPrice += goods.getGoodsShichangjia() * quantity; } return totalPrice; } @RequestMapping(value = "/myOrder") public String myOrder(HttpServletRequest request) throws Exception { Userinfo user = (Userinfo) request.getSession().getAttribute("user"); Torder qorder = new Torder(); qorder.setOrderUserId(user.getUserId()); List<Torder> orderList = torderService.queryTorderList(qorder); request.setAttribute("orderList", orderList); return "/qiantai/order/myOrder.jsp"; } @RequestMapping(value = "/myjifen") public String myjifen(HttpServletRequest request) throws Exception { Userinfo user = (Userinfo) request.getSession().getAttribute("user"); Torder qorder = new Torder(); qorder.setOrderUserId(user.getUserId()); qorder.setOrderZhuangtai("-1"); List<Torder> orderList = torderService.queryTorderList(qorder); request.setAttribute("orderList", orderList); return "/qiantai/userinfo/points.jsp"; } @RequestMapping(value = "/orderMana") public String orderMana(HttpServletRequest request) throws Exception { Torder qorder = new Torder(); List orderList = torderService.queryTorderList(qorder); request.setAttribute("orderList", orderList); return "/admin/order/orderMana.jsp"; } @RequestMapping(value = "/orderDel") public String orderDel(HttpServletRequest request) throws Exception// 用户自己删除订单 { int orderId = Integer.parseInt(request.getParameter("orderId")); torderService.deleteTorder(orderId); request.setAttribute("message", "删除成功"); request.setAttribute("path", "myOrder.action"); return "common/succeed.jsp"; } @RequestMapping(value = "/orderDelByAd") public Str