Light Purple Pointer
728x90

listPage.jsp ๋ณต์‚ฌํ•ด์„œ listPageSearch.jsp์ƒ์„ฑ

 

 

์ฃผ์†Œ ์ˆ˜์ •

		<c:if test="${page.prev}">
			<span>[ <a href="/board/listPageSearch?num=${page.startPageNum - 1}">์ด์ „</a>
				]
			</span>
		</c:if>

		<c:forEach begin="${page.startPageNum}" end="${page.endPageNum}" var="num">
			<span> <c:if test="${select != num}">
					<a href="/board/listPageSearch?num=${num}">${num}</a>
				</c:if> <c:if test="${select == num}">
					<b>${num}</b>
				</c:if>

			</span>
		</c:forEach>
		<c:if test="${page.next}">
			<span>[ <a href="/board/listPageSearch?num=${page.endPageNum + 1}">๋‹ค์Œ</a>
				]
			</span>
		</c:if>

 

 

 

 

BoardController ์— ์ถ”๊ฐ€

	
	// ๊ฒŒ์‹œ๋ฌผ ๋ชฉ๋ก + ํŽ˜์ด์ง• + ๊ฒ€์ƒ‰
	@GetMapping("/listPageSearch")
	public void getlistPageSearch(@RequestParam("num") int num, Model model) throws Exception {

		int count = boardService.count();
		
		Page page = new Page();
		page.setNum(num);
		page.setCount(count);
		page.dataCalc();//ํŽ˜์ด์ง€์™€ ์ด๊ฒŒ์‹œ๊ธ€๋กœ ๊ณ„์‚ฐํ•˜๊ธฐ 
		
		List<BoardVO> list =  boardService.listPage(page.getDisplayPost(), page.getPostNum());
		model.addAttribute("list", list); //ํ˜„์žฌ num ํŽ˜์ด์ง€์˜ ๊ฒŒ์‹œ๊ธ€ ๋ฐ์ดํ„ฐ
		model.addAttribute("page", page); // ํŽ˜์ด์ง€ ๊ฐ์ฒด
		model.addAttribute("select", num);//ํ˜„์žฌ ์„ ํƒํ•œ ํŽ˜์ด์ง€ 

	}

 

 

home.jsp - ๋งํฌ ์ถ”๊ฐ€ 

<p><a href="/board/listPageSearch?num=1">๊ธ€ ๋ชฉ๋ก(ํŽ˜์ด์ง•+๊ฒ€์ƒ‰)</a></p>

 

 

 

 

 

listPageSearch.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"%>

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>๊ฒŒ์‹œ๋ฌผ ํŽ˜์ด์ง• + ๊ฒ€์ƒ‰</title>
</head>
<body>
	<div id="nav">
		<%@ include file="../include/nav.jsp"%>
	</div>
	<table>
		<thead>
			<tr>
				<th>๋ฒˆํ˜ธ</th>
				<th>์ œ๋ชฉ</th>
				<th>์ž‘์„ฑ์ผ</th>
				<th>์ž‘์„ฑ์ž</th>
				<th>์กฐํšŒ์ˆ˜</th>
			</tr>
		</thead>
		<tbody>
			<c:forEach items="${list}" var="board">
				<tr>
					<td>${board.bno}</td>
					<td><a href="/board/view?bno=${board.bno}">${board.title}</a></td>
					<td><fmt:formatDate value="${board.regDate}"
							pattern="yyyy-MM-dd" /></td>
					<td>${board.writer}</td>
					<td>${board.viewCnt}</td>
				</tr>

			</c:forEach>
		</tbody>

	</table>
	<div>
		<c:if test="${page.prev}">
			<span>[ <a
				href="/board/listPageSearch?num=${page.startPageNum - 1}">์ด์ „</a> ]
			</span>
		</c:if>

		<c:forEach begin="${page.startPageNum}" end="${page.endPageNum}"
			var="num">
			<span> <c:if test="${select != num}">
					<a href="/board/listPageSearch?num=${num}">${num}</a>
				</c:if> <c:if test="${select == num}">
					<b>${num}</b>
				</c:if>

			</span>
		</c:forEach>
		<c:if test="${page.next}">
			<span>[ <a
				href="/board/listPageSearch?num=${page.endPageNum + 1}">๋‹ค์Œ</a> ]
			</span>
		</c:if>


		<!-- ๊ฒ€์ƒ‰ -->
		<form method="get">
		
			<select name="searchType">
				<option value="title">์ œ๋ชฉ</option>
				<option value="content">๋‚ด์šฉ</option>
				<option value="title_content">์ œ๋ชฉ+๋‚ด์šฉ</option>
				<option value="writer">์ž‘์„ฑ์ž</option>
			</select> 
			
			<input type="text" name="keyword" />

			<button type="submit">๊ฒ€์ƒ‰</button>
		</form>
	</div>
</body>
</html>

 

 

 

์ฟผ๋ฆฌ๋ฌธ ์ž‘์„ฑ ํ•„์š”

 

boardMapper.xml์— ์ถ”๊ฐ€

	<!-- ๊ฒŒ์‹œ๊ธ€ ๋ชฉ๋ก + ํŽ˜์ด์ง•+๊ฒ€์ƒ‰ -->
	<select id="listPageSearch" parameterType="hashMap"
		resultType="com.board.domain.BoardVO">
		SELECT bno, title, content, writer, regDate, viewCnt
		FROM tbl_board
		<if test="searchType.equals('title')">
			WHERE title LIKE CONCAT('%',#{keyword},'%')
		</if>
		<if test="searchType.equals('content')">
			WHERE content LIKE CONCAT('%',#{keyword},'%')
		</if>
		<if test="searchType.equals('writer')">
			WHERE writer LIKE CONCAT('%',#{keyword},'%')
		</if>
		<if test="searchType.equals('title_content')">
			WHERE title LIKE CONCAT('%',#{keyword},'%')
			or content LIKE CONCAT('%',#{keyword},'%')
		</if>

		ORDER BY bno desc
		limit #{displayPost}, #{postNum};
	</select>

 

 

 

BoardDAO์— ์ถ”๊ฐ€ 

	//๊ฒŒ์‹œ๊ธ€ ๋ชฉ๋ก + ํŽ˜์ด์ง• +๊ฒ€์ƒ‰
	public List<BoardVO> listPageSearch(int displayPost, int postNum, String searchType, String keyword) throws Exception;

 

 

 

BoardDAOImple ์ถ”๊ฐ€

	//๊ฒŒ์‹œ๊ธ€ ๋ชฉ๋ก + ํŽ˜์ด์ง• + ๊ฒ€์ƒ‰
	@Override
	public List<BoardVO> listPageSearch(int displayPost, int postNum, String searchType, String keyword)
			throws Exception {
		HashMap<String, Object> data = new HashMap<String, Object>();
		
		data.put("displayPost", displayPost);
		data.put("postNum", postNum);
		
		data.put("searchType", searchType);
		data.put("keyword", keyword);
		
		
		return sqlTemplate.selectList("board.listPageSearch",data );
	}

 

 

 

BoardService

	// ๊ฒŒ์‹œ๋ฌผ ๋ชฉ๋ก + ํŽ˜์ด์ง• + ๊ฒ€์ƒ‰
	public List<BoardVO> listPageSearch(
	  int displayPost, int postNum, String searchType, String keyword) throws Exception;

 

 

BoardServiceImple

	//๊ฒŒ์‹œ๊ธ€ ๋ชฉ๋ก + ํŽ˜์ด์ง• + ๊ฒ€์ƒ‰
	@Override
	public List<BoardVO> listPageSearch(int displayPost, int postNum, String searchType, String keyword)
			throws Exception {
		return boardDAO.listPageSearch(displayPost, postNum, searchType, keyword);
	}

 

 

 

 

 

 

 

BoardController

	// ๊ฒŒ์‹œ๋ฌผ ๋ชฉ๋ก + ํŽ˜์ด์ง• + ๊ฒ€์ƒ‰
	@GetMapping("/listPageSearch")
	public void getlistPageSearch(@RequestParam(value = "num", required = false, defaultValue="1") int num, Model model,
		 @RequestParam(value = "searchType", required = false, defaultValue="title") String searchType,
		 @RequestParam(value = "keyword", required = false, defaultValue="") String keyword
		 ) throws Exception {

		int count = boardService.count();
		
		Page page = new Page();
		page.setNum(num);
		page.setCount(count);
		page.dataCalc();//ํŽ˜์ด์ง€์™€ ์ด๊ฒŒ์‹œ๊ธ€๋กœ ๊ณ„์‚ฐํ•˜๊ธฐ 
		
		List<BoardVO> list =  boardService.listPageSearch(page.getDisplayPost(), page.getPostNum(),searchType,keyword);
		model.addAttribute("list", list); //ํ˜„์žฌ num ํŽ˜์ด์ง€์˜ ๊ฒŒ์‹œ๊ธ€ ๋ฐ์ดํ„ฐ
		model.addAttribute("page", page); // ํŽ˜์ด์ง€ ๊ฐ์ฒด
		model.addAttribute("select", num);//ํ˜„์žฌ ์„ ํƒํ•œ ํŽ˜์ด์ง€ 

	}

 

 

 

 

nav.jsp์— 

๊ธ€ ๋ชฉ๋ก(ํŽ˜์ด์ง• + ๊ฒ€์ƒ‰)์ถ”๊ฐ€

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<ul> 
 <li>
  <a href="/board/listPageSearch?num=1">๊ธ€ ๋ชฉ๋ก(ํŽ˜์ด์ง• + ๊ฒ€์ƒ‰)</a> 
 </li>

 <li>
  <a href="/board/list">๊ธ€ ๋ชฉ๋ก</a> 
 </li>
 
 <li>
  <a href="/board/write">๊ธ€ ์ž‘์„ฑ</a> 
 </li> 
 
 <li>
 <a href="/board/listPage?num=1">๊ธ€ ๋ชฉ๋ก(ํŽ˜์ด์ง•)</a> 
</li>
</ul>

 

 

 

 

 

 

๋‹ค๋ฅธ ํŽ˜์ด์ง€๋กœ ๋„˜์–ด๊ฐ€๋ฉด 

searchType์ด๋ž‘ keyword๊ฐ€ ์œ ์ง€๋˜์ง€ ์•Š์Œ

 

boardMapper.xml

 

	<!-- ๊ฒ€์ƒ‰ ๊ฒฐ๊ณผ ์ด ๊ฐฏ์ˆ˜ -->
	<select id="searchCount" parameterType="hashMap"
		resultType="int">
		SELECT COUNT(bno)
		FROM
		tbl_board
		<if test="searchType.equals('title')">
			WHERE title LIKE CONCAT('%',#{keyword},'%')
		</if>
		<if test="searchType.equals('content')">
			WHERE content LIKE CONCAT('%',#{keyword},'%')
		</if>
		<if test="searchType.equals('writer')">
			WHERE writer LIKE CONCAT('%',#{keyword},'%')
		</if>
		<if test="searchType.equals('title_content')">
			WHERE title LIKE CONCAT('%',#{keyword},'%')
			or content LIKE
			CONCAT('%',#{keyword},'%')
		</if>

	</select>

 

 

BoardDAO

 

	// ๊ฒŒ์‹œ๋ฌผ ์ด ๊ฐฏ์ˆ˜ + ๊ฒ€์ƒ‰ ์ ์šฉ
	public int searchCount(String searchType, String keyword) throws Exception;

 

BoardDAOImple

 

	//๊ฒŒ์‹œ๋ฌผ ์ด ๊ฐฏ์ˆ˜ + ๊ฒ€์ƒ‰ ์ ์šฉ
	@Override
	public int searchCount(String searchType, String keyword) throws Exception {
		HashMap<String, Object> data = new HashMap<String, Object>();
		
		data.put("searchType", searchType);
		data.put("keyword", keyword);
		
		return sqlTemplate.selectOne("board.searchCount", data);
	}

 

 

BoardService

	// ๊ฒŒ์‹œ๋ฌผ ์ด ๊ฐฏ์ˆ˜ + ๊ฒ€์ƒ‰ ์ ์šฉ
	public int searchCount(String searchType, String keyword) throws Exception;โ€‹

BoardServiceImple

	@Override
	public int searchCount(String searchType, String keyword) throws Exception {
		return boardDAO.searchCount(searchType, keyword);
	}

 

 

BoardController

	
	// ๊ฒŒ์‹œ๋ฌผ ๋ชฉ๋ก + ํŽ˜์ด์ง• + ๊ฒ€์ƒ‰
	@GetMapping("/listPageSearch")
	public void getlistPageSearch(@RequestParam(value = "num", required = false, defaultValue="1") int num, Model model,
			 					  @RequestParam(value = "searchType", required = false, defaultValue="title") String searchType,
			 					  @RequestParam(value = "keyword", required = false, defaultValue="") String keyword
								  ) throws Exception {

		int count = boardService.searchCount(searchType, keyword);// ๊ฒŒ์‹œ๊ธ€ ์ด ๊ฐฏ์ˆ˜ 
		
		
		Page page = new Page();
		page.setNum(num);
		page.setCount(count); 
		page.dataCalc();//ํŽ˜์ด์ง€์™€ ์ด๊ฒŒ์‹œ๊ธ€๋กœ ๊ณ„์‚ฐํ•˜๊ธฐ 
		
		
		List<BoardVO> list =  boardService.listPageSearch(page.getDisplayPost(), page.getPostNum(),searchType,keyword);
		model.addAttribute("list", list); //ํ˜„์žฌ num ํŽ˜์ด์ง€์˜ ๊ฒŒ์‹œ๊ธ€ ๋ฐ์ดํ„ฐ
		model.addAttribute("page", page); // ํŽ˜์ด์ง€ ๊ฐ์ฒด
		model.addAttribute("select", num);//ํ˜„์žฌ ์„ ํƒํ•œ ํŽ˜์ด์ง€ 
		model.addAttribute("searchType", searchType);
		model.addAttribute("keyword",keyword);

	}

 

 

llistPageSearch.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"%>

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>๊ฒŒ์‹œ๋ฌผ ํŽ˜์ด์ง• + ๊ฒ€์ƒ‰</title>
</head>
<body>
	<div id="nav">
		<%@ include file="../include/nav.jsp"%>
	</div>
	<table>
		<thead>
			<tr>
				<th>๋ฒˆํ˜ธ</th>
				<th>์ œ๋ชฉ</th>
				<th>์ž‘์„ฑ์ผ</th>
				<th>์ž‘์„ฑ์ž</th>
				<th>์กฐํšŒ์ˆ˜</th>
			</tr>
		</thead>
		<tbody>
			<c:forEach items="${list}" var="board">
				<tr>
					<td>${board.bno}</td>
					<td><a href="/board/view?bno=${board.bno}">${board.title}</a></td>
					<td><fmt:formatDate value="${board.regDate}"
							pattern="yyyy-MM-dd" /></td>
					<td>${board.writer}</td>
					<td>${board.viewCnt}</td>
				</tr>

			</c:forEach>
		</tbody>

	</table>
	<div>
		<c:if test="${page.prev}">
			<span>[ <a
				href="/board/listPageSearch?num=${page.startPageNum - 1}&searchType=${searchType}&keyword=${keyword}">์ด์ „</a> ]
			</span>
		</c:if>

		<c:forEach begin="${page.startPageNum}" end="${page.endPageNum}"
			var="num">
			<span> <c:if test="${select != num}">
					<a href="/board/listPageSearch?num=${num}&searchType=${searchType}&keyword=${keyword}">${num}</a>
				</c:if> <c:if test="${select == num}">
					<b>${num}</b>
				</c:if>

			</span>
		</c:forEach>
		<c:if test="${page.next}">
			<span>[ <a
				href="/board/listPageSearch?num=${page.endPageNum + 1}&searchType=${searchType}&keyword=${keyword}">๋‹ค์Œ</a> ]
			</span>
		</c:if>


		<%--  <c:forEach begin="1" end="${pageNum}" var="num">
		   <span>
		     <a href="/board/listPage?num=${num}">${num}</a>
		  </span>
	   </c:forEach> --%>

		<!-- ๊ฒ€์ƒ‰ -->
		<form method="get">
			<select name="searchType">
				<option value="title"
					<c:if test="${searchType eq 'title'}">selected</c:if>>์ œ๋ชฉ</option>
				<option value="content"
					<c:if test="${searchType eq 'content'}">selected</c:if>>๋‚ด์šฉ</option>
				<option value="title_content"
					<c:if test="${searchType eq 'title_content'}">selected</c:if>>์ œ๋ชฉ+๋‚ด์šฉ</option>
				<option value="writer"
					<c:if test="${searchType eq 'writer'}">selected</c:if>>์ž‘์„ฑ์ž</option>
			</select> 
			
			<input type="text" name="keyword" value="${keyword}"/>

			<button type="submit">๊ฒ€์ƒ‰</button>
		</form>
	</div>

</body>
</html>

728x90

'BACKEND > Spring' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๋‹ค๋ฅธ ๊ธ€

๊ฒŒ์‹œํŒ ๋งŒ๋“ค๊ธฐ - ๋Œ“๊ธ€ ์ž‘์„ฑ(write)  (0) 2023.10.25
๊ฒŒ์‹œํŒ ๋งŒ๋“ค๊ธฐ - ๋Œ“๊ธ€ DB์— ํ…Œ์ด๋ธ” ์ถ”๊ฐ€, ๊ฒŒ์‹œ๊ธ€ ๋Œ“๊ธ€ ์กฐํšŒ  (0) 2023.10.25
๊ฒŒ์‹œํŒ ๋งŒ๋“ค๊ธฐ - ํŽ˜์ด์ง• ๊ธฐ๋Šฅ ๊ตฌํ˜„2  (0) 2023.10.24
๊ฒŒ์‹œํŒ ๋งŒ๋“ค๊ธฐ - ํŽ˜์ด์ง• ๊ธฐ๋Šฅ ๊ตฌํ˜„  (2) 2023.10.24
๊ฒŒ์‹œํŒ ๋งŒ๋“ค๊ธฐ - ์กฐํšŒ์ˆ˜ ์ฆ๊ฐ€(UPDATE) ๊ธฐ๋Šฅ ์ถ”๊ฐ€  (0) 2023.10.24
ใ„ด

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”