ssm框架中,与mysql进行中文交互时出现乱码情况
1. 检查web.xml
<!-- 编码过滤器 -->
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<async-supported>true</async-supported>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
2.检查mysql建表
1)将对应键的字符集设置为utf8
2)选择标注的选项,将字符集设置为utf8
3.检查链接数据库的url
在原url基础上添加?useUnicode=true&characterEncoding=UTF-8
例:url=jdbc:mysql://localhost:3306/ssm?useUnicode=true&characterEncoding=UTF-8
4.检查项目工程及jsp/java/xml文件
IntelliJ IDEA 设置utf8方法
File --》Settings --》File Encodings
设置如下图