지난 시간 복습
출처 : 자바공작소
이후 작업은 SpringFramework version 을 5.1.11 로 올려서 진행
(pom.xml 에서 수정)
apache.maven.plugin 의 source, target 도 1.8 로 변경
명령크롬프트 관리자 실행
lombok 경로로 이동 후
java -jar lombok-1.18.8.jar
pom.xml 에
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${org.springframework-version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp -->
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>
<!-- 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>
추가
<!-- mybatis setting -->
<beans:bean name="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<beans:property name="driverClassName"
value="oracle.jdbc.driver.OracleDriver" />
<beans:property name="url"
value="jdbc:oracle:thin:@localhost:1521:xe" />
<beans:property name="username" value="hr" />
<beans:property name="password" value="123456" />
</beans:bean>
<beans:bean id="sqlSessionFactory"
class="org.mybatis.spring.SqlSessionFactoryBean">
<beans:property name="dataSource" ref="dataSource" />
<beans:property name="mapperLocations"
value="classpath:com/tech/sprjt09/dao/mapper/*.xml" />
</beans:bean>
<beans:bean id="sqlSession"
class="org.mybatis.spring.SqlSessionTemplate">
<beans:constructor-arg index="0"
ref="sqlSessionFactory"></beans:constructor-arg>
</beans:bean>
servlet-context.xml 에 추가
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.tech.sprjt09.dao.IDao">
</mapper>
IDao.xml
DB 연결, mybatis 서버로 설정 하는 내용.