Back-End/Spring
[Spring] 예제 1 연습 - 설정
09009
2023. 5. 20. 11:18
1. pom.xml
버전 변경
<properties>
<java-version>11</java-version>
<org.springframework-version>5.0.7.RELEASE</org.springframework-version>
<org.aspectj-version>1.6.10</org.aspectj-version>
<org.slf4j-version>1.6.6</org.slf4j-version>
</properties>
pom.xml에서 좀 밑으로 내리면 아래와 같이 source, target을 11로 변경
<source>11</source>
<target>11</target>
현재 프로젝트에 maven update 실행
ojdbc 관련 dependency 추가
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc11</artifactId>
<version>21.8.0.0</version>
</dependency>
2. web.xml
DB 한글 insert 깨짐 방지 설정
</web-app> 태그 위에 아래 코드 복사
<!-- ja : 필수 추가 -->
<!-- 필터 등록... -->
<filter>
<filter-name>characterEncodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>utf-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
3. servlet-context.xml
<!-- ja : 아래 패키지명 변경할 것 -->
<context:component-scan base-package="com.yyi.problem1.*.controller" />
4. root-context.xml
namespaces 탭을 클릭- context 항목에 체크하고 저장
Source 메뉴로 이동 - component-scan에 아래 코드를 추가
<context:component-scan base-package="com.yyi.problem1.*.service" />
주의: mapper 패키지 만드는 이후부터 수행하여야함!!!
5. mybatis 설정
아래 코드 복사
<!-- Mybatis 관련 라이브러리 추가.. -->
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${org.springframework-version}</version>
</dependency>
복사 위치
<dependencies>
<!-- 추가 라이브러리 -->
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc11</artifactId>
<version>21.8.0.0</version>
</dependency>
<!-- Mybatis 관련 라이브러리 추가.. -->
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${org.springframework-version}</version>
</dependency>
<!-- 추가 라이브러리 끝 -->
<!-- Spring -->
<dependency>
root-context.xml
namespaces 탭 클릭 - mybatis 항목 체크
아래 코드 복사
패키지명만 변경
<!-- ja : mybatis 설정 -->
<!-- DataSource 인스턴스 생성 및 등록 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName"
value="oracle.jdbc.driver.OracleDriver"></property>
<property name="url" value="jdbc:oracle:thin:@localhost:1521:xe"></property>
<property name="username" value="c##scott"></property>
<property name="password" value="tiger"></property>
</bean>
<bean id="sqlSessionFactory"
class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<property name="mapperLocations" value="classpath:mapper/**/*.xml"></property>
</bean>
<mybatis-spring:scan base-package="com.yyi.problem1.*.mapper"/>