$$config title: 게시판 검색기능 keywords: - IT - SQL $$ ```java public String showList(Model model, @RequestParam(defaultValue ="1") int boardId, @RequestParam(defaultValue ="1") int page, @RequestParam(defaultValue = "title,body") String searchKeywordTypeCode, @RequestParam(defaultValue = "") String searchKeyword) { Board board = boardService.getBoardById(boardId); if(board == null) { return rq.historyBackJsOnView(Ut.f("%d번 게시물은 존재하지 않습니다.", boardId)); } int articlesCount = userArticleServcie.getArticlesCount(boardId); int articlesCount = userArticleServcie.getArticlesCount(boardId,searchKeywordTypeCode,searchKeyword); int itemsCountInAPage = 10; int pageCount = (int) Math.ceil((double)articlesCount/itemsCountInAPage); List

articles = userArticleServcie.getForPrintArticles(rq.getLoginedMemberId(),boardId,itemsCountInAPage,page); List

articles = userArticleServcie.getForPrintArticles(rq.getLoginedMemberId(),boardId,itemsCountInAPage,page, searchKeywordTypeCode,searchKeyword); model.addAttribute("articles", articles); model.addAttribute("board", board); model.addAttribute("articlesCount", articlesCount); model.addAttribute("pageCount", pageCount); model.addAttribute("boardId", boardId); model.addAttribute("page", page); return "usr/article/list"; } ``` ```sql AND A.title LIKE CONCAT('%', #{searchKeyword}, '%') AND A.body LIKE CONCAT('%', #{searchKeyword}, '%') AND ( A.title LIKE CONCAT('%', #{searchKeyword}, '%') OR A.body LIKE CONCAT('%', #{searchKeyword}, '%') ) ``` ``` CONCAT을 사용하지 않고 %searchKeyword%를 해서 DB로 날리면 %'searchKeyword'%로 작동이 돼서 LIKE기능을 사용할 수 없다. 따라서, LIKE CONCAT('%', #{searchKeyword}, '%')와 같이 사용해야 아무 이상없이 작동한다.