(Springboot) 🅲 Mybatis 회원가입 등급 목록 조회

회원가입과 이어짐

2022.02.22 - [Framework/Spring] - (Springboot) Mybatis 회원 가입

 

 

1. MemberMapper 인터페이스 추상메서드 작성

//회원 등급 목록 조회
public List<MemberLevel> getMemberLevelList();

 

2. MemberMapper.xml 쿼리문 작성

<select id="getMemberLevelList" resultType="MemberLevel">
	/* 회원 등급 목록 조회 */
	SELECT
		 l.level_num			AS levelNum
		 ,l.level_name			AS levelName
	FROM
		tb_member_level AS l;
</select>

 

3. MemberController에 MemberMapper DI 주입

private MemberMapper memberMapper;

public MemberController(MemberService memberService, MemberMapper memberMapper) {
	this.memberService = memberService;
	this.memberMapper = memberMapper;
}

/**
 * 회원가입 폼 
 */
@GetMapping("/addMember")
public String addMember(Model model) {
	//회원등급 목록 데이터
	List<MemberLevel> memberLevelList = memberService.getMemberLevelList();
	
	model.addAttribute("title", "회원가입");
	model.addAttribute("memberLevelList", memberLevelList);
	
	return "member/addMember";
}

 

4. VIEW 단 회원권한 부분 수정

<tr>
	<td>회원권한</td>
	<td>
		<select name="memberLevel" style="width:100%;" disabled>
		<th:block th:if="${not #lists.isEmpty(memberLevelList)}" th:each="l : ${memberLevelList}" >
			<option th:value="${l.levelNum}">[[${l.levelName}]]</option>
		</th:block>
		<th:block th:unless="${not #lists.isEmpty(memberLevelList)}">
			<option>등록된 회원등급이 없습니다.</option>
		</th:block>
		</select>
	</td>
</tr>

 

 

5. 실행 결과