본문 바로가기
코딩도전기/Spring

CODO Day40_Spring(MyBatis)

by 코도꼬마 2023. 3. 28.

spring의 특징

1. 제어역행(I.O.C : Inversion Of Control) 지원하여 사용자가 직접 코드를 호출하지 않고  스프링이 호출해줌
2. 의존성 주입(D.I : Dependency Injection)을 지원하여 클래스들 끼리 직접 연결하지 않고 중간에 매개체(mapper(interface))를 줌으로써 느슨한 결합을 유지
3. Spring Framework에서 객체자원을 효율적으로 관리
4. AOP(Aspect Orient Programming)을 지원(AOP에서 자세히 설명 할 예정)

 

Sequence Diagram(흐름도) - 동기방식

Written by zer0box

 

 

Mybatis

  • 자바 퍼시스턴스 프레임워크 중 하나
    • 퍼시스턴스(Persitence) - 애플리케이션을 종료 후 실행 시 이전에 저장한 데이터를 다시 불러 올 수 있는 기술
  • XML(mapper)이나 annotation을 사용하여 저장 프로시저나 SQL문으로 객체들을 연결
  • MyBatis는 DB C.R.U.D를 다루는 클래스 및 설정파일들을 가지고 있어 자체 처리가 가능
  • MyBatis를 활용하면 JDBC 프로그래밍을 쉽게 해결할 수 있음

 

MyBatis를 이용한 CRUD(Create / Read / Update / Delete) 구현

  • pom.xml
    • MyBatis를 활용하기 위해 라이브러리를 넣어주어야함
    • spring-jdbc.jar / mybatis.jar / mybatis-spring.jar

 

  • servlet-context.xml
    • DB 접속정보와 Mapper 설정, SqlSessionTemplate 사용을 위한 설정도 추가해야 함

 

  • Mapper
    • SQL을 표현한 Mapper.xml과 이를 연결해 줄 Interface 구현

 

  • pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/maven-v4_0_0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>kr.co</groupId>
	<artifactId>gudi</artifactId>
	<name>04_mybatis</name>
	<packaging>war</packaging>
	<version>1.0.0-BUILD-SNAPSHOT</version>
	<properties>
		<java-version>1.8</java-version>
		<org.springframework-version>4.3.14.RELEASE</org.springframework-version>
		<org.aspectj-version>1.6.10</org.aspectj-version>
		<org.slf4j-version>1.6.6</org.slf4j-version>
	</properties>
	<dependencies>
		<!-- Spring -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
			<version>${org.springframework-version}</version>
			<exclusions>
				<!-- Exclude Commons Logging in favor of SLF4j -->
				<exclusion>
					<groupId>commons-logging</groupId>
					<artifactId>commons-logging</artifactId>
				</exclusion>
			</exclusions>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-webmvc</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>


		<!-- 필요한 라이브러리 --><!-- 라이브러리들 사이의 조합도 중요 -->
		<!-- jdbc -->
		<!-- https://mvnrepository.com/artifact/org.mariadb.jdbc/mariadb-java-client -->
		<dependency>
			<groupId>org.mariadb.jdbc</groupId>
			<artifactId>mariadb-java-client</artifactId>
			<version>2.7.2</version>
		</dependency>

		<!-- common-dbcp -->
		<!-- https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp -->
		<dependency>
			<groupId>commons-dbcp</groupId>
			<artifactId>commons-dbcp</artifactId>
			<version>1.4</version>
		</dependency>

		<!-- spring-jdbc --> <!-- spring 버전이랑 맞춰야함 -->
		<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>4.3.14.RELEASE</version>
		</dependency>

		<!-- mybatis -->
		<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.4.6</version>
		</dependency>

		<!-- mybatis-spring -->
		<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.3.2</version>
		</dependency>


		<!-- AspectJ -->
		<dependency>
			<groupId>org.aspectj</groupId>
			<artifactId>aspectjrt</artifactId>
			<version>${org.aspectj-version}</version>
		</dependency>

		<!-- Logging -->
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-api</artifactId>
			<version>${org.slf4j-version}</version>
		</dependency>
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>jcl-over-slf4j</artifactId>
			<version>${org.slf4j-version}</version>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-log4j12</artifactId>
			<version>${org.slf4j-version}</version>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>log4j</groupId>
			<artifactId>log4j</artifactId>
			<version>1.2.15</version>
			<exclusions>
				<exclusion>
					<groupId>javax.mail</groupId>
					<artifactId>mail</artifactId>
				</exclusion>
				<exclusion>
					<groupId>javax.jms</groupId>
					<artifactId>jms</artifactId>
				</exclusion>
				<exclusion>
					<groupId>com.sun.jdmk</groupId>
					<artifactId>jmxtools</artifactId>
				</exclusion>
				<exclusion>
					<groupId>com.sun.jmx</groupId>
					<artifactId>jmxri</artifactId>
				</exclusion>
			</exclusions>
			<scope>runtime</scope>
		</dependency>

		<!-- @Inject -->
		<dependency>
			<groupId>javax.inject</groupId>
			<artifactId>javax.inject</artifactId>
			<version>1</version>
		</dependency>

		<!-- Servlet -->
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>servlet-api</artifactId>
			<version>2.5</version>
			<scope>provided</scope>
		</dependency>
		<dependency>
			<groupId>javax.servlet.jsp</groupId>
			<artifactId>jsp-api</artifactId>
			<version>2.1</version>
			<scope>provided</scope>
		</dependency>
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>jstl</artifactId>
			<version>1.2</version>
		</dependency>

		<!-- Test -->
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>4.7</version>
			<scope>test</scope>
		</dependency>
	</dependencies>
	<build>
		<plugins>
			<plugin>
				<artifactId>maven-eclipse-plugin</artifactId>
				<version>2.9</version>
				<configuration>
					<additionalProjectnatures>
						<projectnature>org.springframework.ide.eclipse.core.springnature</projectnature>
					</additionalProjectnatures>
					<additionalBuildcommands>
						<buildcommand>org.springframework.ide.eclipse.core.springbuilder</buildcommand>
					</additionalBuildcommands>
					<downloadSources>true</downloadSources>
					<downloadJavadocs>true</downloadJavadocs>
				</configuration>
			</plugin>
			<plugin>
				<groupId>org.apache.maven.plugins</groupId>
				<artifactId>maven-compiler-plugin</artifactId>
				<version>3.7.0</version><!-- version up -->
				<configuration>
					<source>1.8</source><!-- version up -->
					<target>1.8</target><!-- version up -->
					<compilerArgument>-Xlint:all</compilerArgument>
					<showWarnings>true</showWarnings>
					<showDeprecation>true</showDeprecation>
				</configuration>
			</plugin>
			<plugin>
				<groupId>org.codehaus.mojo</groupId>
				<artifactId>exec-maven-plugin</artifactId>
				<version>1.2.1</version>
				<configuration>
					<mainClass>org.test.int1.Main</mainClass>
				</configuration>
			</plugin>
		</plugins>
	</build>
</project>

 

  • HomeController
package kr.co.gudi.controller;

import java.text.DateFormat;
import java.util.Date;
import java.util.HashMap;
import java.util.Locale;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
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 org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;

import kr.co.gudi.service.HomeService;

@Controller
public class HomeController {
   
   private static final Logger logger = LoggerFactory.getLogger(HomeController.class);
   
   // 객체화가 필요 없다. 단, @Service 즉 annotation이 꼭 붙어있어야만 동작 가능하다. 
   @Autowired HomeService service;
   
   @RequestMapping(value = "/", method = RequestMethod.GET)
   public String home(Model model) {
      logger.info("home.jsp 이동");
      return "home";
   }
   
   @RequestMapping(value="/join", method = RequestMethod.POST)
   public String join(Model model,@RequestParam HashMap<String, String> params) {
      logger.info("params : " + params);
      int row = service.join(params);
      logger.info("회원가입 결과 : " + row);      
      return "home";
   }
}

 

  • HomeSercive
package kr.co.gudi.service;

import java.util.HashMap;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import kr.co.gudi.controller.HomeController;
import kr.co.gudi.dao.MemberDAO;

@Service
public class HomeService {
   
	@Autowired MemberDAO dao;
	
   private static final Logger logger = LoggerFactory.getLogger(HomeService.class);
   
   public int join(HashMap<String, String> params) {
      logger.info("Service 도착 : " + params);
      int row = dao.join(params);
      logger.info("update row : "+row);
      return row;
   }
}

 

  • home.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script src="https://code.jquery.com/jquery-3.6.3.min.js"></script>
<style></style>
</head>
<body>
   <form action="join" method="post">
      <p>ID : <input type="text" name="id"/></p>
      <p>PW : <input type="password" name="pw"/></p>
      <p>이름 : <input type="text" name="name"/></p>
      <p>나이 : <input type="text" name="age"/></p>
      <p>성별 : <input type="text" name="gender"/></p>
      <p>Email : <input type="email" name="email"/></p>
      <button>회원가입</button>
   </form>
   <h3>${msg}</h3>   
</body>
<script></script>
</html>

 

  • servlet-context.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans:beans xmlns="http://www.springframework.org/schema/mvc"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:beans="http://www.springframework.org/schema/beans"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
	xsi:schemaLocation="http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd
		http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd
		http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd
		http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">

	<!-- 서버에 첫 요청이 들어오면 읽는 파일 -->
	
	<!-- @Controller를 인식하는 설정 -->
	<annotation-driven />

	<!-- 이미지나 CSS를 불러올 때 사용할 설정(나중에 자세히 볼 것) -->
	<resources mapping="/resources/**" location="/resources/" />

	<!-- @Controllers to .jsp resources in the /WEB-INF/views directory 
	: controller에서 문자열로 반환하면 해당 jsp로 찾아가는 설정-->
	<!-- "home" >> /WEB-INF/views/home.jsp -->
	<beans:bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<beans:property name="prefix" value="/WEB-INF/views/" />
		<beans:property name="suffix" value=".jsp" />
	</beans:bean>
	
	<!-- 우리가 사용하는 어노테이션 인식 범위 -->
	<context:component-scan base-package="kr.co.gudi" />
	
    
	<!-- DataSource 작성(접속정보) -->
	<beans:bean name="datasource" class="org.apache.commons.dbcp.BasicDataSource">
		<beans:property name="driverClassName" value="org.mariadb.jdbc.Driver"/>
		<beans:property name="url" value="jdbc:mariadb://localhost:3306/mydb"/>
		<beans:property name="username" value="web_user"/>
		<beans:property name="password" value="pass"/>
	</beans:bean>
	
	<!-- mybatis 설정 -->
	<beans:bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 연결할 DB 정보 -->
		<beans:property name="dataSource" ref="datasource"></beans:property>		
		<!-- 쿼리문이 있을 장소 -->
		<beans:property name="mapperLocations" value="classpath:kr/co/gudi/dao/*.xml"/>
	</beans:bean>
	
	<!-- mybatis를 별다른 코드 없이 사용할 수 있는 어노테이션 등록 -->
	<mybatis-spring:scan base-package="kr.co.gudi.dao"/>
		
	
</beans:beans>

 

  • member_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">
<!-- xml을 java에서 쓰기 위해 연결되는 interface가 필요 -->
<mapper namespace="kr.co.gudi.dao.MemberDAO">
	<!-- id="연결할 인터페이스 메서드명" -->
	<!-- connection을 열고 PreparedStatement >> ? 대응 >> 쿼리실행 >> 자원반납 -->
	<insert id="join" parameterType="hashmap">
		INSERT INTO member(id,pw,name,age,gender,email) 
			VALUES(#{id},#{pw},#{name},#{age},#{gender},#{email})
	</insert>
</mapper>

 

  • MemberDAO(interface)
package kr.co.gudi.dao;

import java.util.HashMap;

public interface MemberDAO {
	int join(HashMap<String, String> params);
}

 

저작자표시 비영리 변경금지

'코딩도전기 > Spring' 카테고리의 다른 글

CODO Day44_Spring(PhotoBoard)  (0) 2023.04.04
CODO Day43_Spring(FileService)  (0) 2023.04.03
CODO Day42_Spring(BoardApp)  (0) 2023.03.31
CODO Day41_Spring(MemberApp)  (0) 2023.03.30
CODO Day39_Spring(DB 연결)  (0) 2023.03.28

관련글

티스토리툴바