검색기능참고

기능 구현

  @RequestMapping("/list")
      public String list(Model model,HttpServletRequest request)
      {
          BoardDao bdao = sqlSession.getMapper(BoardDao.class);

          String cla="title";
          if(request.getParameter("cla")!=null)
              cla = request.getParameter("cla");

          String search = "";
          if(request.getParameter("search")!=null)
              search = request.getParameter("search");

          model.addAttribute("list",bdao.list(cla,search));
          return "/list";
      }
  }

쿼리문

<select id="list" resultType="kr.co.search.dto.BoardDto">
	select *from board where ${param1} like concat('%',#{param2},'%') order by id desc
</select>

view

<table width="600" align="center">
        <caption>
            <form method="post" action="list">
                <select name="cla">
                    <option value="title"> 제목 </option>
                    <option value="content"> 내용 </option>
                    <option value="name"> 이름 </option>
                </select>
                <input type="text" name="search" size="10">
                <input type="submit" value="검색">
            </form>
        </caption>
            <tr>
                <td> 제 목 </td>
                <td> 작성자 </td>
                <td> 조회수 </td>
                <td> 작성일 </td>
            </tr>
            <c:forEach items="${list}" var="bdto">
            <tr>
                <td> ${bdto.title} </td>
                <td> ${bdto.name} </td>
                <td> ${bdto.readnum} </td>
                <td> ${bdto.writeday} </td>
            </tr>
            </c:forEach>
    </table>