반응형

# MVC02_05~06

# MVC02_05 회원리스트 및 삭제 구현

## 회원가입 버튼 생성

  • 기존 memberList.jsp에 회원가입 버튼 추가.
  • 버튼 클릭 시 회원가입 페이지인 memberRegister.html로 이동될 수 있도록 작업.
<tr>
<td colspan="7" align="right"><input type="button" value="회원가입" class="btn" onclick="location.href='memberRegister.html'"/></td>
</tr>

## 회원삭제 기능 추가

  • memberList.jsp 에 삭제 버튼 추가. 및 삭제 버튼과 연결된 deleteFn 함수 추가.
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="kr.bit.model.*" %>
<%@ page import="java.util.*" %>
<%
	//1. 클라이언트 요청 받기 (memberList.do)
	MemberDAO dao = new MemberDAO();
		
	// 2. 회원 전체 리스트 가져오기(Model 연동)
	ArrayList<MemberVO> list = dao.memberList();
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<meta name='viewport' content='width=device-width, initial-scale=1'>
<link rel='stylesheet' href='https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css'>
<script src='https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js'></script>
<script src='https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js'></script>
<script>
	function deleteFn(num) {
		location.href="memberDelete.jsp?num=" + num;
	}
</script>
</head>
<body>
<table class="table table-bordered">
	<tr>
		<td>번호</td>
		<td>아이디</td>
		<td>비밀번호</td>
		<td>이름</td>
		<td>나이</td>
		<td>이메일</td>
		<td>전화번호</td>
		<td>삭제</td>
	</tr>
	<%
		for (MemberVO vo : list) {
	%>		
		<tr>
			<td><%=vo.getNum() %></td>
			<td><%=vo.getId() %></td>
			<td><%=vo.getPass() %></td>
			<td><%=vo.getName() %></td>
			<td><%=vo.getAge() %></td>
			<td><%=vo.getEmail() %></td>
			<td><%=vo.getPhone() %></td>
			<td><input type="button" value="삭제" class="btn btn-warning" onclick="deleteFn(<%=vo.getNum() %>)" /></td>
		</tr>
	<%	
		}
	%>
	<tr>
		<td colspan="8" align="right"><input type="button" value="회원가입" class="btn btn-primary" onclick="location.href='memberRegister.html'"/></td>
	</tr>
</table>
</body>
</html>
  • MVC02 > WebContext > member 우 클릭 > New > JSP File > memberDelete.jsp 생성
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="kr.bit.model.*" %>
<%
	int num = Integer.parseInt(request.getParameter("num"));
	
	MemberDAO dao = new MemberDAO();
	
	int cnt = dao.memberDelete(num);
	
	if (cnt > 0) {
		response.sendRedirect("memberList.jsp");
	} else {
		throw new ServletException("not delete");
	}
%>

 

 

# MVC02_06 회원상세보기 및 수정하기 구현

## 회원 상세보기 기능 추가

  • memberList.jsp 에서 회원의 번호에 상세보기용 a태그 추가.
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="kr.bit.model.*" %>
<%@ page import="java.util.*" %>
<%
	//1. 클라이언트 요청 받기 (memberList.do)
	MemberDAO dao = new MemberDAO();
		
	// 2. 회원 전체 리스트 가져오기(Model 연동)
	ArrayList<MemberVO> list = dao.memberList();
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<meta name='viewport' content='width=device-width, initial-scale=1'>
<link rel='stylesheet' href='https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css'>
<script src='https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js'></script>
<script src='https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js'></script>
<script>
	function deleteFn(num) {
		location.href="memberDelete.jsp?num=" + num;
	}
</script>
</head>
<body>
<table class="table table-bordered">
	<tr>
		<td>번호</td>
		<td>아이디</td>
		<td>비밀번호</td>
		<td>이름</td>
		<td>나이</td>
		<td>이메일</td>
		<td>전화번호</td>
		<td>삭제</td>
	</tr>
	<%
		for (MemberVO vo : list) {
	%>		
		<tr>
			<td><%=vo.getNum() %></td>
			<td><a href="memberContent.jsp?num=<%=vo.getNum()%>"><%=vo.getId() %></a></td>
			<td><%=vo.getPass() %></td>
			<td><%=vo.getName() %></td>
			<td><%=vo.getAge() %></td>
			<td><%=vo.getEmail() %></td>
			<td><%=vo.getPhone() %></td>
			<td><input type="button" value="삭제" class="btn btn-warning" onclick="deleteFn(<%=vo.getNum() %>)" /></td>
		</tr>
	<%	
		}
	%>
	<tr>
		<td colspan="8" align="right"><input type="button" value="회원가입" class="btn btn-primary" onclick="location.href='memberRegister.html'"/></td>
	</tr>
</table>
</body>
</html>
  • MVC02 > WebContext > member 우 클릭 > New > JSP File > memberContent.jsp 생성
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="kr.bit.model.*" %>
<%
	int num = Integer.parseInt(request.getParameter("num"));

	MemberDAO dao = new MemberDAO();
	
	MemberVO vo = dao.memberContent(num);
%>    
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<meta name='viewport' content='width=device-width, initial-scale=1'>
<link rel='stylesheet' href='https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css'>
<script src='https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js'></script>
<script src='https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js'></script>
</head>
<body>
<table border="1" class="table table-bordered">
<% if (vo != null) { %>
<tr>
<td colspan="2"><%=vo.getName() %> 회원의 상세보기</td>
</tr>
<tr>
<td>번호</td>
<td><%=vo.getNum() %></td>
</tr>
<tr>
<td>아이디</td>
<td><%=vo.getId() %></td>
</tr>
<tr>
<td>비밀번호</td>
<td><%=vo.getPass() %></td>
</tr>
<tr>
<td>이름</td>
<td><%=vo.getName() %></td>
</tr>
<tr>
<td>나이</td>
<td><input type="text" name="age" value="<%=vo.getAge() %>" /></td>
</tr>
<tr>
<td>이메일</td>
<td><input type="text" name="email" value="<%=vo.getEmail() %>" /></td>
</tr>
<tr>
<td>전화번호</td>
<td><input type="text" name="phone" value="<%=vo.getPhone() %>" /></td>
</tr>
<% } else { %>
<tr>
<td>일치하는 회원이 없습니다.</td>
</tr>
<% } %>
<tr>
<td colspan="2" align="center">
<input type="submit" value="수정하기" class="btn btn-primary" />
<input type="reset" value="취소" class="btn btn-warning" />
<input type="button" value="리스트" onclick="location.href='memberList.jsp'" class="btn" />
</td>
</tr>
</table>
</body>
</html>

## 회원 수정하기 기능 추가

  • memberList.jsp 에서 수정하기 기능을 위한 form 태그 추가 등 진행
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="kr.bit.model.*" %>
<%
	int num = Integer.parseInt(request.getParameter("num"));

	MemberDAO dao = new MemberDAO();
	
	MemberVO vo = dao.memberContent(num);
%>    
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<meta name='viewport' content='width=device-width, initial-scale=1'>
<link rel='stylesheet' href='https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css'>
<script src='https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js'></script>
<script src='https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js'></script>
</head>
<body>
<form action="memberUpdate.jsp" method="post">
<input type="hidden" name="num" value="<%=vo.getNum() %>"/>
	<table border="1" class="table table-bordered">
	<% if (vo != null) { %>
		<tr>
			<td colspan="2"><%=vo.getName() %> 회원의 상세보기</td>
		</tr>
		<tr>
			<td>번호</td>
			<td><%=vo.getNum() %></td>
		</tr>
		<tr>
			<td>아이디</td>
			<td><%=vo.getId() %></td>
		</tr>
		<tr>
			<td>비밀번호</td>
			<td><%=vo.getPass() %></td>
		</tr>
		<tr>
			<td>이름</td>
			<td><%=vo.getName() %></td>
		</tr>
		<tr>
			<td>나이</td>
			<td><input type="text" name="age" value="<%=vo.getAge() %>" /></td>
		</tr>
		<tr>
			<td>이메일</td>
			<td><input type="text" name="email" value="<%=vo.getEmail() %>" /></td>
		</tr>
		<tr>
			<td>전화번호</td>
			<td><input type="text" name="phone" value="<%=vo.getPhone() %>" /></td>
		</tr>
	<% } else { %>
		<tr>
			<td>일치하는 회원이 없습니다.</td>
		</tr>
	<% } %>
		<tr>
			<td colspan="2" align="center">
				<input type="submit" value="수정하기" class="btn btn-primary" />
				<input type="reset" value="취소" class="btn btn-warning" />
				<input type="button" value="리스트" onclick="location.href='memberList.jsp'" class="btn" />
			</td>
		</tr>
	</table>
</form>
</body>
</html>
  • MVC02 > WebContext > member 우 클릭 > New > JSP File > memberUpdate.jsp 생성
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="kr.bit.model.*" %>
<%
	int num = Integer.parseInt(request.getParameter("num"));
	int age = Integer.parseInt(request.getParameter("age"));
	String email = request.getParameter("email");
	String phone = request.getParameter("phone");

	MemberVO vo = new MemberVO();
	vo.setNum(num);
	vo.setAge(age);
	vo.setEmail(email);
	vo.setPhone(phone);
	
	MemberDAO dao = new MemberDAO();
	
	int cnt = dao.memberUpdate(vo);
	
	if (cnt > 0) {
		response.sendRedirect("memberList.jsp");
	} else {
		throw new ServletException("not update");
	}
%>

 

반응형
저작자표시

'인프런 강의 학습 > MVC 프레임워크_나프1탄' 카테고리의 다른 글

인프런 MVC 프레임워크는 내손에 33일차 : MVC03_01 ~ 03 MVC03(Model2 방식)개요, 포워드(forward) 기법, 요청의뢰와 객체 바인딩  (0) 2021.06.10
인프런 MVC 프레임워크는 내손에 32일차 : MVC02_07 MVC02정리 및 Model 2방식  (0) 2021.06.09
인프런 MVC 프레임워크는 내손에 30일차 : MVC02_04 Controller용 JSP와 View용 JSP  (0) 2021.06.08
인프런 MVC 프레임워크는 내손에 29일차 : MVC02_03 JSP를 Servlet으로 변경해보기  (0) 2021.06.08
인프런 MVC 프레임워크는 내손에 28일차 : MVC02_02 JSP는 Servlet이다.  (0) 2021.06.07

+ Recent posts

티스토리툴바