Mybatis 셋팅이란?

Mybatis 셋팅이란?

pom.xml에 추가한다.

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

1.설정해줘야한다. SqlSessionFactoryBean 

SqlSessionFactoryBean 

-DataSource(데이터베이스 커넥션)

-MyBatisConfig File(Mybatis 파일 위치정보)

(sqlMapConfig.xml)

-mapping File(쿼리SQL문을 포함)

(user.xml)

2.컴포넌트생성

(Mybatis제공 컴포넌트)

SqlSessionFactory 생성방법.

<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">

<constructor-arg ref="sqlSessionFactory" />

</bean>

3.SqlSessionFactory정보를 전달

SqlSessionTemplate(인터페이스 구현)

4.이 인터페이스를 구현한게 SqlSessionTemplate이다.

(Mybatis제공)

SqlSession(인터페이스)

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="configLocation" value="classpath:/config/SqlMapConfig.xml" /> <property name="mapperLocations"> <list> <value>classpath:/config/User.xml</value> </list> </property> </bean> <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate"> <constructor-arg ref="sqlSessionFactory" /> </bean>

SqlMapConfig.xml

vo클래스명 정리해준다.

<?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="User" type="myspring.user.vo.UserVO"/> <typeAlias alias="Member" type="myspring.user.vo.MemberVO"/> </typeAliases> </configuration>

User.xml

쿼리 포함된 mapping파일

namespace 이름 설정해준다. 

<?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="myspring.user.dao.UserMapper"> <select id="selectUserById" parameterType="string" resultType="User"> SELECT * FROM USERS WHERE USERID = #{id} </select> </mapper>