21.04.13 TIL (D+64 MyBatis, Spring)

MyBatis Framework

 개발자가 지정한 SQL, 저장프로시저 그리고 몇 가지 고급 매핑을 지원하는 퍼시스턴스 프레임워크

 

 

MyBatis 사용 이유

 

1. 쉬운 접근성과 코드의 간결함

   - JDBC의 모든 기능을 MyBatis가 대부분 제공한다.

   - 복잡한 JDBC 코드를 걷어내며 깔끔한 소스코드를 유지할 수 있다.

   - 수동적인 파라미터 설정과 쿼리 결과에 대한 맵핑 구문을 제거할 수 있다.

 

2. SQL 문과 프로그래밍 코드의 분리

   - SQL에 변경이 있을 때마다 자바 코드를 수정하거나 컴파일하지 않아도 된다.

 

3. 다양한 프로그래밍 언어로 구현 가능

 

 

 

Spring에서 MyBatis 세팅 방법

 

 

1. lib 폴더에 mybatis-3.4.6.jar(mvnrepository.com/ 에서 mybatis 검색 ) 와 ojdbc6.jar 넣기 

 (인식 안되면 Build Path에서 직접 jar 파일 add)

2. src/main/java에 패키지 생성 후 config.xml, MyBatisMapper.xml 파일 생성

 

 

config.xml

 

DB 정보 설정을 해준다.

(Spring 설정은 이렇게 안하고 아래에 있으니 이부분은 이해만하고 넘어가자.)

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-config.dtd">	<!-- DB정보, 설정 -->

<configuration>
	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC"/>
			<dataSource type="POOLED">
				<property name="driver" value="oracle.jdbc.driver.OracleDriver"/>
				<property name="url" value="jdbc:oracle:thin:@192.168.0.231:1521:xe"/>
				<property name="username" value="hr"/>
				<property name="password" value="hr"/>			
			</dataSource>
		</environment>
	</environments>
	
	<mappers>
		<mapper resource="mybatis/MyBatisMapper.xml"/>
	</mappers>
    
</configuration>

 

 

 

MyBatisMapper.xml

 

Mapper XML 파일에서 Query문을 작성한다.

<?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">	<!-- Query문 -->
  
<mapper namespace="mybatis.MyBatisMapper">

<!-- 
	형식
	
	<insert, delete, select, update
		id = "외부에서 호출할 문자열"
		parameterType = "object"
		resultType = "object">
	
	쿼리 #{ 외부로부터 들어오는 값} - core tag
		${ 숫자 }
		
	</insert, delete, select, update>

 -->

<!-- insert, update, delete 쿼리문 -->

	<insert id="add" parameterType="dto.MemberDto">
		INSERT INTO MEMBERDTO(ID, PWD, EMAIL)
		VALUES ( #{ id }, #{ pwd }, #{ email } )
	</insert>
	
	
	<update id="updateData" parameterType="dto.MemberDto">
		UPDATE MEMBERDTO
		SET EMAIL = #{email}
		WHERE ID = #{id}
	</update>
	
	
	<delete id="deleteData" parameterType="dto.MemberDto">
		DELETE FROM MEMBERDTO
		WHERE ID = #{id}
	</delete>


<!-- select 한개 -->

	<select id="find" parameterType="java.lang.String" resultType="dto.MemberDto">
		SELECT *
		FROM MEMBERDTO
		WHERE ID=#{id}
	</select>
	
	
<!-- select 여러개 -->

	<select id="allData" parameterType="java.lang.String" resultType="dto.MemberDto">
		SELECT *
		FROM MEMBERDTO
	</select>
    
    
<!-- Bbs Search -->
	<select id="bbsSearch" parameterType="dto.BbsParam" resultType="dto.BbsDto">
		SELECT *
		FROM BBS
		WHERE 1=1
		<if test="s_category == 'title'">
			AND TITLE LIKE '%'||#{keyword}||'%'
		</if>	
		<if test="s_category == 'content'">
			AND CONTENT LIKE '%'||#{keyword}||'%'
		</if>	
		<if test="s_category == 'id'">
			AND ID=#{keyword}
		</if>	
	</select>



<!-- Bbs Search (choose)-->
	<select id="bbsSearchChoose" parameterType="dto.BbsParam" resultType="dto.BbsDto">
		SELECT *
		FROM BBS
		WHERE 1=1
		<choose>
			<when test="s_category == 'title'">
				AND TITLE LIKE '%'||#{keyword}||'%'
			</when>
			<when test="s_category == 'content'">
				AND CONTENT LIKE '%'||#{keyword}||'%'
			</when>	
			<when test="s_category == 'id'">
				AND ID=#{keyword}
			</when>	
			<otherwise>
				AND 1=1
			</otherwise>
		</choose>
	</select>	


</mapper>

 

 

 

MainClass.java

 

Java파일에서 DTO를 사용해 DB 접근

package main;

import java.io.InputStream;
import java.util.List;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import dto.BbsDto;
import dto.BbsParam;
import dto.MemberDto;


public class MainClass {

	public static void main(String[] args) throws Exception {
		
		
		// mybatis 설정파일을 읽어들인다
		InputStream is = Resources.getResourceAsStream("mybatis/config.xml");
		
		// SqlSessionFactory 객체를 취득
		SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
		
		// SqlSession 객체를 취득 
		SqlSession session = factory.openSession();	// session <- 실세
		
		
        	//INSERT
		MemberDto dto = new MemberDto("ddd", "444", "d1@d.com");
		
		int n = session.insert("add", dto);
		if(n > 0) {
			session.commit();
			System.out.println("추가 성공!");
		}else {
			session.rollback();
			System.out.println("추가 실패");
		}
		
		
		
		//UPDATE
		MemberDto dto = new MemberDto ("aaa", "111", "a1@a");
		
		int n = session.update("updateData", dto);
		
		if(n > 0) {
			session.commit();
			System.out.println("수정 성공!");
		}else {
			session.rollback();
			System.out.println("수정 실패");
		}
		
		
		//DELETE 
		String id = "ddd";
		
		int n = session.delete("deleteData", id);
		
		if(n > 0) {
			session.commit();
			System.out.println("삭제 성공!");
		}else {
			session.rollback();
			System.out.println("삭제 실패");
		}
		
		
		//SELECT 1개
		String id = "ccc";
		MemberDto dto = session.selectOne("find", id);
		System.out.println(dto.toString());
		
		
		
		//SELECT 여러개
		List<MemberDto> list = session.selectList("allData");
		for(MemberDto m : list) {
			System.out.println(m.toString());
		}
		
		
		//BBS 검색조건 SELECT
		BbsParam param = new BbsParam("title", "제목");
		List<BbsDto> list = session.selectList("bbsSearch", param);
		for (BbsDto bbs : list) {
			System.out.println(bbs.toString());
		}
		

	}

}

 

 

 

동적 쿼리

 

- if

JSTL core 태그와 비슷하게 생겼다.

<if test="s_category == 'title'">
	AND TITLE LIKE '%'||#{keyword}||'%'
</if>

 

- choose, when, otherwise

choose 태그 안에 when태그와 otherwise태그를 쓴다.

when 태그는 if, else if 역할

otherwise는 else 역할을 한다.

<select id="bbsSearchChoose" parameterType="dto.BbsParam" resultType="dto.BbsDto">
	SELECT *
	FROM BBS
	WHERE 1=1
	<choose>
		<when test="s_category == 'title'">
			AND TITLE LIKE '%'||#{keyword}||'%'
		</when>
		<when test="s_category == 'content'">
			AND CONTENT LIKE '%'||#{keyword}||'%'
		</when>	
		<when test="s_category == 'id'">
			AND ID=#{keyword}
		</when>	
		<otherwise>
			AND 1=1
		</otherwise>
	</choose>
</select>

 

 

---

- DB 접속을 위한 Spring 세팅 방법

 

우선 그림을 통해 전체적인 구조를 알아보자

 

 

pom.xml

양식 복붙해서 쓰자.

 

<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/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>sample2</groupId>
  <artifactId>sample2</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>war</packaging>
  <build>
    <plugins>
      <plugin>
        <artifactId>maven-compiler-plugin</artifactId>
        <version>3.8.1</version>
        <configuration>
          <release>15</release>
        </configuration>
      </plugin>
      <plugin>
        <artifactId>maven-war-plugin</artifactId>
        <version>3.2.3</version>
      </plugin>
    </plugins>
  </build>
  
  <dependencies>
  	<dependency>
	    <groupId>org.springframework</groupId>
	    <artifactId>spring-webmvc</artifactId>
	    <version>5.3.3</version>
	</dependency>
	
	<!-- https://mvnrepository.com/artifact/log4j/log4j -->
	<dependency>
	    <groupId>log4j</groupId>
	    <artifactId>log4j</artifactId>
	    <version>1.2.17</version>
	</dependency>
	
	<!-- https://mvnrepository.com/artifact/org.slf4j/slf4j-simple -->
	<dependency>
	    <groupId>org.slf4j</groupId>
	    <artifactId>slf4j-simple</artifactId>
	    <version>1.7.25</version>
	</dependency>
	
	<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>
	
	<!-- 런타임에 동적으로 자바 클래스의 프록시(대리(인))를 생성해주는 기능을 제공한다 -->
	<dependency>
	    <groupId>cglib</groupId>		
	    <artifactId>cglib</artifactId>
	    <version>3.3.0</version>
	</dependency>
	<dependency>
	    <groupId>commons-digester</groupId>
	    <artifactId>commons-digester</artifactId>
	    <version>1.8</version>
	</dependency>
	
	<dependency>
  		<groupId>commons-logging</groupId>
  		<artifactId>commons-logging</artifactId>
  		<version>1.1.3</version>
  	</dependency>
  	
  	<!-- Ajax 사용 설정[jackson] -->
  	<dependency>
  		<groupId>org.codehaus.jackson</groupId>	
  		<artifactId>jackson-core-asl</artifactId>
  		<version>1.9.12</version>
  	</dependency>
  	<dependency>
  		<groupId>org.codehaus.jackson</groupId>
  		<artifactId>jackson-mapper-asl</artifactId>
  		<version>1.9.12</version>
  	</dependency>
  	
  	<!-- 의존성을 추가 --> 
  	<dependency>
  		<groupId>javax.inject</groupId>
  		<artifactId>javax.inject</artifactId>
  		<version>1</version>
  	</dependency>
  	
  	<!-- JCL(자카르타 커먼스 로깅)을 사용 --> 	
  	<dependency>
  		<groupId>org.slf4j</groupId>
  		<artifactId>jcl-over-slf4j</artifactId>
  		<version>1.7.30</version>
  	</dependency>

	<!-- XML 파싱 -->
  	<dependency>
	    <groupId>jdom</groupId>
	    <artifactId>jdom</artifactId>
	    <version>1.0</version>
	</dependency>
	
	<!-- 마이 바티스 스프링 사용시 -->
  	<dependency>
	    <groupId>org.mybatis</groupId>
	    <artifactId>mybatis-spring</artifactId>
	    <version>2.0.3</version>
	</dependency>
	
  	<dependency>
	    <groupId>org.mybatis</groupId>
	    <artifactId>mybatis</artifactId>
	    <version>3.5.3</version>
	</dependency>
	
	<!-- 마이 SQL 사용시 -->	
  	<dependency>
	    <groupId>mysql</groupId>
	    <artifactId>mysql-connector-java</artifactId>
	    <version>8.0.18</version>
	</dependency>
	
	<!-- XML 파싱 -->
  	<dependency>
	    <groupId>org.jdom</groupId>
	    <artifactId>jdom</artifactId>
	    <version>2.0.1</version>
	</dependency>

	<!-- SLF4J API를 사용하도록 -->
  	<dependency>
  		<groupId>org.slf4j</groupId>
  		<artifactId>slf4j-api</artifactId>
  		<version>1.7.30</version>
  	</dependency>

	<!-- log4j -->
  	<!-- <dependency>
  		<groupId>ant</groupId>
  		<artifactId>ant-apache-log4j</artifactId>
  		<version>1.9.4</version>
  	</dependency> -->
  	
  	<dependency>
	    <groupId>commons-dbcp</groupId>
	    <artifactId>commons-dbcp</artifactId>
	    <version>1.4</version>
	</dependency>
  	
  	<!-- Map을 Bean객체로 바꾸어주는 클래스 -->
  	<dependency>
  		<groupId>commons-beanutils</groupId>
  		<artifactId>commons-beanutils-core</artifactId>
  		<version>1.8.2</version>
  	</dependency>
  	
  	<!-- DBCP : DB Connection Pool 사용 --> 
  	<dependency>
  		<groupId>com.kenai.nbpwr</groupId>
  		<artifactId>org-apache-commons-dbcp</artifactId>
  		<version>1.2.2-201002241055</version>
  		<type>nbm</type>
  	</dependency>
  	
  	<!-- IO 기능 개발을 지원하는 유틸리티 라이브러리  다운안됨 -->
  	<dependency>
  		<groupId>org.apache.commons</groupId>
  		<artifactId>commons-io</artifactId>
  		<version>1.3.2</version>
  	</dependency>
  	
  	<dependency>
  		<groupId>org.apache.commons</groupId>
  		<artifactId>commons-lang3</artifactId>
  		<version>3.9</version>
  	</dependency>
  	
  	<dependency>
  		<groupId>org.apache.commons</groupId>
  		<artifactId>commons-pool2</artifactId>
  		<version>2.8.0</version>
  	</dependency>
  	<dependency>
  		<groupId>org.slf4j</groupId>
  		<artifactId>slf4j-log4j12</artifactId>
  		<version>1.7.30</version>
  	</dependency>
  	
  	<!-- spring -->
	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-aop</artifactId>
  		<version>5.3.3</version>
  	</dependency>
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-beans</artifactId>
  		<version>5.3.3</version>
  	</dependency>
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-context</artifactId>
  		<version>5.3.3</version>
  	</dependency>  	
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-context-support</artifactId>
  		<version>5.3.3</version>
  	</dependency>  	
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-core</artifactId>
  		<version>5.3.3</version>
  	</dependency>
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-expression</artifactId>
  		<version>5.3.3</version>
  	</dependency>
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-jdbc</artifactId>
  		<version>5.3.3</version>
  	</dependency>
  	
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-orm</artifactId>
  		<version>5.3.3</version>
  	</dependency>
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-test</artifactId>
  		<version>5.3.3</version>
  	</dependency>
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-tx</artifactId>
  		<version>5.3.3</version>
  	</dependency>
  	<dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-web</artifactId>
  		<version>5.3.3</version>
  	</dependency>
  	
  	<!-- Java용 json 라이브러리(XML/YAM/CSV) data-processing 툴 -->
  	<dependency>
	    <groupId>com.fasterxml.jackson.core</groupId>
	    <artifactId>jackson-core</artifactId>
	    <version>2.10.1</version>
	</dependency>
	
	<dependency>
	    <groupId>com.fasterxml.jackson.core</groupId>
	    <artifactId>jackson-databind</artifactId>
	    <version>2.10.1</version>
	</dependency>
		
	
	
	<dependency>
	    <groupId>org.aspectj</groupId>
	    <artifactId>aspectjweaver</artifactId>
	    <version>1.9.4</version>
	</dependency>
	
	<dependency>
	    <groupId>org.aspectj</groupId>
	    <artifactId>aspectjrt</artifactId>
	    <version>1.9.4</version>
	</dependency>
	
	<!-- oracle -->
	<dependency>
	    <groupId>com.oracle.database.jdbc</groupId>
	    <artifactId>ojdbc6</artifactId>
	    <version>11.2.0.4</version>
	</dependency>
	
	
	<dependency>
	    <groupId>org.json</groupId>
	    <artifactId>json</artifactId>
	    <version>20190722</version>
	</dependency>
	
	
  </dependencies>
  
  <!-- ojdbc6 와 함께 추가 -->
  <repositories>
  	<repository>
		<id>codelds</id>		
		<url>https://code.lds.org/nexus/content/groups/main-repo</url>
	</repository>
  </repositories> 
  
</project>

 

 

 

WEB-INF/spring/applicationContext.xml

필요한 부분 가져다가 쓰기

jdbc.properties 파일을 무조건 만들어줘야 한다.

'MyBatis setting'에서 'sqls' 패키지의 xml 확장자를 불러오므로 그곳에 쿼리문을 작성한다.

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:context="http://www.springframework.org/schema/context"
	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-4.3.xsd">
		
	
	<!-- Database 설정 -->
	
	<!-- db 초기화 파일의 위치 / 파일 -->
	<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="locations">
			<list>
				<value>classpath:properties/jdbc.properties</value>
			</list>
		</property>
	</bean>
	
	
	
	<!-- DBMS() -->
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
		<property name="driverClassName" value="${jdbc.driverClassName}"/>
		<property name="url" value="${jdbc.url}"/>
		<property name="username" value="${jdbc.username}"/>
		<property name="password" value="${jdbc.password}"/>
		<property name="initialSize" value="${jdbc.initialSize}"/>
		<property name="maxActive" value="${jdbc.maxActive}"/>
		<property name="minIdle" value="${jdbc.initialSize}"/>
		<property name="maxWait" value="3000"/>
		<property name="poolPreparedStatements" value="true"/>
		<property name="maxOpenPreparedStatements" value="50"/>
	</bean>
	
	<!-- MyBatis setting -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource"/>
		<property name="mapperLocations" value="classpath:sqls/*.xml"/>
	</bean>
	
	
	<!-- sqlSession 취득 -->
	<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
		<constructor-arg index="0" ref="sqlSessionFactory"/>
		<constructor-arg index="1" value="SIMPLE"/>
	</bean>
	
	<!-- jdbc 설정 (Spring Transaction Manager)-->
	<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource"/>
	</bean>
	
		

</beans>

 

 

jdbc.properties

properties 패키지 안에 생성

오라클 세팅에 필요한 정보를 담는다.

# oracle setting

jdbc.driverClassName = oracle.jdbc.driver.OracleDriver
jdbc.url = jdbc:oracle:thin:@192.168.0.231:1521:xe
jdbc.username = hr
jdbc.password = hr
jdbc.initialSize = 5
jdbc.maxActive = 20

 

 

sqls 패키지의 member.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="Member">
	<select id="allMember" resultType="bit.com.a.dto.MemberDto">
		SELECT * FROM MEMBER
	</select>
</mapper>

 

 

 

 

 

WEB-INF/spring/servlet-context.xml

 

패키지명만 맞춰서 나머지는 재사용

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
		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-4.3.xsd">
		
		<context:annotation-config/>
		
		<bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
			<property name="prefix" value="/WEB-INF/views/"/>
			<property name="suffix" value=".jsp" />
		</bean>
		
		<context:component-scan base-package="bit.com.a"/>
        					<!-- 여기 패키지명만 수정해서 사용 -->
		
		
		<!-- Ajax 주석문을 사용허가 -->
		<mvc:annotation-driven/>
		
		<!-- spring에서 처리할 수 없는 요청은 tomcat에 위임 -->
		<mvc:default-servlet-handler/>
		
		
</beans>

 

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_3_1.xsd" version="3.1">
  <display-name>sample4</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>dispatcher</servlet-name>
  	<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  	
  	<init-param>
  		<param-name>contextConfigLocation</param-name>
  		<param-value>/WEB-INF/spring/servlet-context.xml</param-value>
  	</init-param>
  	
  	<load-on-startup>1</load-on-startup>
  </servlet>
  
  
  <servlet-mapping>
  	<servlet-name>dispatcher</servlet-name>
  	<url-pattern>*.do</url-pattern>	<!-- .do 로 끝나는 링크만 controller 이동 --> 
  </servlet-mapping>
  
  
  <!-- DB 관련 -->

  
 <context-param>
  	<param-name>contextConfigLocation</param-name>
  	<param-value>
  		/WEB-INF/spring/applicationContext.xml
  	</param-value>
  </context-param>
  
  <listener>
  	<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  
  
   
  
  <!-- filter -->
  <!-- 한글설정 -->
  <filter>
  	<filter-name>encodingFilter</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>
  	
  	<init-param>
  		<param-name>forceEncoding</param-name>
  		<param-value>true</param-value>
  	</init-param>
  	
  </filter>
  
  
  <filter-mapping>
  	<filter-name>encodingFilter</filter-name>
  	<url-pattern>/*</url-pattern>	<!-- '/*' 모든 경로에 체크 -->
  </filter-mapping>
  
</web-app>

 

 

 

Controller 예제 양식

컨트롤러를 사용하는 이유 

 

aibees.github.io/Why-Use-Service/

다음 글 참고하자. 이해가게 정리를 잘 해주셨다.

 

 

 

어노테이션에 유의하자. 

 

@Autowired : 의존객체 자동 주입 (Automatic Dependency Injection) 

      - 필요한 의존 객체의 “타입"에 해당하는 빈을 찾아 주입.

 

package bit.com.a.controller;

import java.util.Date;
import java.util.List;

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 bit.com.a.dto.MemberDto;
import bit.com.a.service.MemberService;

@Controller
public class MemberController {
	
	private static Logger logger = LoggerFactory.getLogger(MemberController.class);

	
	@Autowired
	MemberService memberService;
	
	
	@RequestMapping(value = "allMember.do", method = RequestMethod.GET)
	public String allmember(Model model) {
		logger.info("MemberController allmember " +new Date());
		List<MemberDto> list = memberService.allMember();
		
		model.addAttribute("memlist", list);


		return "allMember";
		
	}
	
}

 

Service 예제

 

Service 인터페이스

package bit.com.a.service;

import java.util.List;

import bit.com.a.dto.MemberDto;

public interface MemberService {

	List<MemberDto> allMember();
	
}

 

Service 클래스

package bit.com.a.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import bit.com.a.dao.MemberDao;
import bit.com.a.dto.MemberDto;
import bit.com.a.service.MemberService;

@Service
public class MemberServiceImpl implements MemberService{

	
	@Autowired // new 자동 생성
	MemberDao memberDao;
	
	
	@Override
	public List<MemberDto> allMember() {
		return memberDao.allMember();
		
	}

}

 

Dao(Repository) 예제

 

Dao(Repository) 인터페이스

package bit.com.a.dao;

import java.util.List;

import bit.com.a.dto.MemberDto;

public interface MemberDao {
	
	List<MemberDto> allMember();	
	
}

 

 

Dao(Repository) 클래스

 

package bit.com.a.dao.impl;

import java.util.List;

import org.apache.ibatis.session.SqlSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

import bit.com.a.dao.MemberDao;
import bit.com.a.dto.MemberDto;

/* DB와 대화하는 Class */
@Repository
public class MemberDaoImpl implements MemberDao{

	
	@Autowired	// new 자동 생성 : Dependency Injection .  필요한 의존 객체의 “타입"에 해당하는 빈을 찾아 주입한다.
	SqlSession sqlSession;
	
	String namespace = "Member.";
	
	
	
	/* member.xml 에 있는 'SELECT * FROM MEMBER' 쿼리문을 불러옴 */
	@Override
	public List<MemberDto> allMember() {
		List<MemberDto> list = sqlSession.selectList(namespace + "allMember");
		return list;
	}

}