[JSP] Day48 - Set VO 구조

📄 JSP

[JSP] Day48 - Set VO 구조

harveydent 2023. 7. 17. 19:41

728x90

Set VO 구조

Set VO 구조는 MODEL 에서 1:N 구조를 구현할 때 사용할 수 있는 구조입니다. 주로 커뮤니티 속성을 가지는 경우에 자주 사용합니다.

Set VO 구조 적용 예시

1	N
게시글	댓글
댓글	대댓글
상품	후기
공지	답변

실습

BoardVO / BoardSetVO

package model;

import java.util.Date;

public class BoardVO {
	
	private int bid;
	private String mid;
	private String content;
	private int favCnt;
	private int replyCnt;
	private Date date;
	
	public int getBid() {
		return bid;
	}
	
	public void setBid(int bid) {
		this.bid = bid;
	}
	
	public String getMid() {
		return mid;
	}
	
	public void setMid(String mid) {
		this.mid = mid;
	}
	
	public String getContent() {
		return content;
	}
	
	public void setContent(String content) {
		this.content = content;
	}
	
	public int getFavCnt() {
		return favCnt;
	}
	
	public void setFavCnt(int favCnt) {
		this.favCnt = favCnt;
	}
	
	public int getReplyCnt() {
		return replyCnt;
	}
	
	public void setReplyCnt(int replyCnt) {
		this.replyCnt = replyCnt;
	}
	
	public Date getDate() {
		return date;
	}
	
	public void setDate(Date date) {
		this.date = date;
	}

	@Override
	public String toString() {
		return "BoardVO [bid=" + bid + ", mid=" + mid + ", content=" + content + ", favCnt=" + favCnt + ", replyCnt="
				+ replyCnt + ", date=" + date + "]";
	}
}

BoardVO.java

package model;

import java.util.ArrayList;

public class BoardSet {
	
	private BoardVO board; // 1
	private ArrayList<ReplyVO> rdatas; // N

	public BoardVO getBoard() {
		return board;
	}

	public void setBoard(BoardVO board) {
		this.board = board;
	}

	public ArrayList<ReplyVO> getRdatas() {
		return rdatas;
	}

	public void setRdatas(ArrayList<ReplyVO> rdatas) {
		this.rdatas = rdatas;
	}

	@Override
	public String toString() {
		return "BoardSet [board=" + board + ", rdatas=" + rdatas + "]";
	}
}

BoardSet.java

Main jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib tagdir="/WEB-INF/tags" prefix="jun" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>메인 페이지</title>
</head>
<body>

<script type="text/javascript">
	function signup() { 
		// window.open("새창링크", "새창의 이름", "새창의 속성");
		window.open("signup.jsp", "회원가입 창", "width = 450, height = 300");
	}
	function signin() {
		window.open("signin.jsp", "로그인 창", "width = 450, height = 300");		
	}
</script>

<div id="header">
	<h1>SNS 커뮤니티 실습 프로젝트</h1>
</div>

<div id="gnb">
	<ul>
		<li><a href="main.do">메인으로 가기</a></li>
		<jun:login_logout/>
	</ul>
</div>


<div id="content">
	<section>
		<jun:insertBoard/>
	</section>
	<br>
	<section>
		<c:if test="${ bdatas ne null }">
			<c:forEach var="v" items="${ bdatas }">
				<c:set var="b" value="${ v.board }"/> <!-- 새로운 변수를 생성하는 것 보단 -->
				<c:set var="reply" value="${ v.rdatas }"/> <!-- 멤버변수 접근 연산자를 줄이기 위해 set 사용 -->
				${ b.bid } ${ b.content } <br>
				<c:forEach var="r" items="${ reply }">
					${ r.rid } ${ r.rContent } <br>
				</c:forEach>
				<hr>
			</c:forEach>
		</c:if>
		<!-- 페이지네이션 -->
		<a href="main.do?count=${ count+2 }">[더보기]</a>
	</section>
</div>

<div id="footer">
	<h3>&copy; NAVER corp. | 회사소개 | 이용약관 | 개인정보처리방침 | 고객센터</h3>
</div>

</body>
</html>

main.jsp

MainAction Controller

package controller;

import java.io.IOException;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import model.BoardDAO;
import model.BoardSet;
import model.BoardSetDAO;
import model.BoardVO;

public class MainAction implements Action {

	@Override
	public ActionForward execute(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		ActionForward forward = new ActionForward();
		
		forward.setPath("main.jsp");
		forward.setRedirect(false);
		
		String count = request.getParameter("count");
		
		// TryCatch 처리하면 제일 좋음
		// null값 체크할 때 null을 조건문 첫 번째에 넣음
		if (count == null || count.isEmpty() || count.isBlank() || count.equals("")) {
			count = "2";
		}
		int cnt = Integer.parseInt(count);
		
		BoardSetDAO bsDAO = new BoardSetDAO();
		
		ArrayList<BoardSet> bdatas = bsDAO.selectAll(null, cnt);
		request.setAttribute("bdatas", bdatas);
		request.setAttribute("count", cnt);
		
		return forward;
	}
}

MainAction.java

BoardSet DAO

package model;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

public class BoardSetDAO {
	
	private Connection conn;
	private PreparedStatement pstmt;
	private ResultSet rs;
	
	static final private String SQL_SELECTALL = "SELECT * FROM BOARD ORDER BY BID DESC LIMIT 0,?";
	static final private String SQL_SELECTALL_REPLY = "SELECT * FROM REPLY WHERE BID = ?";
	
	public ArrayList<BoardSet> selectAll(BoardVO bVO, int count) {
		conn = JDBCUtil.connect();

		ArrayList<BoardSet> datas = new ArrayList<BoardSet>();

		try {
			pstmt = conn.prepareStatement(SQL_SELECTALL);
			pstmt.setInt(1, count);
			rs = pstmt.executeQuery();

			while (rs.next()) {
				System.out.println("dao 보드 while");
				BoardSet bs = new BoardSet();
				BoardVO data = new BoardVO();
				data.setBid(rs.getInt("BID"));
				data.setMid(rs.getString("MID"));
				data.setContent(rs.getString("CONTENT"));
				data.setFavCnt(rs.getInt("FAVCNT"));
				data.setReplyCnt(rs.getInt("REPLYCNT"));
				data.setDate(rs.getDate("DATE"));
				bs.setBoard(data);
				
				//////
				pstmt = conn.prepareStatement(SQL_SELECTALL_REPLY);
				pstmt.setInt(1, data.getBid());
				ResultSet rs2 = pstmt.executeQuery();
				
				ArrayList<ReplyVO> rdatas = new ArrayList<ReplyVO>();
				
				while (rs2.next()) {
					ReplyVO rVO = new ReplyVO();
					rVO.setRid(rs2.getInt("RID"));
					rVO.setBid(rs2.getInt("BID"));
					rVO.setMid(rs2.getString("MID"));
					rVO.setDate(rs2.getDate("DATE"));
					rVO.setrContent(rs2.getString("CONTENT"));
					rdatas.add(rVO);
				}
				//////
				
				bs.setRdatas(rdatas);
				
				datas.add(bs);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}

		JDBCUtil.disconnect(rs, pstmt, conn);

		return datas;
	}
}

BoardSetDAO.java

GitHub

https://github.com/Qkrwnsgus0522/JSP

GitHub - Qkrwnsgus0522/JSP

Contribute to Qkrwnsgus0522/JSP development by creating an account on GitHub.

github.com

728x90