[Spring] DB연동하기1 (db연결 세팅하기)

2021/01/26 - [Java] - [Spring] spring 설치

[Spring] spring 설치

지난 글을 보면 'The time on the server is ~????'라고 나온다 character encoding setting이 안돼서 그렇다.

 

db를 연결하기 전에 먼저 character encoding setting 을 해주고 출발 해보자

 

매우 간단하다.

 

자신의 프로젝트 > src > main > webapp > WEB-INF > views > web.xml로 들어가서

 

아래의 코드를 추가해주자.

<!-- Character Set Filter -->
	<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>

 

 

web.xml 전체코드 

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee https://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">

	<!-- The definition of the Root Spring Container shared by all Servlets and Filters -->
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>/WEB-INF/spring/root-context.xml</param-value>
	</context-param>
	
	<!-- Creates the Spring Container shared by all Servlets and Filters -->
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>

	<!-- Processes application requests -->
	<servlet>
		<servlet-name>appServlet</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<init-param>
			<param-name>contextConfigLocation</param-name>
			<param-value>/WEB-INF/spring/appServlet/servlet-context.xml</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>
		
	<servlet-mapping>
		<servlet-name>appServlet</servlet-name>
		<url-pattern>/</url-pattern>
	</servlet-mapping>
	
	<!-- Character Set Filter -->
	<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>

</web-app>

 

이렇게 하고 저장후에 서버를 다시 켜주면 

 

이렇게 잘 나오는 것을 확인할 수 있다.

 

그럼 디비 연동 전에 환경 설정부터 하자.

 

spring legacy project를 처음 만들면 아래와 같이 xml파일들이 들어가 있다.

 

 

이것들을 아래와 같이 위치를 바꿔주자.

이유는 여기저기 다른 폴더 안에 있으면 관리가 어려워서 하나의 폴더 안에 넣어주는 것이 관리가 수월하다고 한다.