• 1:N 테이블(member, member_auth)에서 두 결과 MemberVO 객체에 한번에 담기

Controller

• CrudMemberController.java

package kr.or.ddit.controller.member;

import java.util.List;

import javax.inject.Inject;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import kr.or.ddit.service.IMemberService;
import kr.or.ddit.vo.MemberVO;
import lombok.extern.slf4j.Slf4j;

@Controller
@RequestMapping("/crud/member")
@Slf4j
public class CrudMemberController {

	@Inject
	private IMemberService service;
	
	@GetMapping(value="/register")
	public String crudMemberRegisterForm() {
		log.info("crudMemberRegisterForm() 실행..!");
		return "crud/member/register";
	}
	
	@RequestMapping(value="/register", method = RequestMethod.POST)
	public String crudMemberRegister(MemberVO member, Model model) {
		log.info("crudMemberRegister() 실행...!");
		service.register(member);
		model.addAttribute("msg", "등록이 완료되었습니다.");
		return "crud/member/success";
	}
	
	@GetMapping(value="/list")
	public String list(Model model) {
		List<MemberVO> memberList = service.list();
		model.addAttribute("memberList", memberList);
		return "crud/member/list";
	}
	
	@GetMapping(value="/read")
	public String read(int userNo, Model model) {
		MemberVO member = service.read(userNo);
		model.addAttribute("member", member);
		return "crud/member/read";
	}
	
	**// 수정하기 폼 이동 메소드**
	@RequestMapping(value="/modify", method = RequestMethod.GET)
	public String modifyForm(int userNo, Model model) {
		MemberVO member = service.read(userNo);
		model.addAttribute("member", member);
		return "crud/member/modify";
	}
	
	**// 수정하기 처리 메소드**
	@RequestMapping(value="/modify", method = RequestMethod.POST)
	public String modify(MemberVO member, Model model) {
		service.modify(member);
		model.addAttribute("mgs", "수정이 완료 되었습니다.");
		return "crud/member/success";
	}
}

Service

• MemberServiceImpl.java

interface로 먼저 IBoardSerivce를 생성하고 한다.

package kr.or.ddit.service.impl;

import java.util.List;

import javax.inject.Inject;

import org.springframework.stereotype.Service;

import kr.or.ddit.mapper.MemberMapper;
import kr.or.ddit.service.IMemberService;
import kr.or.ddit.vo.MemberAuth;
import kr.or.ddit.vo.MemberVO;

@Service
public class MemberServiceImpl implements IMemberService {

	@Inject
	private MemberMapper mapper;
	
	@Override
	public void register(MemberVO member) {
		mapper.create(member);
		
		MemberAuth memberAuth = new MemberAuth();
		memberAuth.setUserNo(member.getUserNo());
		memberAuth.setAuth("ROLE_USER");
		
		mapper.createAuth(memberAuth);
	}
	@Override
	public List<MemberVO> list() {
		return mapper.list();
	}
	@Override
	public MemberVO read(int userNo) {
		return mapper.read(userNo);
	}
	
	// 수정하기 service
	@Override
	public void modify(MemberVO member) {
		mapper.modify(member);
		
		int userNo = member.getUserNo();
		mapper.deleteAuth(userNo); **// 권한 삭제**
		
		List<MemberAuth> authList = member.getAuthList();
		for(int i = 0; i < authList.size(); i++) {
			MemberAuth memberAuth = authList.get(i);
			String auth = memberAuth.getAuth();
			if(auth == null) {
				continue;
			}
			if(auth.trim().length() == 0) {
				continue;
			}
			memberAuth.setUserNo(userNo);
		**// 권한 추가**
			mapper.createAuth(memberAuth);
		}
	}

}

MemberMapper

• **MemberMapper.java (interface)**

package kr.or.ddit.mapper;

import java.util.List;

import kr.or.ddit.vo.MemberAuth;
import kr.or.ddit.vo.MemberVO;

public interface MemberMapper {

	public void create(MemberVO member);

	public void createAuth(MemberAuth memberAuth);

	public List<MemberVO> list();

	public MemberVO read(int userNo);

	public void modify(MemberVO member);

}

Mapper

• memberMapper_SQL.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "<https://mybatis.org/dtd/mybatis-3-mapper.dtd>">
 <mapper namespace="kr.or.ddit.mapper.MemberMapper">
 
 	<resultMap type="memberVO" id="memberMap">
 		<id property="userNo" column="user_no"/>
 		<result property="userNo" column="user_no"/>
 		<result property="userId" column="user_id"/>
 		<result property="userPw" column="user_pw"/>
 		<result property="userName" column="user_Name"/>
 		<result property="regDate" column="reg_date"/>
 		<result property="updDate" column="upd_date"/>
 		<collection property="authList" resultMap="authMap"/>
 	</resultMap>
 	
 	<resultMap type="memberAuth" id="authMap">
 		<result property="userNo" column="user_no"/>
 		<result property="auth" column="auth"/>
 	</resultMap>
 	
 	<insert id="create" parameterType="memberVO" useGeneratedKeys="true">
 		<selectKey keyProperty="userNo" resultType="int" order="BEFORE">
 			select seq_member.nextval from dual
  		</selectKey>
		insert into member(
			user_no, user_id, user_pw, user_name, reg_date, upd_date
		)  values (
			#{userNo}, #{userId}, #{userPw}, #{userName}, sysdate, sysdate
		)
 	</insert>
 	
**<!-- 권한 생성 -->**
 	<insert id="createAuth" parameterType="memberAuth">
 		insert into member_auth(
 			user_no, auth
 		)values(
 			#{userNo}, #{auth}
 		)
 	</insert>
 	
 	<select id="list" resultType="memberVO">
 		select
 			user_no, user_id, user_pw, user_name, reg_date
 		from member
 		order by user_no desc
 	</select>
 	
 	<!--  한명의 회원과 join을 통한 해당 회원의 여러개의 역할을 가져와야함 -->
 	<select id="read" parameterType="int" resultMap="memberMap">
 		select
 			m.user_no, user_id, user_pw, user_name, reg_date, upd_date, auth
 		from member m left outer join member_auth a on(m.user_no = a.user_no)
 		where m.user_no = #{userNo}
 	</select>
 	
 	**<!-- 회원 테이블 수정하기 쿼리 -->**
 	<update id="modify" parameterType="memberVO">
 		update member
 		set
 			user_name = #{userName}
 		where user_no = #{userNo}
 	</update>
 	
 	**<!-- 회원의 권한 삭제 -->**
 	<delete id="deleteAuth" parameterType="int">
 		delete from member_auth
 		where user_no = #{userNo}
 	</delete>
 </mapper>

JSP 페이지

• modify.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib uri="<http://java.sun.com/jsp/jstl/core>" prefix="c" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script src="<https://ajax.googleapis.com/ajax/libs/jquery/3.7.0/jquery.min.js>"></script>
</head>
<body>
	<h2>Modify</h2>
	<form action="/crud/member/modify" method="post" id="member">
		<input type="hidden" id="userNo" name="userNo" value="${member.userNo }">
		<table border="1">
			<tr>
				<td>userId</td>
				<td>
					<input type="text" id="userId" name="userId" value="${member.userId }" readonly="readonly">
				</td>
			</tr>
			<tr>
				<td>userName</td>
				<td>
					<input type="text" id="userName" name="userName" value="${member.userName}">
				</td>
			</tr>
			<tr>
				<td>auth-1</td>
				<td>
					<select name="authList[0].auth">
						<option value="" v>===선택해주세요===</option>
						<option value="ROLE_USER" <c:if test="${member.authList[0].auth eq 'ROLE_USER' }">selected</c:if>>사용자</option>
						<option value="ROLE_MEMBER" <c:if test="${member.authList[0].auth eq 'ROLE_MEMBER' }">selected</c:if>>회원</option>
						<option value="ROLE_ADMIN" <c:if test="${member.authList[0].auth eq 'ROLE_ADMIN' }">selected</c:if>>관리자</option>
					</select>				
				</td>
			</tr>
			<tr>
				<td>auth-2</td>
				<td>
					<select name="authList[1].auth">
						<option value="">===선택해주세요===</option>
						<option value="ROLE_USER" <c:if test="${member.authList[1].auth eq 'ROLE_USER' }">selected</c:if>>사용자</option>
						<option value="ROLE_MEMBER" <c:if test="${member.authList[1].auth eq 'ROLE_MEMBER' }">selected</c:if>>회원</option>
						<option value="ROLE_ADMIN" <c:if test="${member.authList[1].auth eq 'ROLE_ADMIN' }">selected</c:if>>관리자</option>
					</select>				
				</td>
			</tr>
			<tr>
				<td>auth-3</td>
				<td>
					<select name="authList[2].auth">
						<option value="">===선택해주세요===</option>
						<option value="ROLE_USER" <c:if test="${member.authList[2].auth eq 'ROLE_USER' }">selected</c:if>>사용자</option>
						<option value="ROLE_MEMBER" <c:if test="${member.authList[2].auth eq 'ROLE_MEMBER' }">selected</c:if>>회원</option>
						<option value="ROLE_ADMIN" <c:if test="${member.authList[2].auth eq 'ROLE_ADMIN' }">selected</c:if>>관리자</option>
					</select>				
				</td>
			</tr>
		</table>
	</form>
	<button type="button" id="btnModify">Modify</button>
	<button type="button" id="btnCancle">Cancle</button>
</body>
<script>
$(function(){
	var member = $("#member");
	var btnModify = $("#btnModify");
	var btnCancle = $("#btnCancle");
	
	// 수정 버튼 클릭 시 이벤트
	btnModify.on("click", function(){
		var userName = $("#userName").val();
		
		if(userName == null || userName == ""){
			alert("이름을 입력해주세요");
			return false;
		}
		
		member.submit();
	})
	
	// 취소 버튼 클릭 시 이벤트
	btnCancle.on("click", function(){
		var userNo = $("#userNo").val();
		location.href = "/crud/member/read?userNo=" + userNo;
	})
})
</script>
</html>

상세보기 폼에서 수정 버튼을 누르면 수정하기 폼으로 잘 이동되는 것을 볼 수 있다.