마카로닉스

1380 No

jsp 관리자 화면 상품 업데이트하기 쇼핑몰(Shoes) 프로젝트 - CJH - 32

2017-10-11 01:05:36 By 라이트 0 2141 댓글수 6 포스트 하기

10월 2025
일	월	화	수	목	금	토
			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30	31

AdminProductUpdateFormAction

package net.macaronics.web.admin.controller;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;

import net.macaronics.web.controll.action.Action;
import net.macaronics.web.dao.ProductDAO;
import net.macaronics.web.dto.ProductVO;

public class AdminProductUpdateFormAction implements Action {
	private static final Logger logger=LogManager.getLogger(AdminProductUpdateFormAction.class);
	
	@Override
	public void execute(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String url ="admin/product/productUpdate.jsp";
		
		String pseq =request.getParameter("pseq").trim();
		
		ProductDAO productDAO =ProductDAO.getInstance();
		ProductVO productVO=productDAO.getProduct(pseq);
		
		String str =productVO.getContent();
		String content=str.replaceAll("&lt;", "<").replaceAll("&gt;", ">");
		productVO.setContent(content);
		
		String pageNum="1";
		if(request.getParameter("pageNum")!=null || !request.getParameter("pageNum").trim().equals("")){
			pageNum=request.getParameter("pageNum");
		}
		
		logger.info(" AdminProductUpdateFormAction  - pageNum {}  " , pageNum) ;
		
		request.setAttribute("productVO", productVO);
		request.setAttribute("pageNum", pageNum);
		
		String kindList[] ={"남성운동화", "여성운동화","남성구두", "여성구두", "On Sale"};
		request.setAttribute("kindList", kindList);
		
		request.getRequestDispatcher(url).forward(request, response);
		
		
	}

}

productUpdate.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
      
<!DOCTYPE html>
<html class="no-js">   
    <head>
<jsp:include page="../../include/AdminHeader.jsp" />
        <!-- Bootstrap -->
<link rel="stylesheet" type="text/css" href="../../Bootstrap-Admin/vendors/bootstrap-wysihtml5/src/bootstrap-wysihtml5.css"></link>

    </head>   
    <body>
<jsp:include page="../../include/AdminTopFixMenu.jsp" />   
   
        
        <div class="container-fluid">
            <div class="row-fluid">
                <div class="span3" id="sidebar">
					 <jsp:include page="../../include/AdminLeftMenu.jsp" />   
                </div>
                
                <!--/span-->
                <div class="span9" id="content">
                    <div class="row-fluid">
                        <div class="alert alert-success">
							<button type="button" class="close" data-dismiss="alert">&times;</button>
                            <h4>상품 수정하기</h4>
                        </div>
                    	</div>
                   
                   <div>
                   <form action="MacaronicsServlet?command=admin_product_update" method="post" enctype="multipart/form-data"  name="form1">	 
                   	 <div class="table-responsive">
                   	 <table class="table">
           				<tr>
           				 <th class="success">상품 분류</th>
           				 <td colspan="5">
           				            				 			 
           				 	<select class="span6 m-wrap" name="kind">
           				 		<c:forEach items="${kindList }" var="kind" varStatus="status">
           				 			<option value="${status.count}" 
 										<c:out value="${ productVO.kind ==status.count ? 'selected':''}" />		
           				 			>${kind }</option>
           				 		</c:forEach>
           				 	</select>
           				 </td>
           				</tr>		
           				
           				<tr>
           				 <th class="success">상품명</th>
           				 <td colspan="5"><input type="text" name="name" id="name" value="${productVO.name}"></td>
           				</tr>	
           				
           				<tr>
           				 <th>원가</th><td><input type="text" name="price1"  id="price1" value="${productVO.price1}" ></td>
           				 <th>판매가</th><td><input type="text" name="price2" id="price2" onblur="go_ab()" value="${productVO.price2}" ></td>
           				 <th>마진</th><td width="10%"><input type="text" name="price3" id="price3" readonly="readonly" value="${productVO.price3}" ></td>
           				</tr>	
           			   
           			   <tr>
           				 <th>베스트 상품</th><td>
           				  <c:choose>
           				  	<c:when test="${productVO.bestyn =='y' }">
           				  	<input type="checkbox"  name="bestyn" checked />
           				  	</c:when>
           				  	<c:otherwise>
           				  	<input type="checkbox"  name="bestyn"  />
           				  	</c:otherwise>
           				  </c:choose>
           				 
           				 
           				 </td>
           				 <th>사용유무</th><td colspan="3">
           				 <c:choose>
           				  	<c:when test="${productVO.useyn =='y' }">
           				  	<input type="checkbox"  name="useyn"  checked="checked"/>
           				  	</c:when>
           				  	<c:otherwise>
           				  	<input type="checkbox"  name="useyn" />
           				  	</c:otherwise>
           				  </c:choose>
           				 
           				 </td>
           				</tr>	
           			    
           			    <tr>
           				 <th>상세설명</th>
           				 <td colspan="5"> 
	                      <textarea id="bootstrap-editor" style="width:98%;height:200px;" name="content">${productVO.content}</textarea> 
           				 </td>
           				</tr>
           				
           			 <tr>
           				 <th>상품 이미지</th>
           				 <td colspan="5"> 
           				 <img src="images/${productVO.image }" width="300" height="500" class="img-responsive">
	                       <input type="file" name="image" id="image"> 
           				 </td>
           				</tr>	
           							
           			 </table>
           			 
                   	 </div>
                   	<div class="text-center">
                   
                   			<input type="hidden" value="${productVO.pseq }" name="pseq" >
                   			<input type="hidden" value="${pageNum }" name="pageNum" >
                   			<input type="hidden" value="admin_product_update" name="command" id="command">
                   			<input type="hidden" value="${productVO.image }" name="orgImg" >
                   			
           			 		<input type="button" value="상품 수정하기"  class="btn btn-success" onclick="productSubmit()">
           			 		<input type="button" value="취소하기"  class="btn btn-warning" onclick="go_list()">
           			 	</div>
            	</form>
           			 
                   </div>
            
                    
                    </div>
                </div>
           
            </div>
            <hr>


<div style="margin-bottom: 150px;">
&nbsp;
</div>
     <!-- FOOTER -->
<nav class="avbar navbar-inverse navbar-fixed-bottom" style="height:50px  ;  background-color:#000  ;">
  <div class="container text-center" style="color:#fff;">
  <p>&nbsp;</p>
   <p ><a href="http://macaronics.net/" style="   color:#fff;">Macaronics.net</a></p>  
    <p>&nbsp;</p><p>&nbsp;</p>
  </div>
</nav>


        <!--/.fluid-container-->
        <script src="../../Bootstrap-Admin/vendors/bootstrap-wysihtml5/lib/js/wysihtml5-0.3.0.js"></script>
        <script src="../../Bootstrap-Admin/vendors/jquery-1.9.1.min.js"></script>
        <script src="../../Bootstrap-Admin/bootstrap/js/bootstrap.min.js"></script>
		<script src="../../Bootstrap-Admin/vendors/bootstrap-wysihtml5/src/bootstrap-wysihtml5.js"></script>
<script src="../../Bootstrap-Admin/vendors/bootstrap-wysihtml5/src/bootstrap-wysihtml5.js"></script>



 
 </body>
</html>

javaScript

 <script type="text/javascript">

$(function() {
    
	// Bootstrap
	$('#bootstrap-editor').wysihtml5();
	
});




function go_ab(){
	
	var price1=parseInt($("#price1").val());
	var price2=parseInt($("#price2").val());
	if(price2 <= price1){
		alert("판매가는 원가 보다 작을 수 없습니다.");
		$("#price1").val("");
		$("#price2").val("");
		$("#price1").focus();
		
		return;
	}
	$("#price3").val(price2-price1);
	
}


function go_ab3(){
	
	var price1=parseInt($("#price1").val());
	var price2=parseInt($("#price2").val());
	if(price2 <= price1){
		alert("판매가는 원가 보다 작을 수 없습니다.");
		$("#price1").val("");
		$("#price2").val("");
		$("#price1").focus();
		
		return false;
	}else{
		$("#price3").val(price2-price1);	
	}
	
	return true;
}

function productSubmit(){
	var name=$("#name").val();
	var price1=$("#price1").val();
	var price2=$("#price2").val();
	var content =$("content").val();
	
	if(name==""){
		alert("상품명을 입력해 주세요.");
		$("#name").focus();
		return ;
	}
	
	if(price1==""){
		alert("원가를 입력해 주세요.");
		$("#price1").focus();
		return ;
	}
	
	
	
	if(price2==""){
		alert("판매가를 입력해 주세요.");
		$("#price2").focus();
		return;
	}
	
	if(!go_ab3()){
		$("#price3").val("");
		return;
	}
	
	if( $("#image").val() != "" ){

		var ext = $('#image').val().split('.').pop().toLowerCase();
	    if($.inArray(ext, ['gif','png','jpg','jpeg']) == -1) {

		 alert('gif,png,jpg,jpeg 파일만 업로드 할수 있습니다.');

		 return;
	   }
	   
		
	}
	
	 document.form1.submit(); 
	
	
}

function go_list(){
	
	location.href="MacaronicsServlet?command=admin_product_list&pageNum=${pageNum}";
}



</script>

AdminProductUpdateAction

package net.macaronics.web.admin.controller;

import java.io.File;
import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;

import com.oreilly.servlet.MultipartRequest;
import com.oreilly.servlet.multipart.DefaultFileRenamePolicy;

import net.macaronics.web.admin.controller.dao.AdminProductDAO;
import net.macaronics.web.controll.action.Action;
import net.macaronics.web.dto.ProductVO;

public class AdminProductUpdateAction implements Action {
	
	private static final Logger logger=LogManager.getLogger(AdminProductUpdateAction.class);
	
	@Override
	public void execute(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String url ="MacaronicsServlet?command=admin_product_list&pageNum=";
		HttpSession session=request.getSession();
		
		int sizeLimit=5 * 1024 * 1024;
		String savePath="images";
		String uploadFilePath=session.getServletContext().getRealPath(savePath);
		
		
		MultipartRequest multi =new MultipartRequest(request, //1. 요청 객체
				uploadFilePath, //2.업로드될 파일의 저장될 파일 경로명
				sizeLimit, //3. 업로드될 파일의 최대 크기 (5MB)
				"UTF-8", //4. 인코딩 타입 지정
				new DefaultFileRenamePolicy());
		//이시점을 기해 파일은 이민 저장이 되어 있다.

		
		ProductVO productVO=new ProductVO();
		productVO.setPseq(Integer.parseInt(multi.getParameter("pseq")));
		productVO.setKind(multi.getParameter("kind"));
		productVO.setName(multi.getParameter("name"));
		productVO.setPrice1(Integer.parseInt(multi.getParameter("price1")));
		productVO.setPrice2(Integer.parseInt(multi.getParameter("price2")));
		productVO.setPrice3(Integer.parseInt(multi.getParameter("price2")) - Integer.parseInt(multi.getParameter("price1")));
		
		
		String bestyn=multi.getParameter("bestyn");
		String useyn=multi.getParameter("useyn");
		if(bestyn==null) bestyn="n";
		else bestyn="y"; 	
		
		if(useyn==null) useyn="n";
		else useyn="y";
		
		productVO.setBestyn(bestyn);
		productVO.setUseyn(useyn);
		
		productVO.setContent(multi.getParameter("content"));
		
		
		if(multi.getFilesystemName("image")==null){
			//이미지 파일을 업로드 하지 않았으면 기존의 이미지 사용
			productVO.setImage(multi.getParameter("orgImg"));
		}else{
			productVO.setImage(multi.getFilesystemName("image"));
			//기존 이미지 파일 지우기
			File file =new File(uploadFilePath+File.separator+multi.getParameter("orgImg"));
			logger.info("uploadFilePath -   {}" , uploadFilePath);
			if(file.exists()){
				file.delete();
				logger.info("파일 삭제 -   {}" );
			}
		}
		
		AdminProductDAO amdinProductDAO=AdminProductDAO.getInstance();
		amdinProductDAO.updateProduct(productVO);
		
		
		logger.info("AdminProductUpdateAction -   {}" , productVO.toString());
		
		response.sendRedirect(url+multi.getParameter("pageNum"));
		
	}

}

DAO

	//상품 수정
	public void updateProduct(ProductVO product){
		try{
			sqlSession=MybatisService.getFactory().openSession();
			sqlSession.update("adminProduct.updateProduct", product);
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			sqlSession.commit();
			MybatisService.sessionClose(sqlSession);
		}
		
	}

Mapper

	<update id="updateProduct">
		
 update TBL_PRODUCT SET kind=#{kind}, useyn =#{useyn}, name=#{name},
   price1=#{price1} , price2=#{price2}, price3=#{price3}, content=#{content}, image=#{image} ,
   bestyn=#{bestyn}  where pseq=#{pseq}
	
	</update>

제작 : macaronics.net - Developer Jun Ho Choi

소스 : https://github.com/braverokmc79/jsp_sin

${request.getContextPath() } 처리를 안한 부분이 있으므로

루트 설정( http://macaronics.net/index.php/m01/jsp/view/1352) 및 server.xml 에서 DB 컨넥션 설정은 필수 설정이다.

jsp