회원정보 상세조회하기
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
볼빵빵오춘기