Written by spring-style
on 2021-12-20

[Spring]Spring쇼핑몰 프로젝트 - join으로 연관 테이블 정보 받아오기

< %@ 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 >

< head >

< meta charset = "UTF-8" >

< title > Insert title here < / title >

< link rel = "stylesheet" href = "" >

< / head >

< body >

< %@ include file = "../layout/sellerSidebar.jsp" % >

< div class = "main" >

< table border = "1" >

< tr style = "text-align: center;" >

< th > 주문번호 < / th >

< th colspan = "2" > 상품이름 < / th >

< th > 옵션 < / th >

< th > 수량 < / th >

< th > 주문자(이름) < / th >

< th > 배송비 < / th >

< th > 주문금액 < / th >

< th > 상태 < / th >

< / tr >

< c:set var = "num" value = "${listcount-(page-1)*10}" / >

< c:forEach var = "order" items = "${orderlist}" >

< tr >

< td >

< c:out value = "${num}" / >

< c:set var = "num" value = "${num-1}" / >

< / td >

< td style = "border-right: none;" >

< img src = "<%=request.getContextPath() %>/resources/images/thumbnailimage/${order.gds_thumbnail}" height = "100" width = "100" / >

< / td >

< td style = "border-left: none;" >

< a href = "sellerorderdetail?ol_num=${order.ol_num}&page;=${page}" > ${order.gds_name} < br > < br > < / a >

< div style = "text-align: right" > < a href = "goodsupdate?&gds;_num=${order.gds_num}" > 상품 수정하기 < / a > < / div >

< / td >

< td >

< c:choose >

< c:when test = "${order.opt_2ndval != null}" >

${order.opt_1stname} : ${order.opt_1stval} < br >

${order.opt_2ndname} : ${order.opt_2ndval}

< / c:when >

< c:when test = "${order.opt_1stval != null}" >

${order.opt_1stname} : ${order.opt_1stval}

< / c:when >

< c:otherwise >

< / c:otherwise >

< / c:choose >

< / td >

< td > ${order.ol_count} < / td >

< td > ${order.mem_id} < / td >

< td > < fmt:formatNumber value = "${order.deltem_delfee}" pattern = "#,###원" / > < / td >

< td > < fmt:formatNumber value = "${order.gds_price}" pattern = "#,###원" / > < / td >

< td > ${order.ord_status} < br >

< c:choose >

< c:when test = "${order.ord_delnum eq null }" >

< input type = "button" value = "송장번호 입력" >

< / c:when >

< c:when test = "${order.ord_delnum ne null }" >

${order.ord_delnum}

< / c:when >

< / c:choose >

< / td >

< / tr >

< / c:forEach >

< / table >

< / div >

< / body >

from http://issaac.tistory.com/10 by ccl(A) rewrite - 2021-12-20 17:01:25

Top