企业电子商务网前台+后台（SSH+mysql5.0）

package com.clrl.webshop.web.actions; import java.io.FileOutputStream; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import org.apache.struts.actions.DispatchAction; import org.apache.struts.upload.FormFile; import com.clrl.webshop.biz.GoodsHandler; import com.clrl.webshop.commons.CartItem; import com.clrl.webshop.commons.PageCW; import com.clrl.webshop.commons.PageRpcBean; import com.clrl.webshop.persist.BigType; import com.clrl.webshop.persist.Goods; import com.clrl.webshop.persist.SmallType; import com.clrl.webshop.web.forms.GoodsForm; /** * 商品表action * @author ChengWei * */ public class GoodsAction extends DispatchAction { private GoodsHandler goodsHandler; // 查询特价商品(ChengWei) public ActionForward findTeJiaGoods(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { PageCW pageCW = new PageCW(); int pageSize = 4; // 每页显示 行 数 int page = 1; // 当前 页 int pageCount = 1; // 总页 数 int totalRow = 0; // 总记录 try { page = Integer.parseInt(request.getParameter("page")); } catch (Exception e) { page = 1; } List teJiaGoodsList = goodsHandler.findListForPage("from Goods g where g.mark=1", (page - 1) * pageSize, pageSize); totalRow = goodsHandler.findTotalRow("select count(*) from Goods g where g.mark=1 and g.number>0"); if (totalRow % pageSize == 0) { pageCount = totalRow / pageSize; } else { pageCount = totalRow / pageSize + 1; } pageCW.setPage(page); pageCW.setPageCount(pageCount); pageCW.setTotalRow(totalRow); pageCW.setList(teJiaGoodsList); request.setAttribute("pageCW", pageCW); return mapping.findForward("default"); } // 查询新品(ChengWei) public ActionForward findNewGoods(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { List newGoodsList = goodsHandler.findListForPage("from Goods g where g.number>0 order by g.creaTime desc", 0, 10); request.setAttribute("newGoodsList", newGoodsList); return mapping.findForward("default"); } // 销售排行(ChengWei) public ActionForward findGoodsSort(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { List goodsSortList = goodsHandler.findListForPage("from Goods g where g.number>0 order by g.number desc", 0, 10); request.setAttribute("goodsSortList", goodsSortList); request.setAttribute("type", "findGoodsSort"); return mapping.findForward("default"); } // 通过小商品类型查询商品(ChengWei) public ActionForward findGoodsBySmallId(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { String smallId = request.getParameter("smallId"); if (smallId != null) { PageCW pageCW = new PageCW(); int pageSize = 4; // 每页显示 行 数 int page = 1; // 当前 页 int pageCount = 1; // 总页 数 int totalRow = 0; // 总记录 try { page = Integer.parseInt(request.getParameter("page")); } catch (Exception e) { page = 1; } List smallGoodsList = goodsHandler.findListForPage("from Goods g where g.number>0 and g.smallType.id="+Integer.parseInt(smallId), (page - 1) * pageSize, pageSize); totalRow = goodsHandler.findTotalRow("select count(*) from Goods g where g.number>0 and g.smallType.id="+Integer.parseInt(smallId)); if (totalRow % pageSize == 0) { pageCount = totalRow / pageSize; } else { pageCount = totalRow / pageSize + 1; } pageCW.setPage(page); pageCW.setPageCount(pageCount); pageCW.setTotalRow(totalRow); pageCW.setList(smallGoodsList); request.setAttribute("smallId", smallId); request.setAttribute("pageCW", pageCW); request.setAttribute("type", "fg-selectNewGoods"); } return mapping.findForward("default"); } // 查询商品详细信息 (ChengWei) public ActionForward findGoodsById(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { String id = request.getParameter("id"); if (id != null) { Goods goods = goodsHandler.findGoodsById(Integer.parseInt(id)); request.setAttribute("goods", goods); } return mapping.findForward("findGoodsById"); } //*******************购物车(map实现)************************// public ActionForward cart(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { HttpSession session = request.getSession(); String path = request.getParameter("path"); Map cart = (Map)session.getAttribute("cart"); // 从session拿到购物车 String id = request.getParameter("id"); // 得到商品id double totalPrice = 0;// 商品总价 CartItem cartItem = null; // 购物车里的商品 Goods goods = null; // 商品 if (path.equals("add")) { // 添加商品到 购物车 if (cart == null) { cart = new HashMap(); cartItem = new CartItem(); goods = goodsHandler.findGoodsById(Integer.parseInt(id)); cartItem.setGoods(goods); cartItem.setCount(1); cart.put(id, cartItem); } else { cartItem = (CartItem)cart.get(id); if (cartItem == null) { cartItem = new CartItem(); goods = goodsHandler.findGoodsById(Integer.parseInt(id)); cartItem.setGoods(goods); cartItem.setCount(1); cart.put(id, cartItem); } else { if (!(cartItem.getCount() >= cartItem.getGoods().getNumber())) { // 判断购物车里的数量是否大于 数据库里的商品数量 cartItem.setCount(cartItem.getCount()+1); } } } //算出总价 if (cart != null && cart.size() > 0) { for (Object obj : cart.values()) { CartItem item = (CartItem)obj; if (item.getGoods().getFreePrice() != 0) { totalPrice += item.getCount() * item.getGoods().getFreePrice(); } else { totalPrice += item.getCount() * item.getGoods().getNowPrice(); } } } session.setAttribute("totalPrice", totalPrice); session.setAttribute("cart", cart); request.setAttribute("addCartSuccess", "addCartSuccess"); return mapping.findForward("findGoodsById"); } else if (path.equals("del")) { // 删除商品 cart.remove(id); } else if (path.equals("modify")) { // 修改数量 String count = request.getParameter("count"); cartItem = (CartItem)cart.get(id); cartItem.setCount(Integer.parseInt(count)); } else if (path.equals("clear")) { // 清空购物车 cart.clear(); } //算出总价 if (cart != null && cart.size() > 0) { for (Object obj : cart.values()) { CartItem item = (CartItem)obj; if (item.getGoods().getFreePrice() != 0) { totalPrice += item.getCount() * item.getGoods().getFreePrice(); } else { totalPrice += item.getCount() * item.getGoods().getNowPrice(); } } } request.setAttribute("cart", cart); session.setAttribute("totalPrice", totalPrice); request.setAttribute("type", "cart"); return mapping.findForward("default"); } public void setGoodsHandler(GoodsHandler goodsHandler) { this.goodsHandler = goodsHandler; } /* * 分页查询商品,大类型，小类型，特价商品（RPC）(non-Javadoc) * @see org.apache.struts.actions.DispatchAction#execute(org.apache.struts.action.ActionMapping, org.apache.struts.action.ActionForm, javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse) */ public ActionForward doQuery(ActionMapping mapping, ActionForm form,