Hello

회원목록 출력하기

by 볼빵빵오춘기

강의 따라하기/springframework_setting

Controller

@GetMapping("/")
public String findAll(Model model){
    List<MemberDTO> memberDTOList = memberService.findAll();
    model.addAttribute("memberList",memberDTOList);
    return "list";
}

 

Service

public List<MemberDTO> findAll() {
    return memberRepository.findAll();
}

 

Repository

public List<MemberDTO> findAll() {
    return sql.selectList("Member.findAll");
}

 

Mapper

<select id="findAll" resultType="member">
    select * from member_table
</select>

 

list.jsp

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

why? jstl을 가져왔기때문에 반복문이 필요하다. jsp에서 제공하는 태그이다.

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>list</title>
</head>
<body>
    <table>
        <tr>
            <th>id</th>
            <th>email</th>
            <th>password</th>
            <th>name</th>
            <th>age</th>
            <th>mobile</th>
            <th>조회</th>
            <th>삭제</th>
        </tr>
        <c:forEach items="${memberList}" var="member">
            <tr>
                <td>${member.id}</td>
                <td>
                    <a href="/member?id=${member.id}">${member.memberEmail}</a>
                </td>
                <td>${member.memberPassword}</td>
                <td>${member.memberName}</td>
                <td>${member.memberAge}</td>
                <td>${member.memberMobile}</td>
                <td>
                    <a href="/member?id=${member.id}">조회</a>
                </td>
                <td>
                    <button onclick="deleteMember('${member.id}')">삭제</button>
                </td>
            </tr>
        </c:forEach>
    </table>
</body>
<script>
    const deleteMember = (id) => {
        console.log(id);
        location.href = "/member/delete?id="+id;
    }
</script>
</html>
저작자표시 비영리 변경금지
블로그의 프로필 사진

블로그의 정보

Hello 춘기's world

볼빵빵오춘기

활동하기

티스토리툴바