MyBatis

src/main/webapp/WEB-INF/spring/root-context.xml

	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
		<property name="url" value="jdbc:oracle:thin:@localhost:1521:xe"></property>
		<property name="username" value="ID"></property>
		<property name="password" value="PW"></property>
	</bean>
	
	<!-- 중간에 위치해서 모든 DB작업을 감시하고 기록한다. -->
	<bean id="log4j" class="net.sf.log4jdbc.Log4jdbcProxyDataSource">
		<constructor-arg ref="dataSource"></constructor-arg>
		<property name="logFormatter">
			<bean class="net.sf.log4jdbc.tools.Log4JdbcCustomFormatter">
				<property name="loggingType" value="MULTI_LINE"></property>
				<property name="sqlPrefix" value="[SQL]"></property>
			</bean>
		</property>
	</bean>
	
	
	<bean id="sessionfactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="log4j"></property>
		<property name="mapperLocations" value="classpath*:com/test/mypet/mapper/*.xml"></property>
		<property name="configLocation" value="/WEB-INF/mybatis.xml"></property>
	</bean>
	
	<bean class="org.mybatis.spring.SqlSessionTemplate">
		<constructor-arg ref="sessionfactory"></constructor-arg>

--xml 설명

<bean id="dataSource">

 <property name="username" value=""></property> //아이디

 <property name="password" value=""></property> // 비밀번호

</bean>

 

<bean id="sessionfactory">

 <property name="mapperLocations" value="classpath*:com/test/mypet/mapper/*.xml"></property> //쿼리용 xml

 <property name="configLocation" value="/WEB-INF/mybatis.xml> //별칭용 mapper

</bean>

 

 

-- src/main/webapp/WEB-INF/mybatis.xml

<typeAliases>
	<typeAlias type="" alias="" />
</typeAliases>

type에서 java파일을 읽고, 그 java파일을 어떤 별칭으로 지어줄건지 alias에서 정한다

 

 

-- 쿼리용 mapper.xml

<select id="goods" parameterType="String" resultType="goodsDTO">
	select * from vwGoods where seqGoods = #{seqGoods}
</select>

resultType은 alias를 지칭한다.

id는 추후에 설명