스프링 MVC 기초 - 5 : 기타

 

* UTF-8 설정
- web.xml

<!-- UTF-8 --> <filter>     <filter-name>encoding</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>encoding</filter-name>     <url-pattern>/*</url-pattern> </filter-mapping>

- STS
 Window > Preferences > General > Workspace >Text file encoding> Other에서 UTF-8 설정 후 Apply

- JSP : 파일 최상단에 아래 내용 추가

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

 

* SQL 로그 남기기

- pom.xml 추가

<dependency> 
            <groupId>org.lazyluke</groupId> 
            <artifactId>log4jdbc-remix</artifactId> 
            <version>0.2.7</version> 
        </dependency>

- log4j.xml 추가

<logger name="jdbc.sqlonly">
        <level value="info" />
    </logger>
    
    <logger name="jdbc.resultsettable">
        <level value="info" />
    </logger>

 

- root-context.xml 추가

<bean id="dataSource" class="net.sf.log4jdbc.Log4jdbcProxyDataSource"> 
     <constructor-arg ref="dataSourceSpied" /> 
     <property name="logFormatter"> 
         <bean class="net.sf.log4jdbc.tools.Log4JdbcCustomFormatter"> 
             <property name="loggingType" value="MULTI_LINE" /> 
             <property name="sqlPrefix" value="SQL : "/> 
         </bean> 
     </property> 
 </bean>

- root-context.xml 수정

<bean id="dataSource"  ==> <bean id="dataSourceSpied"