[v2] Spring 게시판 조금 알고 따라하기 - 5

1. 레포지토리 작성

public User findByUsernameAndPassword(String username, String password) {
    Query query = em.createQuery("select u from User u where u.username = :username and u.password = :password", User.class);
    query.setParameter("username", username);
    query.setParameter("password", password);
    User user = (User) query.getSingleResult();
    return user;
}

2. 테스트

@Test
public void findByUsernameAndPassword_test() {
    String username = "love";
    String password = "1234";

    User user = userRepository.findByUsernameAndPassword(username, password);
    System.out.println(user.getUsername());
    System.out.println(user.getEmail());
}
/* 실행결과
Hibernate: 
    select
        u1_0.id,
        u1_0.created_at,
        u1_0.email,
        u1_0.password,
        u1_0.username 
    from
        user_tb u1_0 
    where
        u1_0.username=? 
        and u1_0.password=?
love
love@nateSELECT * FROM BOARD_TB .com
*/

3. 컨트롤러 작성

@Autowired
private HttpSession session;

@PostMapping("/login")
public String login(UserRequest.LoginDTO loginDTO) {
    User sessionUser = userRepository.findByUsernameAndPassword(loginDTO.getUsername(), loginDTO.getPassword());
    session.setAttribute("sessionUser", sessionUser);
    return "redirect:/board";
}

4. 확인

5. 헤더 설정

<div class="collapse navbar-collapse" id="collapsibleNavbar">
            <ul class="navbar-nav">
                {{#sessionUser}}
                    <li class="nav-item">
                        <a class="nav-link" href="/board/save-form">글쓰기</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="/logout">로그아웃</a>
                    </li>
                {{/sessionUser}}
                {{^sessionUser}}
                    <li class="nav-item">
                        <a class="nav-link" href="/join-form">회원가입</a>
                    </li>
                    <li class="nav-item">
                        <a class="nav-link" href="/login-form">로그인</a>
                    </li>
                {{/sessionUser}}

            </ul>
        </div>

6. 로그아웃 설정

    @GetMapping("/logout")
    public String logout() {
        session.invalidate();
        return "redirect:/board";
    }