AdminDeleteAction
package kr.item.action;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import kr.controller.Action;
import kr.item.dao.ItemDAO;
import kr.item.vo.ItemVO;
import kr.util.FileUtil;
public class AdminDeleteAction implements Action{
@Override
public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception {
HttpSession session = request.getSession();
Integer user_num = (Integer)session.getAttribute("user_num");
if(user_num==null) {
return "redirect:/member/loginForm.do";
}
Integer user_auth = (Integer)session.getAttribute("user_auth");
if(user_auth !=9) {
return "/WEB-INF/views/common/notice.jsp";
}
//관리자로 로그인한 경우
int item_num = Integer.parseInt(request.getParameter("item_num"));
ItemDAO dao = ItemDAO.getInstance();
ItemVO db_item = dao.getItem(item_num);
//상품 삭제
dao.deleteItem(item_num);
//상품 이미지 삭제
FileUtil.removeFile(request,db_item.getPhoto1());
FileUtil.removeFile(request,db_item.getPhoto2());
request.setAttribute("notice_msg","정상적으로 삭제되었습니다.");
request.setAttribute("notice_url",request.getContextPath()+"/item/adminList.do");
return "/WEB-INF/views/common/alert_view.jsp";
}
}
UserListAction
package kr.item.action;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import kr.controller.Action;
import kr.item.dao.ItemDAO;
import kr.item.vo.ItemVO;
import kr.util.PagingUtil;
public class UserListAction implements Action{
@Override
public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception {
String pageNum = request.getParameter("pageNum");
if(pageNum==null) pageNum ="1";
String keyfield = request.getParameter("keyfield");
String keyword = request.getParameter("keyword");
ItemDAO dao = ItemDAO.getInstance();
//status가 1이면 표시(2) 모두 개수 반환
int count = dao.getItemCount(keyfield,keyword,1);
//페이지 처리
PagingUtil page = new PagingUtil(keyfield,keyword,Integer.parseInt(pageNum),count,20,10,"itemList.do");
List<ItemVO> list = null;
if(count > 0) {
list = dao.getListItem(page.getStartRow(), page.getEndRow(), keyfield, keyword, 1);
}
request.setAttribute("count",count);
request.setAttribute("list",list);
request.setAttribute("page",page.getPage());
return "/WEB-INF/views/item/user_list.jsp";
}
}
user_list.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>
<head>
<meta charset="UTF-8">
<title>상품리스트</title>
<link rel="stylesheet" href="${pageContext.request.contextPath}/css/style.css" type="text/css">
<script type="text/javascript">
window.onload = function(){
const myForm = document.getElementById('search_form');
//이벤트 연결
myForm.onsubmit = function(){
const keyword = document.getElementById('keyword');
if(keyword.value.trim()==''){
alert('검색어를 입력하세요');
keyword.value='';
keyword.focus();
return false;
}
};
}
</script>
</head>
<body>
<div class="page-main">
<jsp:include page="/WEB-INF/views/common/header.jsp"/>
<div class="content-main">
<h2>상품리스트</h2>
<form id="search_form" action="itemList.do" method="get">
<ul class="search">
<li>
<select name="keyfield">
<%-- c:if와 selected를 쓰는건 검색을 계속 유지 시키기 위해서 --%>
<option value="1" <c:if test="${param.keyfield ==1}">selected</c:if>>제목</option>
<option value="2" <c:if test="${param.keyfield ==2}">selected</c:if>>상품명</option>
</select>
</li>
<li>
<input type="search" size="16" name="keyword" id="keyword" value="${param.keyword}">
</li>
<li>
<input type="submit" value="검색">
</li>
</ul>
</form>
<div class="list-space align-right">
<input type="button" value="목록" onclick="location.href='itemList.do'">
<input type="button" value="홈으로" onclick="location.href='${pageContext.request.contextPath}/main/main.do'">
</div>
<c:if test="${count==0}">
<div class="result-display">
표시할 상품이 없습니다.
</div>
</c:if>
<c:if test="${count>0}">
<div class="item-space">
<c:forEach var="item" items="${list}">
<div class="horizontal-area">
<a href="detail.do?item_num=${item.item_num}">
<img src="${pageContext.request.contextPath}/upload/${item.photo1}">
<span>
${item.name}<br>
<b><fmt:formatNumber value="${item.price}"/>원</b>
</span>
</a>
</div>
</c:forEach>
<div class="align-center float-clear">${page}</div>
</div>
</c:if>
</div>
</div>
</body>
</html>
common/header.jsp 내용추가
<li>
<a href="${pageContext.request.contextPath}/item/itemList.do">상품리스트</a>
</li>
