인프런 나프_2탄 21일차 : Spring WEB MVC_02버전_03 Mapper 인터페이스와 @(어노테이션)이용한 CRUD

# Spring WEB MVC_02버전_03 Mapper 인터페이스와 @(어노테이션)이용한 CRUD

## Mapper 인터페이스와 어노테이션을 이용한 CRUD

• 기존 MemberMapper.xml 제거.
• 어노테이션에 SQL 문을 작성하여 작업.

package kr.bit.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import kr.bit.model.MemberVO;

public interface MemberMapper {
	@Select("SELECT * FROM member")
	public List<MemberVO> memberList();			// SQL id="memeberList"
	
    @Insert("INSERT INTO member(id, pass, name, age, email, phone) \r\n" + 
			"        values(#{id}, #{pass}, #{name}, #{age}, #{email}, #{phone})")
	public int memberInsert(MemberVO vo);		// SQL id="memberInsert"
	
    @Delete("DELETE FROM member WHERE num = #{num}")
	public int memberDelete(int num);			// SQL id="memberDelete"
	
    @Select("SELECT * FROM member WHERE num = #{num}")
	public MemberVO memberContent(int num);		// SQL id="memberContent"
	
    @Update("UPDATE member \r\n" + 
			"        SET age = #{age}, email = #{email}, phone = #{phone} where num = #{num}")
	public int memberUpdate(MemberVO vo);		// SQL id="memberUpdate"
}