[Mybatis] 25. Spring에 Mybatis 적용하기 [spring-db.mxl, mybatis-config.xml, springmvc2/pom.mxl, web.xml]

spring-db.mxl

<?xml version="1.0" encoding="UTF-8" ?>
<!-- /src/main/resources/spring-db.xml -->
<beans xmlns="http://www.springframework.org/schema/beans"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xmlns:p="http://www.springframework.org/schema/p"
  xmlns:context="http://www.springframework.org/schema/context"
  xmlns:aop="http://www.springframework.org/schema/aop"
  xsi:schemaLocation="http://www.springframework.org/schema/beans
   http://www.springframework.org/schema/beans/spring-beans.xsd
   http://www.springframework.org/schema/context
   http://www.springframework.org/schema/context/spring-context.xsd
   http://www.springframework.org/schema/aop
   http://www.springframework.org/schema/aop/spring-aop.xsd">
   
   <!-- Connection pool 객체 -->
   <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
   destroy-method="close">
   		 <property name="driverClass"><value>oracle.jdbc.OracleDriver</value></property>
   		 <property name="jdbcUrl"><value>jdbc:oracle:thin:@localhost:1521:xe</value></property>
   		 <property name="user"><value>kic</value></property>
   		 <property name="password"><value>1234</value></property>
   		 <property name="maxPoolSize"><value>20</value></property> <!-- db접속 최대 연결 객체 갯수 -->
   		 <property name="minPoolSize"><value>3</value></property> <!-- db접속 최소 연결 객체 갯수 -->
   		 <property name="initialPoolSize"><value>5</value></property> <!-- db접속 초기 연결 객체 갯수 -->
   		 <property name="acquireIncrement"><value>5</value></property> <!-- db접속 연결 객체 증가 갯수 -->
   </bean>
   
   <!-- mybatis 관련 설정 -->
   <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
   	<property name="dataSource" ref="dataSource" /> <!-- db 연결 객체 -->
   	<property name="configLocation" value="classpath:mybatis-config.xml" /> <!-- sql 구문 -->
   </bean>
   
   <!-- sql 구문을 실행하기 위한 session 객체 -->
   <bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
   	<constructor-arg ref="sqlSessionFactory" />
   </bean>
   
</beans>

---

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!-- /src/main/resources/mybatis-config.xml -->
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD config 3.0//EN"
 "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
 	<!-- null 허용 -->
	<settings>
  		<setting name="jdbcTypeForNull" value="VARCHAR" />
	</settings>

  <mappers> <!-- sql 구문을 저장하는 장소. sql 구문을 작성한 Interface의 패키지 설정 -->
      <package name="dao.mapper"/>
  </mappers>
</configuration>

---

springmvc2/pom.mxl

<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 http://maven.apache.org/maven-v4_0_0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>kr.kic</groupId>
  <artifactId>springmvc2</artifactId>
  <packaging>war</packaging>
  <version>0.0.1-SNAPSHOT</version>
  <name>springmvc2 Maven Webapp</name>
  <url>http://maven.apache.org</url>
  
  <properties>
  	<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  	<spring.version>4.3.30.RELEASE</spring.version>
  	<spring.version1>5.3.18</spring.version1>
  	<spring.version2>5.2.19.RELEASE</spring.version2>
  	<spring.version3>4.3.30.RELEASE</spring.version3>
  </properties>
  
  <!-- 원격 저장소 설정 : mvnrepository.com : 기본 원격 저장소 이외의 저장소 사용시 설정 -->
  <repositories>
	<repository>
		<id>oracle</id>
		<name>ORACLE JDBC Repository</name>
		<url>http://maven.jahia.org/maven2</url>
	</repository> 
  </repositories>
  
  <dependencies>
  
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>3.8.1</version>
      <scope>test</scope>
    </dependency>
    
    <!-- https://mvnrepository.com/artifact/org.springframework/spring-context -->
	<dependency>
	    <groupId>org.springframework</groupId>
	    <artifactId>spring-context</artifactId>
	    <version>${spring.version}</version>
	</dependency>
	<dependency>
	    <groupId>org.springframework</groupId>
	    <artifactId>spring-web</artifactId>
	    <version>${spring.version}</version>
	</dependency>
	<dependency>
	    <groupId>org.springframework</groupId>
	    <artifactId>spring-webmvc</artifactId>
	    <version>${spring.version}</version>
	</dependency>
	
	<!-- spring db 설정 -->
	<dependency>
	    <groupId>org.springframework</groupId>
	    <artifactId>spring-jdbc</artifactId>
	    <version>${spring.version}</version>
	</dependency>
	
	<!-- 오라클 관련 설정 -->
	<dependency>
		<groupId>com.oracle</groupId>
	    <artifactId>ojdbc5</artifactId>
	    <version>11.2.0.2.0</version>
	</dependency>
	
	<!-- jstl 설정 -->
	<dependency>
		<groupId>jstl</groupId>
	    <artifactId>jstl</artifactId>
	    <version>1.2</version>
	</dependency>

	<!-- 유효성 검증 설정 -->
	<dependency>
		<groupId>javax.validation</groupId>
	    <artifactId>validation-api</artifactId>
	    <version>2.0.1.Final</version>
	</dependency>
	<dependency>
		<groupId>org.hibernate</groupId>
	    <artifactId>hibernate-validator</artifactId>
	    <version>6.1.0.Final</version>
	</dependency>
	
	<!-- 파일 업로드 설정 -->
	<dependency>
		<groupId>commons-fileupload</groupId>
	    <artifactId>commons-fileupload</artifactId>
	    <version>1.3.3</version>
	</dependency>
	<dependency>
		<groupId>commons-beanutils</groupId>
	    <artifactId>commons-beanutils</artifactId>
	    <version>1.9.3</version>
	</dependency>
	<dependency>
		<groupId>commons-digester</groupId>
	    <artifactId>commons-digester</artifactId>
	    <version>2.1</version>
	</dependency>
	
	<!-- AOP 설정 -->
	<dependency>
		<groupId>org.aspectj</groupId>
	    <artifactId>aspectjweaver</artifactId>
	    <version>1.9.6</version>
	</dependency>
	
	<!-- sitemesh 설정 -->
	<!-- http://mvnrepository.com/artifact/org.sitemesh/sitemesh -->
	<dependency>
		<groupId>org.sitemesh</groupId>
	    <artifactId>sitemesh</artifactId>
	    <version>3.0.1</version>
	</dependency>
	
	<!-- Connection Pool 관련 설정 -->
	<!-- spring-db.xml에 Connection 관련 설정-->
	<dependency>
		<groupId>com.mchange</groupId>
	    <artifactId>c3p0</artifactId>
	    <version>0.9.5.3</version>
	</dependency>
	
	<!-- MyBatis 관련 설정-->
	<!-- http://mvnrepository.com/artifact/org.mybatis/mybatis -->
	<dependency>
		<groupId>org.mybatis</groupId>
	    <artifactId>mybatis</artifactId>
	    <version>3.4.6</version>
	</dependency>
	<!-- http://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
	<dependency>
		<groupId>org.mybatis</groupId>
	    <artifactId>mybatis-spring</artifactId>
	    <version>1.3.2</version>
	</dependency>
	
  </dependencies>
  
  <build>
    <finalName>springmvc2</finalName>
    <!-- pom.xml의 첫번째 줄에 maven-war-plugin관련 오류 발생시 코딩 -->
    <plugins>
    	<plugin>
    		<artifactId>maven-war-plugin</artifactId>
    		<version>3.2.2</version>
    	</plugin>
    </plugins>
  </build>
</project>

---

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
		 xmlns="http://xmlns.jcp.org/xml/ns/javaee" 
		 xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee 
							 http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd" 
id="WebApp_ID" version="4.0">
  <!-- springmvc2 : 프로젝트 이름 -->
  <display-name>springmvc2</display-name>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>
<servlet>
   <servlet-name>shop</servlet-name>
   <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
   <init-param>
     <param-name>contextConfigLocation</param-name>
     <param-value>
       classpath:spring-mvc.xml
       classpath:spring-db.xml
     </param-value>
   </init-param>
   <!-- 
   		서버 시작시 서블릿 로드
    -->
   <load-on-startup>1</load-on-startup>
</servlet>
<!-- 
	/ : 모든 요청
 -->
<servlet-mapping>
   <servlet-name>shop</servlet-name>
   <url-pattern>/</url-pattern>
</servlet-mapping> 
<!-- 
	filter란 : request/response 객체를 변경하여 서블릿으로 전달.  
			파라미터 인코딩 기능 : request.setCharacterEncoding("UTF-8")
 -->
<filter>
     <filter-name>CharacterEncoding</filter-name>
     <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
     <init-param>
       <param-name>encoding</param-name>
       <param-value>UTF-8</param-value>
     </init-param>
</filter>
<filter-mapping>
     <filter-name>CharacterEncoding</filter-name>
     <url-pattern>/*</url-pattern>
</filter-mapping>
</web-app>