Java项目:小蜜蜂扩音器网上商城系统(java+JSP+Servlet+JDBC+Ajax+mysql)

package cn.gok.backstageManagement.web; import java.io.File; import java.io.IOException; import java.io.UnsupportedEncodingException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.Random; import javax.servlet.ServletContext; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.commons.fileupload.FileItem; import cn.gok.backstageManagement.entity.Goods; import cn.gok.backstageManagement.entity.Orders; import cn.gok.backstageManagement.service.GoodsService; import cn.gok.frontstageManagement.entity.User; import cn.gok.util.FileUploadUtil; import cn.gok.util.JSONResult; import cn.gok.util.JsonUtil; @WebServlet("/backstage_goodsServlet") public class GoodsServlet extends HttpServlet{ GoodsService service = new GoodsService(); @Override protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { String action = req.getParameter("action"); switch(action) { case "addGoods":addGoods(req,resp);break; case "getGoodsList":getGoodsList(req,resp);break; case "getGoodsListByName":getGoodsListByName(req,resp);break; case "deleteGoods":deleteGoods(req,resp);break; case "toGoodsUpdatePage":toGoodsUpdatePage(req,resp);break; case "updateGoods":updateGoods(req,resp);break; case "upGoodsImage":upGoodsImage(req,resp);break; case "fastbuy":sendOrder(req,resp);break; } } /** * 提交订单 * @throws IOException */ public void sendOrder(HttpServletRequest req, HttpServletResponse resp) throws IOException { //设置请求编码格式: req.setCharacterEncoding("utf-8"); //设置响应编码格式 resp.setContentType("text/html;charset=utf-8"); SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//设置日期格式 Orders order = new Orders(); order.setNumber(order.getRandomString(10)); order.setTime(df.format(new Date())); order.setName(req.getParameter("recipients")); order.setAddress(req.getParameter("address")); order.setPhone(req.getParameter("phone")); order.setAddress_label(req.getParameter("addressLabel")); order.setSex(req.getParameter("sex")); order.setUser("sjb"); order.setGoods_id(99); order.setGoods_num(3); order.setGoods_status(1); int d = service.addOrder(order); try { if(d>0) { JSONResult ok = JSONResult.ok(); resp.getWriter().println(JsonUtil.javaObjectToJson(ok)); }else { JSONResult error = JSONResult.errorMsg("订单提交失败!"); resp.getWriter().println(JsonUtil.javaObjectToJson(error)); } } catch (Exception e) { e.printStackTrace(); } } /** * 保存商品 * @throws IOException */ public void addGoods(HttpServletRequest req,HttpServletResponse resp) throws IOException { //设置请求编码格式: req.setCharacterEncoding("utf-8"); //设置响应编码格式 resp.setContentType("text/html;charset=utf-8"); FileUploadUtil upFile = new FileUploadUtil(); ServletContext servletContext = req.getSession().getServletContext(); List<FileItem> items= upFile.getRequsetFileItems(req,servletContext); //保存所有用户提交的 表单数据 的map Map<String, String> formData = new HashMap<>(); String savePath = "D:\\头条视频\\\\2020-12-16\\Gok_ShoppingMallx\\WebContent\\home\\img"; try { //遍历 for (FileItem file : items) { if(!file.isFormField()) { String fileSuffix = FileUploadUtil.getFileSuffix(file).toUpperCase(); //必须是jpg或png 图片文件才能进行上传操作 if("JPG".equals(fileSuffix) || "PNG".equals(fileSuffix)) { //生成新图片名 String imgName = FileUploadUtil.getImgNewName(fileSuffix); FileUploadUtil.saveFile(file, savePath, imgName); formData.put("imgUrl",imgName); } }else { //非文件数据存入 formData.put(file.getFieldName(), file.getString("utf-8")); } } } catch (UnsupportedEncodingException e) { e.printStackTrace(); } Goods goods = new Goods(); goods.setName(formData.get("goodsName")); goods.setNum(Integer.parseInt(formData.get("num"))); goods.setPrice(Double.parseDouble(formData.get("price"))); goods.setImgurl(formData.get("imgUrl")); goods.setType(formData.get("type")); goods.setDescription(formData.get("description")); goods.setColor(formData.get("color")); goods.setMemory(formData.get("memory")); goods.setCreateDate(new SimpleDateFormat("yyyy-MM-dd").format(new Date())); int d = service.addGoods(goods); try { if(d>0) { JSONResult ok = JSONResult.ok(); resp.getWriter().println(JsonUtil.javaObjectToJson(ok)); }else { JSONResult errorMsg = JSONResult.errorMsg("添加失败，请重试"); resp.getWriter().println(JsonUtil.javaObjectToJson(errorMsg)); } } catch (Exception e) { e.printStackTrace(); } } /** * 向前端页面返回商品数据列表 */ public void getGoodsList(HttpServletRequest req,HttpServletResponse resp) { List<Goods> allGoods = service.getAllGoods(); req.setAttribute("goodsList", allGoods); try { req.getRequestDispatcher("/backstage/tgls/goodsManage/goods_list.jsp").forward(req, resp); } catch (ServletException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } } /** * @throws IOException * 根据商品名查询商品 * @param req * @param resp * @throws */ public void getGoodsListByName(HttpServletRequest req,HttpServletResponse resp) throws IOException { //设置请求编码格式: req.setCharacterEncoding("utf-8"); //设置响应编码格式 resp.setContentType("text/html;charset=utf-8"); String name = req.getParameter("goodsName"); String type = req.getParameter("type"); Map<String,String> parmas = new HashMap<>(); parmas.put("name", name); parmas.put("type", type); List<Goods> list = service.getGoodsByName(parmas); try { if(list != null) { JSONResult ok = JSONResult.ok(list); resp.getWriter().println(JsonUtil.javaObjectToJson(ok)); }else { JSONResult errorMsg = JSONResult.errorMsg("未获取到任何数据，请重试"); resp.getWriter().println(JsonUtil.javaObjectToJson(errorMsg)); } } catch (Exception e) { e.printStackTrace(); } } /** * 修改商品时，获取此商品的全部数据，并返回至修改页面 */ public void toGoodsUpdatePage(HttpServletRequest req,HttpServletResponse resp) { int id = Integer.parseInt(req.getParameter("id")); Goods goods = service.getGoodsInfoById(id); req.setAttribute("goods", goods); try { req.getRequestDispatcher("/backstage/tgls/goodsManage/goods_update.jsp").forward(req, resp); } catch (ServletException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } } /** *修改商品信息时，如果有修改图片，先将图片进行修改 * @throws IOException */ public void upGoodsImage(HttpServletRequest req,HttpServletResponse resp) throws IOException { //设置请求编码格式: req.setCharacterEncoding("utf-8"); //设置响应编码格式 resp.setContentType("text/html;charset=utf-8"); FileUploadUtil upFile = new FileUploadUtil(); ServletContext servletContext = req.getSession().getServletContext(); List<FileItem> items= upFile.getRequsetFileItems(req,servletContext); String savePath = "D:\\头条视频\\\\2020-12-16\\Gok_ShoppingMallx\\WebContent\\home\\img"; String imgName = null; try { //遍历 for (FileItem file : items) { if(!file.isFormField()) { String fileSuffix = FileUploadUtil.getFileSuffix(file); //必须是jpg或png 图片文件才能进行上传操作 i