基于Java与多语言融合的数码电商平台二期项目设计源码

package com.yc.web.servlets.admin; import com.yc.bean.Product; import com.yc.commons.DBHelper; import com.yc.utils.HtmlSanitizer; import com.yc.utils.PicUrl; import com.yc.web.model.AdminJsonModel; import com.yc.web.servlets.BaseServlet; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.io.IOException; import java.lang.reflect.InvocationTargetException; import java.util.ArrayList; import java.util.List; import java.util.Map; import java.util.regex.Matcher; import java.util.regex.Pattern; /** * 后台产品测试类 * @author SLGRoutine * @date 2024/6/21 */ @WebServlet("/admin/product.action") public class AdminProductServlet extends BaseServlet { DBHelper db = new DBHelper(); /** * 获取指定商品的商品描述，但是是反转义为html * pid 前端发送的请求参数 * * @param req * @param resp */ public void getHtmlDescription(HttpServletRequest req, HttpServletResponse resp) throws IOException { AdminJsonModel jm = new AdminJsonModel(); // 前端发送的请求参数 int pid = Integer.parseInt(req.getParameter("pid")); String sql = "select * from product where pid = ?"; List<Map<String,Object>> list = db.select(sql, pid); if (list == null || list.size() <= 0) { jm.setCode(1); jm.setMsg("商品详情查看失败"); super.writeObj(jm, resp); return; } String translation = (String) list.get(0).get("description"); // 这里获取到反编译的HTMl商品详情 String backTranslation = HtmlSanitizer.backTranslation(translation); jm.setCode(0); jm.setMsg("用户详情查询成功"); jm.setData(backTranslation); super.writeObj(jm, resp); } /** * 查询商品图片 * @param req * @param resp */ public void getProductPic(HttpServletRequest req, HttpServletResponse resp) throws IOException { AdminJsonModel jm = new AdminJsonModel(); // 从前台拿数据 int pid = Integer.parseInt(req.getParameter("pid")); String sql = "select url from product_pic where pid = ?"; List list = db.select(sql, pid); if (list.size() <= 0 || list == null) { jm.setCode(1); jm.setMsg("图片查询失败"); super.writeObj(jm, resp); return; } jm.setCode(0); jm.setMsg("图片查询成功"); jm.setData(list); super.writeObj(jm, resp); } /** * 添加商品 * * @param req * @param resp */ public void addProduct(HttpServletRequest req, HttpServletResponse resp) throws InvocationTargetException, InstantiationException, IllegalAccessException, IOException { // 回传前端对象 AdminJsonModel jm = new AdminJsonModel(); /** * 第一部分，执行商品的上传 */ int aid = 1;//默认一号管理员为超级管理员 // 获取前端发送数据 Product p = super.parseObjectFromRequest(req, Product.class); // apache转义方法，将商品描述中的标签转义一下 p.setDescription(HtmlSanitizer.translation(p.getDescription())); String pname = p.getPname();//商品名 String type = p.getType();//商品类型 System.out.println(type); String firm = p.getFirm();//厂商 String description = p.getDescription();//商品详细地址 int normprice = (int) p.getNormprice();//初始价格 String sql1 = "insert into product(aid,pname, description, type, firm, normprice,realprice) values (?,?,?,?,?,?,?)";//执行商品添加 List params = new ArrayList<>(); params.add(aid); params.add(pname); params.add(description); params.add(type); params.add(firm); params.add(normprice); params.add(normprice); //执行操作 int result = 0; try { result = db.doUpdate(sql1, params.toArray()); } catch (Exception e) { e.printStackTrace(); jm.setMsg(e.getMessage()); jm.setCode(1); } if (result <= 0) { jm.setMsg("商品添加失败"); jm.setCode(1); } // 到目前为止，我们还只进行了商品的增加 // 下面还要执行图片的添加 /** * 第二部分，执行图片的上传 * 此时图片其实已经传到OSS */ //刚刚插入的商品的pid int pid = (int) db.select("select pid from product order by pid desc limit 1").get(0).get("pid"); //上传的图片地址 List<String> picList = PicUrl.getaUrls(); //添加图片的sql String sql2 = "insert into product_pic( pid, url, is_primary) values (?,?,?)";//执行商品图片上传 //sql集合 List<String> sqls = new ArrayList<>(); //sql对应的参数集合 List<List<Object>> paramsList = new ArrayList<>(); for (int i = 0; i < picList.size(); i++) { if (!picList.get(i).equals("0")) { sqls.add(sql2); List<Object> picParams = new ArrayList<>(); picParams.add(pid); picParams.add(picList.get(i)); if (i == 0) picParams.add(1); else picParams.add(0); paramsList.add(picParams); } } // 正式执行批处理操作 int endResult = db.adminUpdate(sqls, paramsList); if (endResult <= 0) { jm.setCode(1);//后端1是失败 jm.setMsg("插入批处理更新失败"); super.writeObj(jm, resp); return; } jm.setCode(0); jm.setMsg("添加商品成功"); super.writeObj(jm, resp); } /** * 更新所有商品列表 * * @param req * @param resp */ public void updateProduct(HttpServletRequest req, HttpServletResponse resp) throws IOException, InvocationTargetException, InstantiationException, IllegalAccessException { // 回传前端对象 AdminJsonModel jm = new AdminJsonModel(); // 获取前端参数(这是固定参数，一定会传) Product p = super.parseObjectFromRequest(req, Product.class); int pid = p.getPid();//产品ID String pname = p.getPname();//产品名 String type = p.getType();//产品类型 String firm = p.getFirm();//生产厂商 String description = p.getDescription();//详情 description = HtmlSanitizer.translation(description); System.out.println(description); int status = p.getStatus();//状态 double normprice = p.getNormprice();//正常价格 double realprice = p.getRealprice();//优惠价格 /* HttpSession session =req.getSession(); Admin admin = (Admin) session.getAttribute("admin"); int aid = admin.getAid();//商家ID*/ String sql = "UPDATE product SET pname = ? , type = ? , firm = ? , description = ?, status = ? , normprice = ? , realprice = ? WHERE pid = ? ";//sql语句 List params = new ArrayList();//参数列表 params.add(pname); params.add(type); params.add(firm); params.add(description); params.add(status); params.add(normprice); params.add(realprice); params.add(pid); int result = 0; try { result = db.doUpdate(sql, params.toArray()); if (result <= 0) { jm.setCode(1); jm.setMsg("商品更新失败"); super.writeObj(jm, resp); return; } } catch (Exception e) { e.printStackTrace(); jm.setCode(1); jm.setMsg("异常信�