Spring setting

[WonYong-Jang]

Character breakup occurs

• If character breakup occurs after creating Spring project, write in web.xml of project files

<!-- 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>

the web system first consults web.xml to locate the files associated with the spring configuration and to reference those filse.

• 'classpath' is /src/main/resources/
• web.xml consist in path of root-context.xml and servlet-context.xml
• create a directory called spring in the path of src/main/resources/ ( to collect files scattered in one place. )
• modify path of two files(root-context, servlet-context) in web.xml

 <context-param>
       <param-name>contextConfigLocation</param-name>
       <param-value>classpath:spring/*-context.xml</param-value> 
</context-param>

<servlet>
	<servlet-name>appServlet</servlet-name>
	<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
	<init-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath:servlet-context.xml</param-value>
	</init-param>
	<load-on-startup>1</load-on-startup>
</servlet>

Controller URL

• Return "board/index" in getBoardList function can be found in servlet-conext.xml
  ==> ViewResolver
  ==> prefix and suffix

<beans:bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
	<beans:property name="prefix" value="/WEB-INF/views/" />
	<beans:property name="suffix" value=".jsp" />
</beans:bean>

link : https://freehoon.tistory.com/101

[WonYong-Jang]

database setting

$ mysql -uroot -p
mysql> show databases
mysql > show create table [table명] // show create script

mysql> show warnings\g // show error log

참고 링크 : https://all-record.tistory.com/96