[spring] Starter Project,Legacy Project : xml Mapper 설정 차이

spring starter project ( spring-boot )  과 spring legacy project

• JDBC로 DB연결 설정

spring starter project : src/main/resources/application.properties 에 설정

#웹서버 부분
server.port:8989
spring.mvc.view.prefix=/WEB-INF/views/
spring.mvc.view.suffix=.jsp
#백엔드 부분 - DB 연결
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/ch20
spring.datasource.username=root
spring.datasource.password=12345
#그림파일 처리
# path= /src/main/resources/static(기본으로 있음) + /imgs 폴더 생성
spring.mvc.static-path-pattern=/static/**
spring.web.resources.static-locations=classpath:/static/
spring.web.resources.add-mappings=true

 

spring legacy project : webapp/WEB-INF/spring/root-context.xml 에 설정

	<bean id="dataSource" class="org.apache.ibatis.datasource.pooled.PooledDataSource">
	    <property name="driver" value="com.mysql.jdbc.Driver"/>
	    <property name="url" value="jdbc:mysql://localhost:3306/ch20?useUnicode=true&amp;characterEncoding=utf-8"/>
	    <property name="username" value="root"/>
	    <property name="password" value="1234"/>
	</bean>
	
	<bean id="transactionManager"
	    class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
	    <property name="dataSource" ref="dataSource"></property>
	</bean >
	
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
	    <property name="dataSource" ref="dataSource"></property>
	    <property name="configLocation"
	        value= "classpath:/mybatis/mybatis-config.xml">
	    </property>
	</bean>
	
	<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
	    <constructor-arg ref="sqlSessionFactory"></constructor-arg>
	</bean>

 

• xml 을 mapper 로 설정

spring starter project : 설정이 미리 되어있다.

 

spring legacy project : root-context.xml 에 설정한 경로인 (src/main/resources/) mybatis/mybatis-config.xml 를 작성

<?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" >

<configuration>
	<typeAliases>
	  <typeAlias alias="member77" type="co.kr.memboard.dto.MemberDTO"/>
	  <typeAlias alias="board77" type="co.kr.memboard.dto.BoardDTO"/>
	</typeAliases>

	<mappers>
		<mapper resource="/mybatis/member.xml"/>
		<mapper resource="/mybatis/board.xml"/>
	</mappers>
</configuration>