DeleteProc.jsp
<%@page import="kh.backend.dto.MessagesDTO"%>
<%@page import="java.util.List"%>
<%@page import="kh.backend.dao.MessagesDAO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script src="https://code.jquery.com/jquery-3.5.0.js"></script>
</head>
<body>
<table border=1 align=center>
<tr>
<td>글번호</td>
<td>작성자</td>
<td>글내용</td>
<td>작성일</td>
</tr>
<%
MessagesDAO dao = new MessagesDAO();
List<MessagesDTO> list = dao.selectAll();
for (MessagesDTO dto : list) {
%>
<tr>
<td><%=dto.getSeq()%>
<td><%=dto.getName()%>
<td><%=dto.getMsg()%>
<td><%=dto.getWrite_date()%>
</tr>
<%
}
%>
<tr>
<td colspan=4 align=center>
<button id="back">돌아가기</button>
<form>
<input type=text name=input_seq placeholder="Input target number">
<input type=submit value="삭제">
</form>
</tr>
</table>
<%
String seq = request.getParameter("input_seq");
if (seq != null) {
int del_result = dao.delete(seq);
if (del_result > 0) {
%>
<script>
alert('Delete Complete');
location.href = 'index.jsp';
</script>
<%
}
}
%>
<script>
document.getElementById('back').onclick = function() {
location.href = 'index.jsp';
}
</script>
</body>
</html>
index.jsp - 삭제버튼 추가
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script src="https://code.jquery.com/jquery-3.5.0.js"></script>
</head>
<body>
<fieldset>
<legend>Index</legend>
<button id="toInput">toInput</button>
<button id="toOutput">toOutput</button>
<button id="toDelete">toDelete</button>
</fieldset>
<script>
$("#toInput").on("click",function(){
location.href = "input.jsp";
})
$("#toOutput").on("click",function(){
location.href = "OutputProc.jsp";
})
$("#toDelete").on("click",function(){
location.href = "DeleteProc.jsp";
})
</script>
</body>
</html>강사님 코드
delete.jsp
deleteProc.jsp 두개 생성
버튼 태그의 기본타입은 submit
<input type=button> 을 쓰거나
버튼 태그의 타입을 버튼이라고 명시해야 함
<button id="back" type=button>돌아가기</button>index.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script src="https://code.jquery.com/jquery-3.5.0.js"></script>
</head>
<body>
<fieldset>
<legend>Index</legend>
<button id="toInput">Input</button>
<button id="toOutput">Output</button>
<button id="toDelete">Delete</button>
<button id="toUpdate">Update</button>
</fieldset>
<script>
$("#toInput").on("click",function(){
location.href = "input.jsp";
})
$("#toOutput").on("click",function(){
location.href = "OutputProc.jsp";
})
$("#toDelete").on("click",function(){
location.href = "delete.jsp";
})
$("#toUpdate").on("click",function(){
location.href = "UpdateProc.jsp";
})
</script>
</body>
</html>delete.jsp
<%@page import="kh.backend.dto.MessagesDTO"%>
<%@page import="java.util.List"%>
<%@page import="kh.backend.dao.MessagesDAO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script src="https://code.jquery.com/jquery-3.5.0.js"></script>
</head>
<body>
<form action="DeleteProc.jsp" method="get">
<table border=1 align=center>
<tr>
<td>글번호</td>
<td>작성자</td>
<td>글내용</td>
<td>작성일</td>
</tr>
<%
MessagesDAO dao = new MessagesDAO();
List<MessagesDTO> list = dao.selectAll();
for (MessagesDTO dto : list) {
%>
<tr>
<td><%=dto.getSeq()%>
<td><%=dto.getName()%>
<td><%=dto.getMsg()%>
<td><%=dto.getWrite_date()%>
</tr>
<%
}
%>
<tr>
<td colspan=4 align=center><input type=text name=del_num
placeholder="Input target number"> <input type=submit
value="삭제">
<button id="back" type=button>돌아가기</button>
</tr>
</table>
</form>
<script>
$("#back").on("click")
document.getElementById('back').onclick = function() {
location.href = 'index.jsp';
}
</script>
</body>
</html>deleteProc.jsp
<%@page import="kh.backend.dto.MessagesDTO"%>
<%@page import="java.util.List"%>
<%@page import="kh.backend.dao.MessagesDAO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script src="https://code.jquery.com/jquery-3.5.0.js"></script>
</head>
<body>
<%
String seq = request.getParameter("del_num");
MessagesDAO dao = new MessagesDAO();
int del_result = dao.delete(seq);
%>
<script>
location.href = 'delete.jsp';
</script>
</body>
</html>
'디지털 컨버전스 > JSP' 카테고리의 다른 글
| [JSP] MVC 2 구성 (0) | 2020.04.28 |
|---|---|
| [JSP] MVC 모델 (0) | 2020.04.28 |
| [JSP] output 기능 (0) | 2020.04.27 |
| [JSP] input 기능 (0) | 2020.04.27 |
| [JSP] JSP 시작 (0) | 2020.04.27 |