반응형
# 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 |
