0

## MyBatis 기본설정

Spring(Maven) 기준 기본설정

1. pom.xml

<!-- MyBatis 라이브러리 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.2.2</version>
</dependency>

<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.2.0</version>
</dependency>

<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${org.springframework-version}</version>
</dependency>

<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>

: search.maven.org에서 최신의 dependency 라이브러리를 다운가능.


2. context-mapper.xml
: dataSource(디비정보)가 있는 가정하에 설정, dataSource를 연결해서 사용

<!-- MyBatis 설정 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="configLocation"
                              value="classpath:/mapper/mybatis-config.xml" />
</bean>

<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory" />
</bean>

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.happyict" />
</bean>


3. mybatis-config.xml
:마이바티스 설정파일, alias 그리고 mapper를 지정 등 설정하는 파일.

<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<!-- interceptor setting -->
<configuration>

<!--Type을 alias로 지정-->
<typeAliases>
<typeAlias alias="memberDto" type="com.happyict.dto.MemberDto" />
<typeAlias alias="reportDto" type="com.happyict.dto.ReportDto" />
<typeAlias alias="bbsDto" type="com.happyict.dto.BbsDto" />
<typeAlias alias="codeDto" type="com.happyict.dto.CodeDto" />
<typeAlias alias="jobDto" type="com.happyict.dto.JobDto" />
</typeAliases>

<mappers>
<mapper resource="/mapper/member_SQL.xml" />
<mapper resource="/mapper/report_SQL.xml" />
<mapper resource="/mapper/bbs_SQL.xml" />
<mapper resource="/mapper/common_SQL.xml" />
<mapper resource="/mapper/job_SQL.xml" />
</mappers>

</configuration>



4. report_SQL.xml
: SQL mapper 파일

<mapper namespace="com.happyict.dao.MemberDao">

<!-- 회원가입 -->
<insert id="" parameterType="">
/* insertMember */
                sql문 쓰는 곳
</insert>

<!-- 회원정보 수정 -->
<update id="" parameterType="">
/* updateMember */
                sql문 쓰는 곳
</update>

</mapper>