Spring Boot에서 Mybatis 이용 간단한 예제 만들어보기

# Mybatis로 Oracle DB에 데이터가 들어가는지 확인

 

 

1) [ src/main/java ]  MemberDao.java  

public interface MemberDao {
	
	public void joinMemberDao(String memeberid, String memberpw, String membername);

}

 

 

2) [ src/main/resources] MemberDao.xml

<!DOCTYPE mapper
    PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    
<mapper namespace="com.kmii.member.dao.MemberDao">

	<insert id="joinMemberDao">
		INSERT INTO membertbl(membernum, memberid, memberpw, membername)
		VALUES(memberseq.nextval, #{param1},#{param2},#{param3})
	</insert>
	
</mapper>

 

 

3) [ src/main/java ]  MemberDto

import lombok.AllArgsConstructor;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;

@Getter
@Setter
@AllArgsConstructor
@NoArgsConstructor


public class MemberDto {
	
	private int membernum;
	private String memberid;
	private String memberpw;
	private String membername;
	private String memberdate;

}

 

 

4) [ src/main/java ] MemberController

import org.apache.ibatis.session.SqlSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import com.kmii.member.dao.MemberDao;

import jakarta.servlet.http.HttpServletRequest;

@Controller
public class MemberController {
	
	@Autowired
	SqlSession sqlSession;
	
	@RequestMapping(value="/joinOk")
	public String joinOk(HttpServletRequest request, Model model) {
		String mid = request.getParameter("id");
		String mpw = request.getParameter("pw");
		String mname = request.getParameter("name");
		
		MemberDao memberDao =sqlSession.getMapper(MemberDao.class);
		memberDao.joinMemberDao(mid, mpw, mname);
		
		return "joinOk";
	}
	

}

 

 

 

---

 # join form 처리 따로 하지 않고 데이터 삽입방법

서버 실행 →  주소창에 http://localhost:8888/joinOk?id=tiger&pw=123&name=호랑   (직접 입력해서 데이터 추가)

→ Oracle DB membertbl에 데이터 올라갔는지 확인