Mybatis 셋팅이란?

Mybatis 셋팅이란?

pom.xml에 추가한다.

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

<!-- 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(인터페이스)

?

1 2 3 4 5 6 7 8 9 10 11 12 13

<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클래스명 정리해준다.

?

1 2 3 4 5 6 7 8 9

<?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 이름 설정해준다. 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14

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