thymeleaf 예약어를 통해 HTML로 데이터 뿌리기
☆ Code
★ BoardMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- 연결할 인터페이스 정보를 namespace에 기술 -->
<mapper namespace="com.koreait.board.mapper.BoardMapper">
<insert id="insert">
INSERT INTO TBL_BOARD(BNO, TITLE, CONTENT, WRITER)
VALUES(NEXTVAL(SEQ_BOARD), #{title}, #{content}, #{writer})
</insert>
<insert id="insertSelectKey">
<selectKey keyProperty="bno" order="BEFORE" resultType="long">
SELECT NEXTVAL(SEQ_BOARD) FROM DUAL
</selectKey>
INSERT INTO TBL_BOARD(BNO, TITLE, CONTENT, WRITER)
VALUES(#{bno}, #{title}, #{content}, #{writer})
</insert>
<select id="getList" resultType="boardVO">
<![CDATA[
SELECT BNO, TITLE, CONTENT, WRITER, REGDATE, UPDATEDATE
FROM TBL_BOARD
WHERE BNO > 0
]]>
</select>
<select id="get" resultType="boardVO">
SELECT BNO, TITLE, CONTENT, WRITER, REGDATE, UPDATEDATE
FROM TBL_BOARD
WHERE BNO = #{bno}
</select>
<update id="update">
UPDATE TBL_BOARD
SET TITLE = #{title}, CONTENT = #{content}, WRITER = #{writer}
WHERE BNO = #{bno}
</update>
</mapper>
★ list.html
<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>Board</title>
<link rel="stylesheet" href="/css/bootstrap.css">
</head>
<body>
<h1 class="text-center" style="margin: 20px auto;">Board List</h1>
<hr>
<div class="col-md-8 text-center" style="margin: 0 auto;">
<table class="table table-striped">
<thead>
<tr>
<td>번호</td>
<td>제목</td>
<td>작성자</td>
<td>작성일</td>
<td>수정일</td>
</tr>
</thead>
<tbody>
<th:block th:each="board:${list}">
<tr th:object="${board}">
<td th:text="*{bno}"></td>
<td th:text="*{title}"></td>
<td th:text="*{writer}"></td>
<td th:text="*{regdate}"></td>
<td th:text="*{updatedate}"></td>
</tr>
</th:block>
</tbody>
</table>
</div>
</body>
</html>'Spring' 카테고리의 다른 글
| Spring 게시판 글 작성, 삭제 로직 (0) | 2024.12.26 |
|---|---|
| Spring 게시판 게시글 불러오기 (0) | 2024.12.25 |
| Spring 게시판 게시글쓰기 (0) | 2024.12.21 |
| Spring DAO (2) | 2024.12.18 |
| Spring model (1) | 2024.12.17 |