자유게시판-생성

List Page

<title>index</title>
<li><a href="fboardList.do">자유게시판</a></li>

---

<BController>

case    "fboardList.do": //list 페이지
		bservice=new BServiceSelectAll();
		bservice.execute(request,response);
		url="fboardList.jsp";
		break;

✔<BserviceSelectAll>
ArrayList<BoardBean> list=bdao.BoardSelectAll();
if(list!=null) {
		request.setAttribute("list",list); //태워서 보낼 것
		request.setAttribute("result","success"); //fboardList.jsp에서 list값이 잘 가져오는지 확인하기 위해서
	}else request.setAttribute("result","fail");
    

✔<BoardDao>
public ArrayList<BoardBean> BoardSelectAll() {
      list=new ArrayList<>();
      try {
          conn=getConn();
          query="select * from freeboard order by bgroup desc";
			
		pstmt=conn.prepareStatement(query);
		rs=pstmt.executeQuery();
		while(rs.next()) {
			bno=rs.getInt("bno");
			bstep=rs.getInt("bstep");
			bhit=rs.getInt("bhit");
			bgroup=rs.getInt("bgroup");
			bindent=rs.getInt("bindent");
			id=rs.getString("id");
			btitle=rs.getString("btitle");
			bcontent=rs.getString("bcontent");
			bfile=rs.getString("bfile");
			bdate=rs.getTimestamp("bdate");
			list.add(new BoardBean(bno, id, btitle, bcontent, bdate, bstep, bhit,
					bgroup, bindent, bfile));	
		}~~~~~(try catch문 끝)
        
        return list
        

---

	<fboardList.jsp>
	<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
	<%@taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
    
    <table>
     <tr>
		  <th>번호</th>
		  <th>제목</th>
		  <th>작성자</th>
		  <th>날짜</th>
		  <th>조회수</th>
		</tr>
		<c:if test="${result == 'success' }"> 
        <!--BController에서 잘 list를 잘 받아 왔다면  -->
		<c:forEach items="${list}" var="bBean">
		<tr>
		  <td>${bBean.bno}</td>
		  <td>
          <!-- fboardView (즉 view페이지로 넘어갈 때), bno를 같이 넘겨줘 -->
		  	<a href="fboardView.do?bno=${bBean.bno}">
		  		${bBean.btitle}<c:if test="${bBean.bfile!=null }"> <span class="material-symbols-outlined"><!--첨부파일이 있으면 기호로 표시해줘  -->
                download
				</span></c:if>
		  	</a>
		  </td>
		  <td>${bBean.id}</td>
		  <td>
		  <fmt:formatDate value="${bBean.bdate}" pattern="yyyy-MM-dd"/>
          <!--Timestamp형 자료를 뒤에 시간/분/초를 나타내지 말고 pattern의 형식대로 나타내줘  -->
		  </td>
		  <td>${bBean.bhit}</td>
		</tr>
		</c:forEach>
		</c:if>
		<c:if test="${result == 'fail' }">
        <!--BController에서 list안에 값이 없다면  -->
			<tr>
			  <td colspan="5">데이터가 없습니다.</td>
			</tr>
		</c:if>				
    </table>
    

					        <fboardList.jsp>