Spring Boot - Sizuha/devdog GitHub Wiki
Make sure you register Spring's CharacterEncodingFilter in your web.xml (must be the first filter in that file).
<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> https://qiita.com/neriai/items/549617569b1b719eb84d
pom.xmlใ้ใใๅ ใฎๆ็ต่กใซ่ฟฝๅ ใใฆใใ ใใใ
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.45</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${org.springframework-version}</version>
</dependency>ใใญใธใงใฏใใๅณใฏใชใใฏใใใๅฎ่ก > Maven cleanใใๅฎ่กใใพใใ
ๅใใใใๅฎ่ก > Maven installใใๅฎ่กใใพใใ
root-context.xmlใ้ใใๅ ใฎๆ็ต่กใซ่ฟฝๅ ใใฆใใ ใใใ
<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>com.mysql.jdbc.Driver</value>
</property>
<property name="url">
<value>jdbc:mysql://localhost:3306/db_name?useUnicode=true&characterEncoding=utf8</value>
</property>
<property name="username">
<value>root</value>
</property>
<property name="password">
<value></value>
</property>
</bean>โป ์ ๋์ฝ๋ ๋ฌธ์๊ฐ ํฌํจ๋ SQL๋ฌธ์ ์คํํ๊ณ ์ ํ ๋, jdbc ์ฐ๊ฒฐ URL์ ๋ค์์ ์ถ๊ฐํ๋ค.
?useUnicode=true&characterEncoding=utf8/**
* Handles requests for the application home page.
*/
@Controller
public class HomeController {
@Autowired
private JdbcTemplate jdbcTemplate;
@RequestMapping(value = "/", method = RequestMethod.GET)
public String home(Locale locale, Model model) {
final List<Map<String, Object>> list = jdbcTemplate.queryForList("SELECT * FROM users");
model.addAttribute("data", list.get(0).get("name") );
return "home";
}
}<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ page session="false" %>
<html>
<head>
<title>Home</title>
</head>
<body>
<h1>
Hello world!
</h1>
<p> DB's data is ${data}. </p>
</body>
</html>server.xml์ ๋ค์์ ์ถ๊ฐ.
<Context docBase="์๋ณธ ๊ฒฝ๋ก" path="/๋งตํํ URL" />Tomcat ์ฌ์์ ํ์.
ไพ๏ผ
<Server port="8025" shutdown="SHUTDOWN">
...
<Service name="Catalina">
...
<Engine defaultHost="localhost" name="Catalina">
...
<Host appBase="webapps"
autoDeploy="false" name="localhost" unpackWARs="true"
xmlNamespaceAware="false" xmlValidation="false">
...
<Context docBase="/var/project/images" path="/project/images" />
</Host>
</Engine>
</Service>
</Server>์ฃผ์!! ๋ฐ๋์ ์ค์ ํ๋ ๊ฒฝ๋ก๋ฅผ ์ง์ ํ ๊ฒ
์กด์ฌํ์ง ์์ ๊ฒฝ๋ก๋ก server.xml์ ๋ณ๊ฒฝํ ๋ค์์ Tomcat์ ์คํ์ํค๋ฉด ์๋ฌ๊ฐ ๋๋ค.
