基于javaweb+mysql的springboot奶茶商城外卖点餐(springboot+mysql+jsp)

基于javaweb+mysql的springboot奶茶商城外卖点餐(springboot+mysql+jsp)

私信源码获取及调试交流

运行环境

Java≥8、MySQL≥5.7

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb+mysql的SpringBoot奶茶商城外卖点餐(springboot+mysql+jsp)

密码均为：12346

	OrdermsgdetailsDAO ordermsgdetailsDAO;
	@Resource
	MemberDAO memberDAO;
	@Resource
	InventoryDAO inventoryDAO;
	

	@RequestMapping("/admin/statisticsNum")
	public  String saleProduct(HttpServletRequest request) {
		User shop = (User)request.getSession().getAttribute("admin");

		HashMap map = new HashMap();
		if(shop.getRoleid()==15){
			map.put("saver", shop.getId());
		}
		//
		map.put("leibie", "购买商品");
		List<Product> plist = productDao.selectProductAll(map);
		//ArrayList nslist = new ArrayList();
		ArrayList nlist = new ArrayList();
		ArrayList slist = new ArrayList();
		
		String data = "[";
    		 int i = 0;
		for(Product product:plist){
			i++;
			int outnum = 0;
			HashMap map1 = new HashMap();
			map1.put("productid", product.getId());
			map1.put("type", "out");
			System.out.println(map);
			List<Inventory> outlist = inventoryDAO.selectAll(map1);
			for(Inventory out:outlist){
				outnum += out.getNum();
			}
//			nlist.add("'"+product.getProductname()+"'");
//			slist.add(outnum);
			data += "{value:"+outnum+",name:'"+product.getProductname()+"'}";
			if(i <= plist.size()-1){
				data += ",";
			}
		}
		data += "]";
		request.setAttribute("data", data);
		System.out.println(data);

	}

	//去申请售后页面
	@RequestMapping("toShapply")
	public String toShapply(int id,HttpServletRequest request){
		Member member = (Member) request.getSession().getAttribute("sessionmember");
		request.setAttribute("orderid",id);
		Ordermsg ordermsg = ordermsgDAO.findById(id);
		HashMap map = new HashMap();
		map.put("ddno", ordermsg.getDdno());
		map.put("ph", "y");
		map.put("memberid", member.getId());
		map.put("orderid", ordermsg.getId());
		List<Ordermsgdetails> orderdetaillist = ordermsgdetailsDAO.selectAll(map);
		for(Ordermsgdetails ordermsgdetails: orderdetaillist){
			ordermsgdetails.setProduct(productDAO.findById(Integer.valueOf(ordermsgdetails.getProductid())));
		}
		request.setAttribute("orderdetaillist",orderdetaillist);

		saveobject.getCart(request);
		saveobject.getCategoryObject(request);
		return "shapplyAdd";
	}

	//添加售后申请
	@RequestMapping("shapplyAdd")
	public String shapplyAdd(Shapply shapply,HttpServletRequest request){
		Member member = (Member) request.getSession().getAttribute("sessionmember");
		Ordermsg order = ordermsgDAO.findById(shapply.getOrderid());
		shapply.setShstatus("待受理");
		shapply.setMemberid(member.getId());
		shapply.setLxr(member.getTname());
		shapply.setTel(member.getTel());
		shapplyDAO.add(shapply);

		return "redirect:shapply";
	}

		jscode+="<img style=\"cursor: hand\" οnclick=\"uploadimg()\" src=\"/vehiclemanagementsys/js/nopic.jpg\" id=txt height=\""+height+"\"/>";
		jscode+="<input type=hidden name=\"filename\" id=\"filename\" value=\"\" />";
		return jscode;
	}
	
	
	
	public static String getImgUpInfo2(int height)
	{
		String jscode = "";
		jscode+="<img style=\"cursor: hand\" οnclick=\"uploadimg2()\" src=\"/vehiclemanagementsys/js/nopic.jpg\" id=txt2 height=\""+height+"\"/>";
		jscode+="<input type=hidden name=\"filename2\" id=\"filename2\" value=\"\" />";
		return jscode;
	}
	
	public static String getImgUpInfo3(int height)
	{
		String jscode = "";
		jscode+="<img style=\"cursor: hand\" οnclick=\"uploadimg3()\" src=\"/vehiclemanagementsys/js/nopic.jpg\" id=txt3 height=\""+height+"\"/>";
		jscode+="<input type=hidden name=\"filename3\" id=\"filename3\" value=\"\" />";
		return jscode;
	}
	
	public static String getImgUpInfo4(int height)
	{
		String jscode = "";
		jscode+="<img style=\"cursor: hand\" οnclick=\"uploadimg4()\" src=\"/vehiclemanagementsys/js/nopic.jpg\" id=txt4 height=\""+height+"\"/>";
		jscode+="<input type=hidden name=\"filename4\" id=\"filename4\" value=\"\" />";
		return jscode;
	}
	
	public static String getImgUpInfo5(int height)
	{
		String jscode = "";
		jscode+="<img style=\"cursor: hand\" οnclick=\"uploadimg5()\" src=\"/vehiclemanagementsys/js/nopic.jpg\" id=txt5 height=\""+height+"\"/>";
		jscode+="<input type=hidden name=\"filename5\" id=\"filename5\" value=\"\" />";

	}
	
	@RequestMapping("/admin/showCategory")
	public String showCategory(int id,HttpServletRequest request){
		Category category =  categoryDAO.findById(id);
		request.setAttribute("category", category);
		return "categoryedit";
	}
	
	@RequestMapping("/admin/categoryEdit")
	public String categoryEdit(Category category,HttpServletRequest request){
		categoryDAO.update(category);
		request.setAttribute("category", category);
		return "redirect:categoryList";
	}
	
	@RequestMapping("admin/categoryDelAll")
	public String categoryDelAll(int id, HttpServletRequest request,HttpServletResponse response){
		categoryDAO.delete(id);
		return "redirect:categoryList";
	}
	
	
	//类别二级联动
	@RequestMapping("admin/searchCtype")
	public void searchCtype(HttpServletRequest request,HttpServletResponse response){
		String fatherid = request.getParameter("fatherid")==null?"":request.getParameter("fatherid");
		String xml = "";
		if(!fatherid.equals("")){
	    List<Category> list = categoryDAO.selectScategory(Integer.parseInt(fatherid));
		if(list.size()>0){
		    for(Category category:list){
		    	xml += "<option value='"+category.getId()+"'>"+category.getName()+"</option>";
			}
		}else{
			xml ="<option value=''>请选择上一级目录</opion>";
		}
		}else{
			xml ="<option value=''>请选择上一级目录</opion>";
		}
 		response.setCharacterEncoding("utf-8");
		response.setContentType("application/json");
 		PrintWriter out;
		try {

		ordermsgDAO.update(ordermsg);
		return "redirect:fubiOrder";
	}
	
	@RequestMapping("fubiorderSc")
	public String fubiorderSc(int id,HttpServletRequest request){
		Ordermsg ordermsg = ordermsgDAO.findById(id);
		ordermsg.setDelstatus("1");
		ordermsgDAO.update(ordermsg);
		return "redirect:fubiOrder";
	}

	//删除订单
		@RequestMapping("orderSc")
		public String orderSc(int id,HttpServletRequest request){
			Ordermsg ordermsg = ordermsgDAO.findById(id);
			ordermsg.setDelstatus("1");
			ordermsgDAO.update(ordermsg);
			return "redirect:orderLb";
		}
		
		//删除订单
		@RequestMapping("admin/fubiorderDel")
		public String fubiorderDel(int id,HttpServletRequest request){
			Ordermsg ordermsg = ordermsgDAO.findById(id);
			ordermsg.setDelstatus("1");
			ordermsgDAO.update(ordermsg);
			return "redirect:fubiorderList";
		}
	
		
	
	
	//使用优惠券
		@RequestMapping("updateYhtotal")
		public void updateYhtotal(HttpServletRequest request, HttpServletResponse response) {
			PrintWriter out;
			try {
				out = response.getWriter();

		saveobject.getCategoryObject(request);
		return "fubilb";
	}
	
	
	
	//推荐商品
	@RequestMapping("admin/udateIstj")
	public String udateIstj(HttpServletRequest request){
		String id = request.getParameter("id");
		String istj = request.getParameter("type");
		String shop = request.getParameter("shop");
		Product product = productDAO.findById(Integer.parseInt(id));
		product.setIstj(istj);
		productDAO.update(product);
		return "redirect:productMsg";
	}
	
	
	//商品上下架
	@RequestMapping("admin/udateIssj")
	public String udateIssj(HttpServletRequest request){
		String id = request.getParameter("id");
		String shop = request.getParameter("shop");
		Product product = productDAO.findById(Integer.parseInt(id));
		if(product.getIssj().equals("yes")){
			product.setIssj("no");
		}else{
			product.setIssj("yes");
		}
		productDAO.update(product);
		return "redirect:productMsg";
	}
	
	
	@RequestMapping("admin/updatefbIssj")
	public String updatefbIssj(HttpServletRequest request){
		String id = request.getParameter("id");
		Product product = productDAO.findById(Integer.parseInt(id));
		if(product.getIssj().equals("yes")){
			product.setIssj("no");
		}else{

	        request.setAttribute("zphlist", zphlist);
		}
		return zphlist;
		
	}
	
	
}

@Controller
public class CartController extends BaseController {
	@Resource
	CartDAO cartDAO;
	@Resource
	MemberDAO memberDAO;
	@Resource
	ProductDAO productDAO;
	@Resource
	CategoryDAO categoryDAO;
	@Resource
	Saveobject saveobject;
	@Resource
	OrdermsgDAO ordermsgDAO;
	
	

	// 查询购车商品
	@RequestMapping("cartList")
	public String cartList(HttpServletRequest request) {
		Member member = (Member) request.getSession().getAttribute(
				"sessionmember");
		    //double zk = saveobject.getzk(member.getId());
			HashMap map = new HashMap();
			map.put("memberid", member.getId());

	ProductDAO productDAO;
	@Resource
	Saveobject saveobject;
	@Resource
	OrdermsgDAO ordermsgDAO;
	@Resource
	ShapplyDAO shapplyDAO;
	@Resource
	OrdermsgdetailsDAO ordermsgdetailsDAO;
	@Resource
	InventoryDAO inventoryDAO;

	//后台查询售后列表
	@RequestMapping("/admin/shapplyList")
	public String shapplyList(@RequestParam(defaultValue = "1",value = "pageNum") Integer pageNum,HttpServletRequest request) {
		User admin = (User)request.getSession().getAttribute("admin");
		HashMap map = new HashMap();
		if(admin.getRoleid()==15){
			map.put("saver", admin.getId());
		}
		PageHelper.startPage(pageNum, 10);
		List<Shapply> list = shapplyDAO.selectAll(map);
		for(Shapply sh:list){
			Product product = productDAO.findById(sh.getProductid());
			sh.setProduct(product);
			Member mb = memberDAO.findById(sh.getMemberid());
			sh.setMember(mb);
		}
		PageInfo<Shapply> pageInfo =  new PageInfo<Shapply>(list);
		request.setAttribute("pageInfo",pageInfo);
		return "shapplylist";
	}

	//去录入单号
	@RequestMapping("towlnoadd")
	public String towlnoadd(int id,HttpServletRequest request){
		Shapply shapply = shapplyDAO.findById(id);

		request.setAttribute("shapply",shapply);

                rs.close();
                st.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
            Enumeration enumeration = request.getParameterNames();
            String names = ",";
            while (enumeration.hasMoreElements()) {
                names += enumeration.nextElement().toString() + ",";
            }
            try {
                Statement st = conn.createStatement();
                for (String str : collist) {
                    if (names.indexOf("," + str + ",") > -1) {
                        String[] values = request.getParameterValues(str);
                        String value = "";
                        for (String vstr : values) {
                            if (vstr == null) vstr = "";
                            if (vstr.equals("null")) vstr = "";
                            if (vstr.trim().equals("")) continue;

                            if (request.getParameter(vstr) != null && !"".equals(request.getParameter(vstr)) && request.getParameter("dk-" + str + "-value") != null) {
                                String dkv = request.getParameter(vstr);
                                String dknamevalue = request.getParameter("dk-" + str + "-value");
                                vstr += " - " + dknamevalue + ":" + dkv;
                            }

                            value += vstr + " ~ ";

                        }
                        if (value == null) value = "";
                        if (value.equals("null")) value = "";
                        if (value.length() > 0) value = value.substring(0, value.length() - 3);

                        if (typemap.get(str + "---").equals("int")) {
                            sql += (value.equals("") ? -10 : value) + ",";
                        } else {
                            sql += "'" + (value.equals("null") ? "" : value) + "',";
                        }

			msg = "请先登录";
			request.setAttribute("msg", msg);
		}
		if(suc.equals("suc")){
			request.setAttribute("suc", "评论成功");
		}else if(suc.equals("error")){
			request.setAttribute("suc", "请先登录");
		}else if(suc.equals("err")){
			request.setAttribute("suc", "没有购买记录,评论失败");
		}
		
		
		//评论
		HashMap mmm = new HashMap();
		mmm.put("productid", product.getId());
		List<Comment> commentlist = commentDAO.selectAll(mmm);
		for(Comment comment:commentlist){
			Member member = memberDAO.findById(Integer.parseInt(comment.getMemberid()));
			comment.setMember(member);
		}
		
		request.setAttribute("product", product);
		request.setAttribute("commentlist", commentlist);
		saveobject.getCart(request);
		saveobject.getCategoryObject(request);
		
		//相似商品
		map = new HashMap();
		map.put("sid", product.getSid());
		map.put("issj", "yes");
		System.out.println(map);
		List<Product> xslist = productDAO.selectAll(map);
		request.setAttribute("xslist", xslist);
		
	
		return "productdetails";
	}
	
	
	@RequestMapping("fubix")
	public String fubix(int id,HttpServletRequest request){
		
		String msg = request.getParameter("msg");
		String suc = request.getParameter("suc")==null?"":request.getParameter("suc");
		Product product =  productDAO.findById(id);
		product.setJf(new Double(product.getPrice()).intValue());
		if(msg!=null){

	//推荐商品
	@RequestMapping("admin/udateIstj")
	public String udateIstj(HttpServletRequest request){
		String id = request.getParameter("id");
		String istj = request.getParameter("type");
		String shop = request.getParameter("shop");
		Product product = productDAO.findById(Integer.parseInt(id));
		product.setIstj(istj);
		productDAO.update(product);
		return "redirect:productMsg";
	}
	
	
	//商品上下架
	@RequestMapping("admin/udateIssj")
	public String udateIssj(HttpServletRequest request){
		String id = request.getParameter("id");
		String shop = request.getParameter("shop");
		Product product = productDAO.findById(Integer.parseInt(id));
		if(product.getIssj().equals("yes")){
			product.setIssj("no");
		}else{
			product.setIssj("yes");
		}
		productDAO.update(product);
		return "redirect:productMsg";
	}
	
	
	@RequestMapping("admin/updatefbIssj")
	public String updatefbIssj(HttpServletRequest request){
		String id = request.getParameter("id");
		Product product = productDAO.findById(Integer.parseInt(id));
		if(product.getIssj().equals("yes")){
			product.setIssj("no");
		}else{
			product.setIssj("yes");
		}
		productDAO.update(product);
		return "redirect:fubiList";
	}
	
	//特价页面
	@RequestMapping("admin/skiptjprice")
	public String skiptjprice(HttpServletRequest request){
		String id = request.getParameter("id");
		Product product = productDAO.findById(Integer.parseInt(id));
		request.setAttribute("product", product);
		return "tjprice";
	}
	

					   //System.out.println(f);

					   bis = new BufferedInputStream((InputStream)new FileInputStream(request.getSession().getServletContext().getRealPath("upload")+"/"+filename));
					   fos = response.getOutputStream();
					    bos = new BufferedOutputStream(fos);

					    int bytesRead = 0;
					    byte[] buffer = new byte[5 * 1024];
					    while ((bytesRead = bis.read(buffer)) != -1) {
					     bos.write(buffer, 0, bytesRead);
					    }
					    bos.close();
					    bis.close();
					    fos.close();
		              // new Info().delPic(request.getRealPath("/upfile/")+"/", filename);
		     } catch (Exception e) {
				e.printStackTrace();
			}finally{
			}
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occurs
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}

		    mmm.put("goodstype", "购买商品");
		    saveobject.hotSales("", request);
		return "cartlist";
	}

	// 添加购物车
	@RequestMapping("addCart")
	public void addCart(HttpServletRequest request, HttpServletResponse response) {
		PrintWriter out;
		try {
			out = response.getWriter();
			Member member = (Member) request.getSession().getAttribute(
					"sessionmember");
			if (member != null) {
				String productid = request.getParameter("productid");
				int kc = saveobject.getInvertory(Integer.valueOf(productid), request);
				String num = request.getParameter("num");
				String tiandu = request.getParameter("tiandu");
				String wendu = request.getParameter("wendu");
				String bz = tiandu+","+wendu;
				if(Integer.valueOf(num) > kc){
					out.print("2");
				}else{
					//判断是否是购买自己的商品
					Product product = (Product)productDAO.findById(Integer.parseInt(productid));
					HashMap map = new HashMap();
					map.put("memberid", member.getId());
					map.put("productid", productid);
					map.put("bz", bz);
					List<Cart> list = cartDAO.selectAll(map);
					if (list.size() == 0) {
						Cart cart = new Cart();
						cart.setMemberid(member.getId());
						cart.setProductid(Integer.parseInt(productid));
						cart.setNum(Integer.parseInt(num));
						cart.setShopid(Integer.valueOf(product.getSaver()));
						cart.setBz(bz);
						cartDAO.add(cart);
					} else {
						Cart ct = new Cart();
						ct.setId(list.get(0).getId());
						ct.setNum(list.get(0).getNum() + Integer.parseInt(num));
						cartDAO.update(ct);
					}
					
					out.print("1");
				}
			} else {
				out.println("0");
			}
		} catch (IOException e) {

					// TODO Auto-generated catch block
					e1.printStackTrace();
				} catch (WriteException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}    
	            }    
	   
	            try {    
	                //从内存中写入文件中    
	                wwb.write();    
	                //关闭资源，释放内存    
	                wwb.close();    
	            } catch (IOException e) {    
	                e.printStackTrace();    
	            } catch (Exception e) {    
	                e.printStackTrace();    
	            }    
	        }
	        
	        try {
				response.sendRedirect("/vehiclemanagementsys/upload?filename="+fileName.substring(fileName.lastIndexOf("/")+1));
			} catch (IOException e) {
				e.printStackTrace();
			}
	        
	    }    
	 
	 
	 public static String getcheckbox(String name,String tablename,String zdname,String where)
	 { 
		 String checkbox="";
		 for(HashMap permap:new CommDAO().select("select * from "+tablename+" where "+where+" order by id desc")){ 
			 
			 String optionstr = "";
			 for(String str:zdname.split(";"))
			 {
				 String zdstr = str.split("~")[0];
				 String zdnamestr = str.split("~")[1].equals("无名")?"":(str.split("~")[1]+":");
				 optionstr+=zdnamestr+permap.get(zdstr)+" - ";
			 }
			 if(optionstr.length()>0)optionstr=optionstr.substring(0,optionstr.length()-3);
			 
			 checkbox+="<label><input type='checkbox' name='"+name+"' value=\""+optionstr+"\">"+optionstr+"</label>\n";
		 }
		 checkbox+="<input type=hidden name='"+name+"' value='' />";
		 return checkbox;

								",id:"+childmenus.getId()+
								",field:'menuid'";
				List<Menus> minlist = menusDAO.selectminAll(childmenus.getId());
				HashMap map2 = new HashMap();
				map2.put("roleid", roleid);
				map2.put("menuid", childmenus.getId());
				
				List<Permissions> cklist2 = permissionsDAO.check(map2);
				//System.out.println("roleid="+roleid + "--  childmenus.getId()="+childmenus.getId()+"--- "+cklist2.size());
				if(cklist2.size()>0){
					jsonContent += ",checked:"+true;
				}
				if(j==childlist.size()){
					jsonContent += "}";
				}else{
					jsonContent += "},";
				}
			}
			jsonContent += "]";
			if(i==menuslist.size()){
				jsonContent += "}";
			}else{
				jsonContent += "},";
			}
		}
		jsonContent = jsonBegin+jsonContent+jsonEnd;
		model.addAttribute("jsonContent",jsonContent);
//		request.setAttribute("menuslist",menuslist);
		model.addAttribute("roleid",roleid);
		
		return "permissionslist";
	}
	
	/**
	 * 保存权限
	 * @param roletab
	 * @param request
	 * @return
	 */
	@RequestMapping("admin/permissionsAdd")
	public void permissionsAdd(int roleid, String jsonStr, HttpServletRequest request, HttpServletResponse response) {
		try {
			permissionsDAO.deleteAll(roleid);//先全部删除
			JSONArray arr=new JSONArray(jsonStr);
			org.json.JSONObject obj = null;
			for(int i=0,l=arr.length();i<l;i++){
				obj=arr.getJSONObject(i);
				System.out.println(obj.get("title"));

	
	/**
	 * 功能列表
	 * @param request
	 * @return
	 */
	@RequestMapping("admin/menusList")
	public String menusList(Model model) {
		List<Menus> list = menusDAO.selectfatherAll();
		for(Menus menus:list){
			List<Menus> childlist = menusDAO.selectchildAll(menus.getId());
			menus.setChildlist(childlist);
			for(Menus childmenus:childlist){
				List<Menus> minlist = menusDAO.selectminAll(childmenus.getId());
				childmenus.setMinlist(minlist);
			}
		}
		model.addAttribute("list", list);
		return "menuslist";
	}
	
	/**
	 * 添加功能
	 * @param menus
	 * @param request
	 * @return
	 */
	@RequestMapping("/admin/menusAdd")
	public String menusAdd(Menus menus,HttpServletRequest request,RedirectAttributes redirectAttributes){
		String type = request.getParameter("type");
		if(type.equals("father")){
			menus.setFatherid(0);
			menus.setLeaf(1);
			menusDAO.add(menus);
		}else if(type.equals("leaf")){
			Menus m = menusDAO.findById(menus.getFatherid());
			m.setLeaf(0);
			menusDAO.update(m);
			menus.setLeaf(1);
			menusDAO.add(menus);
		}

		addMessage(redirectAttributes, "添加成功!");
		return "redirect:menusList";
	}
	
	
	
	/**
	 * 编辑功能查询
	 * @param id

			 if(optionstr.length()>0)optionstr=optionstr.substring(0,optionstr.length()-3);
			 
			 checkbox+="<label><input type='checkbox' name='"+name+"' value=\""+optionstr+"\">"+optionstr+"</label>\n";
		 }
		 checkbox+="<input type=hidden name='"+name+"' value='' />";
		 return checkbox;
	 }
	 
	 
	 
	 public static String getcheckboxDk(String name,String tablename,String zdname,String nstr,String where)
	 { 
		 String checkbox="";
		 int i=0;
		 for(HashMap permap:new CommDAO().select("select * from "+tablename+" where "+where+" order by id desc")){ 
			 
			 String optionstr = "";
			 for(String str:zdname.split(";"))
			 {
				 String zdstr = str.split("~")[0];
				 String zdnamestr = str.split("~")[1].equals("无名")?"":(str.split("~")[1]+":");
				 optionstr+=zdnamestr+permap.get(zdstr)+" - ";
			 }
			 if(optionstr.length()>0)optionstr=optionstr.substring(0,optionstr.length()-3);
			 String nbs = "";
			 if(i>0)nbs="&nbsp;";
			 checkbox+="<label>"+nbs+"<input type='checkbox' name='"+name+"' value=\""+optionstr+"\">"+optionstr+"</label>&nbsp;&nbsp;\n";
			 checkbox+="<label>&nbsp;- "+nstr+" &nbsp;<input type='text' size='5' name='"+optionstr+"' value=\"\"></label><br />\n";
			 i++;
		 }
		 checkbox+="<input type=hidden name='"+name+"' value='' /><input type=hidden name='dk-"+name+"-value' value='"+nstr+"' />";
		 return checkbox;
	 }
	 

	 public static String getFileUpInfo()
		{
			String jscode = "";
			jscode+="<font οnclick=\"uploaddoc()\" src=\"js/nopic.jpg\" style='cursor:hand' id=txt >点击此处上传</font>";
			jscode+="&nbsp;&nbsp;<input type=text readonly style='border:0px' size=30  name=\"docname\" id=\"docname\" value=\"\" />";
			return jscode;
		}

	  public static String tform(HashMap map)

	@Resource
	UserDAO userDAO;
	@Resource
	FavDAO favDAO;
	//后台查询商品列表
	@RequestMapping("/admin/productList")
	public String productList(@RequestParam(defaultValue = "1",value = "pageNum") Integer pageNum,HttpServletRequest request) {
		User admin = (User)request.getSession().getAttribute("admin");
		String key = request.getParameter("key");
		String fid = request.getParameter("fid")==null?"":request.getParameter("fid");
		String sid = request.getParameter("sid")==null?"":request.getParameter("sid");
	    HashMap map = new HashMap();
	   	List<Category> fcategorylist = categoryDAO.selectFcategory(map);
	   	if(!fid.equals("")){
	   	List<Category> scategorylist = categoryDAO.selectScategory(Integer.parseInt(fid));
	   	request.setAttribute("scategorylist", scategorylist);
	   	}
		if(admin.getRoleid()==15){
			map.put("saver", admin.getId());
		}
		map.put("key", key);
		map.put("fid", fid);
		map.put("sid", sid);
		map.put("productid", "-1");
		map.put("leibie", "购买商品");
		if(!admin.getUsertype().equals("管理员")){
			map.put("saver", admin.getId());
		}
		PageHelper.startPage(pageNum,10);
		List<Product> list = productDAO.selectAll(map);
		DecimalFormat df = new DecimalFormat("#.00");
		for(Product product:list){
			Category fcategory = categoryDAO.findById(Integer.parseInt(product.getFid()));
			Category scategory = categoryDAO.findById(Integer.parseInt(product.getSid()));
			product.setFcategory(fcategory);
			product.setScategory(scategory);

			HashMap map5 = new HashMap();
			map5.put("productid", product.getId());
			map5.put("flag", "y");
			List<Comment> clist = commentDAO.selectAll(map5);