[75일] Spring (22) - MyBatis 프로젝트 (수정)

ProductCont.java

	@RequestMapping("/update")
	public String update(@RequestParam Map<String, Object> map
					   , @RequestParam MultipartFile img
					   , HttpServletRequest req) {
		
		String filename = "-";
		long filesize = 0;
		if(img != null && !img.isEmpty()) {
			filename = img.getOriginalFilename();
			filesize = img.getSize();
			try {
				
				ServletContext application = req.getSession().getServletContext();
				String path = application.getRealPath("/storage");
				//System.out.println(path);
				//I:\java202207\workspace_spring\spring07_myshop\src\main\webapp\storage
				img.transferTo(new File(path+"\\"+filename));
				
			} catch (Exception e) {
				e.printStackTrace(); //System.out.println(e);
			}//try end
		} else {
			String product_code = map.get("product_code").toString();
			Map<String, Object> product = productDao.detail(product_code);
			filename = product.get("FILENAME").toString();
			filesize = Long.parseLong(product.get("FILESIZE").toString());
		}//if end
		
		map.put("filename", filename);
		map.put("filesize", filesize);
		productDao.update(map);
		return "redirect:/product/list";
	}//update() end

 

 

 

ProductDAO.java

	public void update(Map<String, Object> map) {
		sqlSession.update("product.update", map);
	}//update() end

 

 

 

product.xml

	<update id="update">
		UPDATE product
		SET product_name=#{product_name}
			,price=#{price}
			,description=#{description}
			,filename=#{filename}
		WHERE product_code=#{product_code}
	</update>