심심한 개발자의 취미생활
# Model1 - JSP Controller

•

## 방명록 페이지 개요

•

### Controller - JSP 작성

•

본 글은 victolee님의 포스팅을 보고 따라 학습하며 내용을 정리한 포스팅 입니다.

Model1 - JSP Controller

방명록 페이지 개요

  • 방명록을 작성하는 입력 form 페이지
  • 게시글 리스트 페잊
  • 삭제하기 위해 비밀번호를 입력하는 페이지
CREATE TABLE GUESTBOOK (
    NO INT PRIMARY KEY AUTO_INCREMENT,
    NAME VARCHAR(50),
    PWD VARCHAR(60),
    CONTENT VARCHAR(9999),
    REG_DATE DATETIME
)
  • Dao, Vo 작성 과정 생략

Controller - JSP 작성

  • index.jsp
<%@page import="guestbook_Model1.GuestBookVo" %>
<%@page import="guestbook_Model1.GuestBookDao" %>
<%@page import="java.util.List" %>
<%@page import="java.util.ArrayList" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

<%
List<GuestBookVo> list = new ArrayList<GuestBookVo>();
GuestBookDao dao = new GuestBookDao();

list = dao.getList();
%>
<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>GuestBook</title>
</head>
<body>
    <form action="/guestbook_Model1/add.jsp" method="post">
        <table border='1' width='500'>
            <tr>
                <td>이름</td><td><input type='text' name='name'></td>
                <td>비밀번호</td><td><input type='password' name='pwd'></td>
            </tr>
            <tr>
                <td colspan=4><textarea name='content' cols=60 rows=5></textarea></td>
            </tr>
            <tr>
                <td colspan=4 align=right><input type='submit' value='check'></td>
            </tr>
        </table>
    </form>
    <br>
<%   
	if(list != null){
        for(GuestBookVo vo : list){
%>
            <table width='510' border='1'>
                <tr>
                    <td><%= vo.getNo() %></td>
                    <td><%= vo.getName() %></td>
                    <td><%= vo.getRegDate() %></td>
                    <td><a href="/guestbook_Model1/deleteform.jsp?no=<%= vo.getNo() %>">삭제</a></td>
                </tr>
                <tr>
                    <td><%= vo.getContent() %></td>
                </tr>
            </table>
<%
        }
    }
%>
</body>
</html>
  • add.jsp
<%@ page import="guestbook_Model1.GuestBookVo" %>
<%@ page import="guestbook_Model1.GuestBookDao" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%
    request.setCharacterEncoding("utf-8");

    String name = request.getParameter("name");
    String pwd = request.getParameter("pwd");
    String content = request.getParameter("content");
    
    GuestBookVo vo = new GuestBookVo();
    vo.setName(name);
    vo.setPwd(pwd);
    vo.setContent(content);

    GuestBookDao dao = new GuestBookDao();
    dao.insert(vo);

    response.sendRedirect("/guestbook_Model1");
%>
  • deleteform.jsp
<%@ page import="guestbook_Model1.GuestBookVo" %>
<%@ page import="guestbook_Model1.GuestBookDao" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    
<% String no = request.getParameter("no"); %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Guest Book delete form</title>
</head>
<body>
	<form action="/guestbook_Model1/delete.jsp" method="post">
		<input type='hidden' name='no' value='<%= no %>'>
		<table border='1' width='200'>
			<tr>
				<td> NO </td><td><%= no %></td>
				<td> PWD </td><td><input type='password' name='pwd'></td>
				<td><input type='submit' value='check'></td>
			</tr>
		</table>
	</form>
</body>
</html>
  • delete.jsp
<%@ page import="guestbook_Model1.GuestBookVo" %>
<%@ page import="guestbook_Model1.GuestBookDao" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%
    request.setCharacterEncoding("utf-8");

    String no = request.getParameter("no");
    String pwd = request.getParameter("pwd");
    
    GuestBookVo vo = new GuestBookVo();
    vo.setNo(no);
    vo.setPwd(pwd);
    
    GuestBookDao dao = new GuestBookDao();
    dao.delete(vo);
    
    response.sendRedirect("/guestbook_Model1");
%>