Hello

회원정보 상세조회하기

by 볼빵빵오춘기

Controller

@GetMapping
public String findById(@RequestParam("id") Long id, Model model){
MemberDTO memberDTO = memberService.findById(id);
model.addAttribute("member",memberDTO);
return "detail";
}

 

Service

public MemberDTO findById(Long id) {
return memberRepository.findById(id);
}

 

Repository

public MemberDTO findById(Long id) {
return sql.selectOne("Member.findById",id);
}

 

Mapper.xml

<select id="findById" parameterType="Long" resultType="member">
select * from member_table where id=#{id}
</select>

 

detail.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>detail</title>
</head>
<body>
<table>
<tr>
<th>id</th>
<td>${member.id}</td>
</tr>
<tr>
<th>email</th>
<td>${member.memberEmail}</td>
</tr>
<tr>
<th>password</th>
<td>${member.memberPassword}</td>
</tr>
<tr>
<th>name</th>
<td>${member.memberName}</td>
</tr>
<tr>
<th>age</th>
<td>${member.memberAge}</td>
</tr>
<tr>
<th>mobile</th>
<td>${member.memberMobile}</td>
</tr>
</table>
</body>
</html>
블로그의 프로필 사진

블로그의 정보

Hello 춘기's world

볼빵빵오춘기

활동하기