개발/Java
DAO를 JSP로 구현
dev-bleck
2022. 11. 11. 09:27
1. Home.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>
</head>
<body>
<h1>::: HOME :::</h1>
<form action="user_list.jsp" method="POST">
<p><input type="submit" value="LIST"/>
</form>
<form action="user_selectone.jsp" method="POST">
<p><input type="submit" value="SELECT"/>
</form>
<form action="user_insert.jsp" method="POST">
<p><input type="submit" value="INSERT"/>
</form>
<form action="user_update.jsp" method="POST">
<p><input type="submit" value="UPDATE"/>
</form>
<form action="user_delete.jsp" method="POST">
<p><input type="submit" value="DELETE"/>
</form>
</body>
</html>
2. user_list.jsp (SELECT ALL)
<%@page import="org.cosmtudy.myapp.model.UserDTO"%>
<%@page import="java.util.List"%>
<%@page import="org.cosmtudy.myapp.model.UserDAO"%>
<%@ 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>
</head>
<body>
<!-- SELECT ALL -->
<h1>::: LIST :::</h1>
<%
UserDAO dao = new UserDAO();
List<UserDTO> list = dao.selectAll();
for(UserDTO user : list) {
out.print("<p>" + user + "</p>");
}
%>
</body>
</html>
3. user_selectone.jsp / user_selectone_proc.jsp (SELECT ONE)
<%@ 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>
</head>
<body>
<!-- SELECT ONE -->
<h1>::: SELECT :::</h1>
<form action="user_selectone_proc.jsp" method="POST">
번호<input type="text" name="no"/><br>
<input type="submit" value="SAVE"/>
</form>
</body>
</html><%@page import="java.util.List"%>
<%@page import="org.cosmtudy.myapp.model.UserDTO"%>
<%@page import="org.cosmtudy.myapp.model.UserDAO"%>
<%@ 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>
</head>
<body>
<!-- SELECT ONE RETURN -->
<%
String no = request.getParameter("no");
UserDAO dao = new UserDAO();
out.println(dao.selectOne(new UserDTO(Integer.parseInt(no), "", "", 0)));
%>
</body>
</html>
4. user_insert.jsp / user_insert_proc.jsp (INSERT)
<%@ 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>
</head>
<body>
<!-- INSERT -->
<h1>::: INSERT :::</h1>
<form action="user_insert_proc.jsp" method="POST">
아이디<input type="text" name="id"/><br>
성명<input type="text" name="name"/><br>
나이<input type="text" name="age"/><br>
<input type="submit" value="SAVE"/>
</form>
</body>
</html><%@page import="org.cosmtudy.myapp.model.UserDTO"%>
<%@page import="org.cosmtudy.myapp.model.UserDAO"%>
<%@ 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>
</head>
<body>
<!-- INSERT RETURN -->
<%
String id = request.getParameter("id");
String name = request.getParameter("name");
String age = request.getParameter("age");
UserDAO dao = new UserDAO();
dao.insert(new UserDTO(0, id, name, Integer.parseInt(age)));
response.sendRedirect("user_list.jsp");
%>
</body>
</html>
5. user_update.jsp / user_update_proc.jsp (UPDATE)
<%@ 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>
</head>
<body>
<!-- UPDATE -->
<h1>::: UPDATE :::</h1>
<form action="user_update_proc.jsp" method="POST">
번호<input type="text" name="no"/><br>
아이디<input type="text" name="id"/><br>
성명<input type="text" name="name"/><br>
나이<input type="text" name="age"/><br>
<input type="submit" value="SAVE"/>
</form>
</body>
</html><%@page import="org.cosmtudy.myapp.model.UserDTO"%>
<%@page import="org.cosmtudy.myapp.model.UserDAO"%>
<%@ 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>
</head>
<body>
<!-- UPDATE RETURN -->
<%
String no = request.getParameter("no");
String id = request.getParameter("id");
String name = request.getParameter("name");
String age = request.getParameter("age");
UserDAO dao = new UserDAO();
dao.update(new UserDTO(Integer.parseInt(no), id, name, Integer.parseInt(age)));
response.sendRedirect("user_list.jsp");
%>
</body>
</html>
6. user_delete.jsp / user_delete_proc.jsp (DELETE)
<%@ 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>
</head>
<body>
<!-- DELETE -->
<h1>::: DELETE :::</h1>
<form action="user_delete_proc.jsp" method="POST">
번호<input type="text" name="no"/><br>
<input type="submit" value="SAVE"/>
</form>
</body>
</html><%@page import="org.cosmtudy.myapp.model.UserDTO"%>
<%@page import="org.cosmtudy.myapp.model.UserDAO"%>
<%@ 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>
</head>
<body>
<!-- DELETE RETURN -->
<%
String no = request.getParameter("no");
UserDAO dao = new UserDAO();
dao.delete(new UserDTO(Integer.parseInt(no), "", "", 0));
response.sendRedirect("user_list.jsp");
%>
</body>
</html>
728x90