package myWeb.mvc.controller;


import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpSession;


import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

import org.springframework.ui.Model;

import org.springframework.web.bind.annotation.RequestMapping;


import myWeb.mvc.service.MyWebService;

import myWeb.mvc.vo.LoginVo;

import myWeb.mvc.vo.SearchVo;


@Controller

public class MyWebController {

String page;


@Autowired(required = false)

MyWebService service;


@Autowired(required = false)

HttpSession session;


@RequestMapping("login.do")

public String login(LoginVo loginVo, HttpServletRequest request) {

if (service.login(loginVo) == true) {

session = request.getSession();

session.setAttribute("user", loginVo.getUser());

session.setAttribute("pw", loginVo.getPw());

page = "redirect:board1.do";

} else {

page = "WEB-INF//views//loginPage.jsp";

}

return page;

}


public boolean loginCheck() {

String user = (String) session.getAttribute("user");

String pw = (String) session.getAttribute("pw");

LoginVo loginVo = new LoginVo(user, pw);

return service.login(loginVo);

}


@RequestMapping("board1.do")

public String board1(Model model, SearchVo searchVo) {

if (loginCheck()) {

System.out.println("searchVo.getSearchFilter() : " + searchVo.getSearchFilter());

System.out.println("searchVo.getSearchValue() : " + searchVo.getSearchValue());

model.addAttribute("postVoList", service.board1(searchVo));

page = "WEB-INF//views//board1Page.jsp";

} else {

page = "login.do";

}

return page;

}

}



이게 컨트롤러구

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>

<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>

<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form"%>

<!DOCTYPE html>

<html>

<head>

<meta charset="UTF-8">

<title>Insert title here</title>

</head>

<script src="https://code.jquery.com/jquery-latest.min.js"></script>

<body>

<table>

<tr>

<th>Post #</th>

<th>Title</th>

<th>User</th>

<th>Date</th>

</tr>

<c:forEach var="postVo" items="${postVoList}">

<tr>

<td>${postVo.post_id}</td>

<td>${postVo.head}</td>

<td>${postVo.user}</td>

<td>${postVo.date}</td>

</tr>

</c:forEach>

</table>


<form>

<select name="searchFilter">

<option value="">Search by</option>

<option value="user">User</option>

<option value="head">Title</option>

<option value="body">Post</option>

</select>

<input type="text" name="searchValue">

<input type="submit" value="search">

</form>


</body>

</html>


이게 jsp파일이야


디비에 항목은 post_id user head body인데


head body 검색은 잘대는데 user키워드로는 검색이 안대


원인이 보이니??