Day - 39,40 [SPRING] 설정

_01

_02 

 

 

1. pom.xml

 

자바버전 : 1.8

org.springframework-version : 4.3.14 

 

---

 

 

< Aspect J > 위에 라이브러리 추가 ※calc에는 저 라이브러리

<!-- 필요한 라이브러리 -->
		<!-- jdbc -->
		<!-- https://mvnrepository.com/artifact/org.mariadb.jdbc/mariadb-java-client -->
		<dependency>
    		<groupId>org.mariadb.jdbc</groupId>
    		<artifactId>mariadb-java-client</artifactId>
   		 <version>2.7.2</version>
		</dependency>
		
		
		<!-- common-dbcp -->
		<!-- https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp -->
		<dependency>
    		<groupId>commons-dbcp</groupId>
    		<artifactId>commons-dbcp</artifactId>
    		<version>1.4</version>
		</dependency>
		
		
		<!-- spring-jdbc -->
		<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
		<dependency>
    		<groupId>org.springframework</groupId>
    		<artifactId>spring-jdbc</artifactId>
    		<version>4.3.14.RELEASE</version>
		</dependency>
		
		
		<!-- mybatis -->
		<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
		<dependency>
    		<groupId>org.mybatis</groupId>
    		<artifactId>mybatis</artifactId>
    		<version>3.4.6</version>
		</dependency>
		
		
		<!-- mybatis-spring -->
		<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
		<dependency>
    		<groupId>org.mybatis</groupId>
    		<artifactId>mybatis-spring</artifactId>
    		<version>1.3.2</version>
		</dependency>

 

---

 

 

소스 , 타겟 1.8

버전 3.7.0

 

---

 

 

02. web.xml

 

 

<!-- 한글깨짐 방지 -->
	<!-- controller 접근시 특정 요청에 대해서 어떤 class 와 연걸 할 것인지 지정한다. -->
	<filter>
		<filter-name>encodingFilter</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>
		<!-- 강제 인코딩 여부 -->
		<init-param>
			<param-name>forceEncoding</param-name>
			<param-value>true</param-value>
		</init-param>
	</filter>
	
	<!-- 어떤 요청이 왔을 때 어떤 필터 쓸래? -->
	<filter-mapping>
		<filter-name>encodingFilter</filter-name>
		<url-pattern>/*</url-pattern>
	</filter-mapping>

맨위에 

한글깨짐 방지

 

---

 

03. servlet-context.xml

 

project -> properties -> project facets 1.8 로 변경

 

 

 

<!-- data source -->
	<!--  db는 맞는지 url(localhost:3306)은 맞는지 id,pw(웹유저,패스)는 맞는지 확인 -->
	<beans:bean name="datasource" class="org.apache.commons.dbcp.BasicDataSource">
		<beans:property name="driverClassName" value="org.mariadb.jdbc.Driver"/>
		<beans:property name="url" value="jdbc:mariadb://localhost:3306/mydb"/>
		<beans:property name="username" value="web_user"/>
		<beans:property name="password" value="pass"/>
	</beans:bean>
	
	<!-- mybatis 설정 -->
	<!-- xml 위치 주의 classpath:kr/co/gudi/member/dao/*.xml-->
	<beans:bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 연결할 DB 정보 -->
		<beans:property name="dataSource" ref="datasource"/>
		<!-- 쿼리문이 있을 장소 -->
		<beans:property name="mapperLocations" value="classpath:kr/co/gudi/member/dao/*.xml"/>
	</beans:bean>
	
	<!-- mybatis 사용 영역 -->
	<!-- 아래 빨간줄은 namespaces 에서 mybatis-spring 체크해주기 -->
	<mybatis-spring:scan base-package="kr.co.gudi.member.dao"/>

 

 

데이터소스(data source)

 

빨간 줄 뜨면 mybatis-spring 체크