Mapper interface

package com.jeungsu.silver.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.jeungsu.silver.vo.SujinVO;

@Mapper
public interface SujinMapper {
	/* 기본적으로 5개 , list, one, insert, update, delete */
	
	public List<SujinVO> sujinList();
	
	// one
	public SujinVO sujinOne(int sujinNum);
	// insert, update, delete를 mutation 메소드라 부름
	public int sujinInsert(SujinVO sujinVO);
	public int sujinUpdate(SujinVO sujinVO);
	public int sujinDelete(SujinVO sujinVO);
}

Mapper.XML

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "<http://mybatis.org/dtd/mybatis-3-mapper.dtd>">
<mapper namespace="com.jeungsu.silver.mapper.SujinMapper">

	<select id="sujinList" resultType="SujinVO">
		select * from sujin where sujin_num = #{sujinNum}
	</select>
	
	<select id="sujinOne">
	
	</select>
	
	<select id="sujinInsert" parameterType="SujinVO">
		insert into sujin(
			sujin_num,
			sujin_name, 
			sujin_content
			)
		values(seq_merong.nextval, #{sujinName}, #{sujinContent})
	</select>
	
	<select id="sujinUpdate" parameterType="SujinVO">
		UPDATE sujin
		SET
		sujin_name = #{sujinName},
		sujin_content = #{sujinContent},
		WHERE
		sujin_num = #{sujinNum}
	</select>
	
	<select id="sujinDelete">
	
	</select>
</mapper>

SujinMapperTest ( 단위테스트 클래스)

package com.jeungsu.silver.mapper;

import static org.junit.jupiter.api.Assertions.assertEquals;

import org.junit.jupiter.api.DisplayName;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import com.jeungsu.silver.vo.SujinVO;

@SpringBootTest
public class SujinmapperTest {

	@Autowired
	private SujinMapper sujinMapper;
	
	@Test
	@DisplayName("수진맵퍼 테스트")
	public void insertTest() {
//		assertEquals("기대값", "실제값");
		
		SujinVO sujinVO = new SujinVO();
		sujinVO.setSujinName("안수진");
		sujinVO.setSujinContent("안내용이다");
		assertEquals(1, sujinMapper.sujinInsert(sujinVO));
		
	}
}

@Test 어노테이션을 달아주면 우클릭하고 Run AS 클릭하면 JUnit Test 버튼이 생기는데 그것을 클릭하자

기대값이랑 실제값이랑 일치하면 이렇게 정상적으로 성공된것을 볼 수 있다!

DB에도 잘 들어와있다

더미 데이터 넣는 용으로도 사용 가능!