SPRING 조회 기능 순서 흐름
1. BoardDAO.java : 인터페이스
public BoardVO read(Integer bno) throws Exception;
2. mapper
<select id="read" resultType="org.zerock.domain.BoardVO">
SELECT
bno, title, content, writer, regdate, viewcnt
FROM
tbl_board
WHERE bno = #{bno}
</select>
3. BoardDAOImpl.java
@Override
public BoardVO read(Integer bno) throws Exception {
return session.selectOne(namespace + ".read", bno);
}
4. BoardService.java : 인터페이스
public BoardVO read(Integer bno) throws Exception;
5. BoardServiceImpl.java
@Override
public BoardVO read(Integer bno) throws Exception {
return dao.read(bno);
}
6. BoardController.java
@RequestMapping(value = "/read", method = RequestMethod.GET)
public void read(@RequestParam("bno") int bno, Model model) throws Exception {
model.addAttribute(service.read(bno));
}
7. read.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@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 box-primary">
<div class="box-header">
<h3 class="box-title">READ BOARD</h3>
</div>
<!-- /.box-header -->
<form role="form" method="post">
<input type='hidden' name='bno' value="${boardVO.bno}">
</form>
<div class="box-body">
<div class="form-group">
<label for="exampleInputEmail1">Title</label> <input type="text"
name='title' class="form-control" value="${boardVO.title}"
readonly="readonly">
</div>
<div class="form-group">
<label for="exampleInputPassword1">Content</label>
<textarea class="form-control" name="content" rows="3"
readonly="readonly">${boardVO.content}</textarea>
</div>
<div class="form-group">
<label for="exampleInputEmail1">Writer</label> <input type="text"
name="writer" class="form-control" value="${boardVO.writer}"
readonly="readonly">
</div>
</div>
<!-- /.box-body -->
<div class="box-footer">
<button type="submit" class="btn btn-warning">Modify</button>
<button type="submit" class="btn btn-danger">REMOVE</button>
<button type="submit" class="btn btn-primary">LIST ALL</button>
</div>
<script>
$(document).ready(function() {
var formObj = $("form[role='form']");
console.log(formObj);
$(".btn-warning").on("click", function() {
formObj.attr("action", "/board/modify");
formObj.attr("method", "get");
formObj.submit();
});
$(".btn-danger").on("click", function() {
formObj.attr("action", "/board/remove");
formObj.submit();
});
$(".btn-primary").on("click", function() {
self.location = "/board/listAll";
});
});
</script>
</div>
<!-- /.box -->
</div>
<!--/.col (left) -->
</div>
<!-- /.row -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<%@include file="../include/footer.jsp"%>