과제 : post 한개 보기_SG

Mapper(boardSql.xml)

<!-- 게시물 읽기 -->
<select id="selectBoardReader" resultType="formTestVo">
    SELECT
        NO
        ,TITLE
        ,CONTENT
        ,REG_ID AS regId
        ,REG_DT AS regDt
        ,UPD_ID AS updId
        ,UPD_DT AS updDt
    FROM BOARD
    WHERE NO = #{no}
</select>

DAO(BoardDao.java)

@Repository("BoardDao")
public class BoardDao {
    @Autowired
    SqlSession sqlSession;
    /**
     * 게시글 읽기
     * @param vo
     * @return
     */
    public FormTestVo selectBoardReader(FormTestVo vo) {
        //게시글 읽는건 단건
        return sqlSession.selectOne("board.selectBoardReader",vo);
    }
}

Service(BoardServiceImpl.java)

@Service("BoardService")
public class BoardServiceImpl implements BoardService {
    @Autowired
    BoardDao dao;
    /**
     * 게시글 읽기
     */
    @Override
    public FormTestVo selectBoardReader(FormTestVo vo) {
        // TODO Auto-generated method stub
        return dao.selectBoardReader(vo);
    }
}

Controller(BoardController.java)

@Controller
@RequestMapping(value="board")
public class BoardController {
    @Autowired
    BoardService service;
    /**
     *
     * @param model
     * @return
     */
    @RequestMapping(value="")
    String boardList(Model model) {
        //목록 불러오는 서비스 만들기

        model.addAttribute("list", service.selectBoard());
        return "board/list";
}
    /**
 * 게시물 읽어오기
 * @param no
 * @param model
 * @param vo
 * @return
 */
    @RequestMapping(value="/read")
    String read(@RequestParam("no") String no, Model model,FormTestVo vo) {

        System.out.println(no);
        model.addAttribute("list", service.selectBoardReader(vo));

        return "board/read";
}
    }

게시글 제목 클릭(list.jsp)

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>게시판 목록입니다</title>
</head>
<body>
<h1>게시판 입니다.</h1>
<table>
<tr>
<th>번호</th>
<th>제목</th>
<th>글쓴이</th>
</tr>
    <c:forEach items="${list }" var="item">
    <tr>
    <td>${item.no }</td>
    <td><a href="board/read?no=${item.no }">${item.title }</a></td>
    <td>${item.regId }</td>
    </tr>
    </c:forEach>
</table>
<a href="board/write">글쓰기</a>
</body>
</html>

게시글 출력(read.jsp)

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>게시글 읽기</title>
</head>
<body>
<h1>게시물 입니다.</h1>
<table >
<tr>
<th>번호</th>
<th>제목</th>
<th>글쓴이</th>
<th>내용</th>
</tr>
    <tr>
    <td>${list.no }</td>
    <td>${list.title }</td>
    <td>${list.regId }</td>
    <td>${list.content }</td>
    </tr>
</table>
</body>
</html>

결과

iknowahra / cspiEdu

과제 : post 한개 보기_SG #31