๋ชฉ์ฐจ
๋ฏธ๋์ ๋ด๊ฐ ๋ณด๊ธฐ ์ํด ๊ธฐ๋กํจ
ํ ์คํธ ํ ์ด๋ธ ๐
CREATE TABLE `tmp_board`(
`board_seq` bigint auto_increment,
`title` varchar (30),
`contents` varchar (30),
`name` varchar (30),
`reg_date` timestamp,
`update_date` timestamp,
primary key(board_seq)
);
mapper 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">
<mapper namespace="study.tmp11.mapper.BoardMapper">
<resultMap id="boardMap" type="map">
<id column="board_seq" property="boardSeq"/>
<result column="title" property="title"/>
<result column="contents" property="contents"/>
<result column="name" property="name"/>
<result column="reg_date" property="regDate"/>
<result column="update_date" property="updateDate"/>
</resultMap>
<select id="findListMap" resultMap="boardMap">
SELECT * FROM t_board
ORDER BY reg_date DESC
</select>
</mapper>
mapper interface ๐
package study.tmp11.mapper;
import org.apache.ibatis.annotations.Mapper;
import study.tmp11.domain.BoardVO;
import java.util.List;
import java.util.Map;
@Mapper
public interface BoardMapper {
List<Map<String, Object>> findListMap();
}
service ๐
package study.tmp11.service;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;
import study.tmp11.domain.BoardVO;
import study.tmp11.mapper.BoardMapper;
import java.util.List;
import java.util.Map;
@Service
@Slf4j
@RequiredArgsConstructor
public class BoardService {
private final BoardMapper boardMapper;
public List<Map<String, Object>> findListMap() {
return boardMapper.findListMap();
}
}
controller ๐
package study.tmp11.controller;
import lombok.RequiredArgsConstructor;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import study.tmp11.domain.BoardVO;
import study.tmp11.service.BoardService;
import java.util.List;
import java.util.Map;
@Controller
@RequiredArgsConstructor
@Slf4j
public class BoardController {
private final BoardService boardService;
@GetMapping("/board/listMap")
public String boardListMap(Model model) {
List<Map<String, Object>> list = boardService.findListMap();
model.addAttribute("list", list);
return "board/listMap";
}
}
view(thymeleaf)
<!doctype html>
<html xmlns:th="http://www.thymeleaf.org" xmlns:sec="http://www.w3.org/1999/xhtml">
<head>
<meta charset="UTF-8">
<meta name="viewport"
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>listMap</title>
</head>
<body>
<div>
<table class="table table-striped">
<thead>
<tr>
<th>๋ฒํธ</th>
<th>์ ๋ชฉ</th>
<th>๋ด์ฉ</th>
<th>์์ฑ์</th>
</tr>
</thead>
<tbody>
<tr th:each="item : ${list}">
<td th:text="${item[boardSeq]}"></td>
<td th:text="${item[title]}"></td>
<td th:text="${item[contents]}"></td>
<td th:text="${item[name]}"></td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
๊ฒฐ๊ณผํ๋ฉด ๐
'IT > development' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
| [jQuery]radio/checkbox ์ฒดํฌ ์ฌ๋ถ ํ์ธ (0) | 2022.11.19 |
|---|---|
| [IDE/SVN]eclipse svn branch ์์ฑ (0) | 2022.11.19 |
| [springBoot] ํ์ด์ง๋ค์ด์ ์ฒ๋ฆฌ(feat. MariaDB) (0) | 2022.11.19 |
| [spring boot/mybatis] ์ฟผ๋ฆฌ ๋ก๊ทธ ์ ๋ ฌ ๋ฐ ๊ธฐํ(feat. log4jdbc) (0) | 2022.11.19 |
| [IDE]dbeaver ํ๊ธ ๊นจ์ง ์กฐ์น (0) | 2022.11.18 |
๋๊ธ