CREATE TABLE `customer` (
  `user_seq` bigint NOT NULL,
  `total_price` bigint DEFAULT 0,
  `total_month_price` bigint DEFAULT 0,
  `price_grade` tinyint DEFAULT 0,
  `join_date` timestamp NULL DEFAULT NOW(),
  `last_buy_date` timestamp,
  PRIMARY KEY (`user_seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

CREATE TABLE `admin`(
  `user_seq` bigint NOT NULL,
  `product_view_author` tinyint(1) DEFAULT 0,
  `product_update_author` tinyint(1) DEFAULT 0,
  `customer_view_author` tinyint(1) DEFAULT 0,
  `customer_update_author` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`user_seq`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

ALTER TABLE USER ADD ADMIN TINYINT(1) DEFAULT 0;

import java.util.Date;
import lombok.Data;
@Data
public class CustomerVO{
     private Long userSeq;
     private Long totalPrice;
     private Long totalMonthPrice;
     private    Byte priceGrade;
     private Date joinDate;
     private Date lastBuyDate;
}

import lombok.Data;
@Data
public class AdminVO{
     private Long userSeq;
     private boolean productViewAuthor;
     private boolean productUpdateAuthor;
     private boolean customerViewAuthor;
     private boolean customerUpdateAuthor;
}

<c:choose>
    <c:when test="${true eq userVO.admin}">
        <div class="col-md-3 col-xs-3">
            <a href="#">상품 관리</a>
        </div>
        <div class="col-md-3 col-xs-3">
            <a href="#">고객 관리</a>
        </div>
        <div class="dropdown col-md-3 col-xs-3">주문 관리</div>
        <div class="col-md-3 col-xs-3">게시판 관리</div>
    </c:when>
    <c:otherwise>
        <div class="col-md-3 col-xs-3">
            <a href="/main">메인화면</a>
        </div>
        <div class="col-md-3 col-xs-3">공지사항</div>
        <div class="dropdown col-md-3 col-xs-3">
            <div class="dropbtn">전체상품</div>
            <div class="dropdown-content">
                <a href="/product/list">디저트</a> <a href="/product/list">이유식</a>
            </div>
        </div>
        <div class="col-md-3 col-xs-3">
            <a href="/board/list?page=1&count=10">자유게시판</a>
        </div>
    </c:otherwise>
</c:choose>

alter table product add stock Long Default 0;
alter table product change pic img varchar(50)

<dependency>
    <groupId>com.fasterxml.jackson.core</groupId>
    <artifactId>jackson-databind</artifactId>
    <version>2.9.0</version>
</dependency>

<dependency>
    <groupId>org.codehaus.jackson</groupId>
    <artifactId>jackson-mapper-asl</artifactId>
    <version>1.9.13</version>
</dependency>

@Bean(name="jsonView")
public View mappingJacksonJsonView(){
    return new MappingJackson2JsonView();
}

@RequestMapping(value = "/post/{seq}", method = RequestMethod.DELETE)
public String delete(@PathVariable("seq") Long seq, Model model, HttpSession session) throws Exception {

    BoardVO boardVO = service.getBoardVO(seq);
    UserVO userVO = (UserVO) session.getAttribute("userVO");
    checkUserNull(userVO);

    ResultMap resultMap = service.deleteVO(seq, userVO, boardVO);
    model.addAllAttributes(resultMap);

    return"jsonView"
}

- webapp/resources/spring 아래에 있는 xml 설정파일을 삭제한다
- ex.config.config 패키지를 생성한다. 그리고 RootConfig.java 를 만들고 아래와 같이 코드를 작성
- xml 설정 파일 대신  ex.config.sample 에 있는 클래스를 bean으로 등록

- Webconfig.xml

- ex.config.sample 패키지를 만들고 bean 등록할 class를 생성한다
- Chef.java

- Restaurant.java

@Setter(onMethod_ = @Autowired)
private Chef chef;

- test 폴더에 ex.config.test 패키지 생성. 그리고 junit으로 Test할 JUnitCase 생성

   @Setter(onMethod_ = @Autowired)
   private Restaurant restaurant;
   
   
   @Test
   public void testExist() {
          
          assertNotNull(restaurant);
          log.info(restaurant);
          
          log.info("-----------------------------------------");
          
          log.info(restaurant.getChef());
          
   } } ~~~

Alter table product  Add create_date Timestamp  DEFAULT NOW() NOT NULL;

<insert id="createProductVO" parameterType="ProductVO">
           INSERT INTO product
           (                    
                   category
                  , pic
                  , title
                  , price
                  , text
                  , user_seq
           )
           VALUES
           (
                #{category}
                ,#{pic}
                ,#{title}
                ,#{price}
                ,#{text}
                ,#{userSeq}
                ,#{userSeq}
           )
     </insert>

@Override
public ResultMap createProduct(ProductVO productVO) throws Exception{
    int category = productVO.getCategory();
    String picSrc = productVO.getPic();
    String title = productVO.getTitle();
    Long price = productVO.getPrice();
    String text = productVO.getText();
    
    if(title == null || text == null || picSrc == null) {
        throw new LogicException("990", "알 수 없는 에러가 발생했습니다");
    }
    
    if(title.isEmpty()) {
        throw new LogicException("1000", "상품명을 입력해주세요");    
    }
    
    if(TITLE_SIZE_MAX < title.length()) {
        throw new LogicException("1001", "상품명이 너무 깁니다");
    }
    
    // 이미지 체크
    
    if(0 >= price) {
        throw new LogicException("1004", "가격은 1원 이상이여야 합니다");
    }
    
    if(PRICE_SIZE_MAX <= price) {
        throw new LogicException("1006", "가격은 1,000,000,000원 이하만 입력 가능합니다");
    }
    
    if(text.isEmpty()) {
        throw new LogicException("1007", "설명을 입력해주세요");                
    }
    
    if(TEXT_SIZE_MAX <= text.length()) {
        throw new LogicException("1008", "설명은 100자 이하여야 합니다");
    }
    
    int result = dao.createProduct(productVO);
    if(0 == result) {
        throw new LogicException("990", "알 수 없는 에러가 발생했습니다");
    }
    
    ResultMap resultMap = new ResultMap();
    resultMap.setStatus("200");
    resultMap.setMsg("");
    
    return resultMap;
}

@RequestMapping(value = "/post", method = RequestMethod.POST)
public String checkPost(HttpSession session, Model model) throws Exception {
    ResultMap resultMap = service.getCheckPost();
    model.addAllAttributes(resultMap);
    
    return JSON_VIEW;    
}

@RequestMapping(value = "/post", method = RequestMethod.PUT)
public String postProduct(@RequestBody ProductVO productVO, HttpSession session, Model model) throws Exception {
    ResultMap resultMap = service.createProduct(productVO);
    model.addAllAttributes(resultMap);
    
    return JSON_VIEW;
}

// 페이지 이동
$('#product-new-product-create').click(function(){
     console.log('product-new-product-create');
     ajaxRequest("/product/post", "", "POST",  "location.href='/product/post'");
});

// 상품 등록
$("#product-new-add-product").click(function(){
     var category = $('#product-add-select-input').val();
     var title = $('#product-title-input-text').val();
     var price = $('#product-price-input-text').val();
     var text = $('#product-text-input-text').val();
     
     if(category == undefined || title == undefined || price ==  undefined || text == undefined){
           return;
     }
     price = price.replace(",", "");
     
     var data ={
                "category":category,
                "title":title,
                "price":price,
                "text":text
     };
     
     ajaxRequest("/product/post", JSON.stringify(data), "PUT",  "location.href='/product/list'");    
});

CREATE TABLE `product` (
  `PRODUCT_SEQ` bigint(20) NOT NULL AUTO_INCREMENT,
  `CATEGORY` int NOT NULL,
  `PIC` text DEFAULT 'img/1.jpg',
  `TITLE` varchar(20) NOT NULL,
  `PRICE` bigint NOT NULL DEFAULT 0,
  `TEXT` varchar(100) DEFAULT '',
  `COUNT` bigint(20) DEFAULT 0,
  `PRODUCT_DEL` bigint(20) DEFAULT 0,
  `USER_SEQ` bigint(20),
  PRIMARY KEY (`PRODUCT_SEQ`)
  
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8

INSERT INTO PRODUCT(CATEGORY, TITLE, PRICE, TEXT)
VALUES(1005, '달콤유자케익', 20000, '유자를 흠뻑 넣은 케익');
INSERT INTO PRODUCT(CATEGORY, TITLE, PRICE, TEXT)
VALUES(1005, '자몽이슬톡톡', 3000, '이슬 톡톡');
INSERT INTO PRODUCT(CATEGORY, TITLE, PRICE, TEXT)
VALUES(1005, '머랭쿠키', 2000, '머랭~머랭~');

<select id="getProductVOList" resultType="ProductVO">
           SELECT product_seq as productSeq
                   , category
                   , pic
                   , title
                   , price
                   , text
                   , count
                   , product_del as productDel
                   , user_seq as userSeq
           FROM product         
     </select>

public ResultMap getProductVOList(){
    List<ProductVO> list = dao.getProductVOList();
    ResultMap resultMap = new ResultMap();
    resultMap.setStatus("200");
    resultMap.put("list", list);
    return     resultMap;
}

@RequestMapping(value = "/list", method = RequestMethod.GET)
public String list(Model model) throws Exception {
    ResultMap resultMap = service.getProductVOList();
    model.addAllAttributes(resultMap);
    
    return "product/list";    
}

<h2>상세 메뉴</h2>
<div><button id="product-new-product-create" class="btn  btn-info">새 상품 추가</button></div>
<div id="product-list" >
<c:forEach var = "product" items = "${list}">
<div class="row col-md-4 col-xs-12 product-elements">
     <input type="hidden" value="${product.productSeq}"/>
     <input type="hidden" value="${product.category}"/>
     <div><img src="/resources/${product.pic}" /></div>
     <div class="product-in-text">${product.title}</div>
     <div class="product-in-text">${product.price}원</div>
     <div class="product-in-text">${product.text}</div>
</div>
</c:forEach>
</div><!-- product-list -->

<div class="dropbtn">전체상품</div>
    <div class="dropdown-content">
        <a href="/product/list">디저트</a>
        <a href="/product/list">이유식</a>
    </div>
</div>