SPRING 리스트 기능 순서 흐름
1. BoardDAO.java : 인터페이스
public List<BoardVO> listAll() throws Exception;
2. mapper
<select id="listAll" resultType="org.zerock.domain.BoardVO">
<![CDATA[
SELECT
bno, title, content, writer, regdate, viewcnt
FROM
tbl_board
WHERE bno > 0
ORDER BY bno desc, regdate desc
]]>
</select>
3. BoardDAOImpl.java
@Override
public List<BoardVO> listAll() throws Exception {
return session.selectList(namespace + ".listAll");
}
4. BoardService.java : 인터페이스
public List<BoardVO> listAll() throws Exception;\
5. BoardServiceImpl.java
@Override
public List<BoardVO> listAll() throws Exception {
return dao.listAll();
}
6. BoardController.java
@RequestMapping(value = "/listAll", method = RequestMethod.GET)
public void listAll(Model model) throws Exception {
logger.info("show all list......................");
model.addAttribute("list", service.listAll());
}
7. listAll.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 prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<%@ page session="false"%>
<%@include file="../include/header.jsp"%>
<!-- Main content -->
<section class="content">
<div class="row">
<!-- left column -->
<div class="col-md-12">
<!-- general form elements -->
<div class="box">
<div class="box-header with-border">
<h3 class="box-title">LIST ALL PAGE</h3>
</div>
<div class="box-body">
<table class="table table-bordered">
<tr>
<th style="width: 10px">BNO</th>
<th>TITLE</th>
<th>WRITER</th>
<th>REGDATE</th>
<th style="width: 40px">VIEWCNT</th>
</tr>
<c:forEach items="${list}" var="boardVO">
<tr>
<td>${boardVO.bno}</td>
<td><a href='/board/read?bno=${boardVO.bno}'>${boardVO.title}</a></td>
<td>${boardVO.writer}</td>
<td><fmt:formatDate pattern="yyyy-MM-dd HH:mm"
value="${boardVO.regdate}" /></td>
<td><span class="badge bg-red">${boardVO.viewcnt }</span></td>
</tr>
</c:forEach>
</table>
</div>
<!-- /.box-body -->
<div class="box-footer">Footer</div>
<!-- /.box-footer-->
</div>
</div>
<!--/.col (left) -->
</div>
<!-- /.row -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<script>
var result = '${msg}';
if(result == 'SUCCESS'){
alert("처리가 완료되었습니다.");
}
</script>
<%@include file="../include/footer.jsp"%>