1.数据库设置,先查询
SHOW VARIABLES LIKE 'character_set_%';
全部设置为如下图
如果不是可以设置例如:set character_set_server=utf8;
2.配置文件连接数据库时的设置,例如:
jdbc.url=jdbc\:mysql\://localhost\:3306/csgpic?useUnicode=true&characterEncoding=utf8&allowMultiQueries=true
3.页面设置编码
<%@page pageEncoding="UTF-8" contentType="text/html; charset=UTF-8" %>
4.Tomcat配置过滤器,项目web.xml中添加:
<filter> <filter-name>CharacterFilter</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>CharacterFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping>
4.Tomcat容器:
<Connector port="8089" protocol="HTTP/1.1" connectionTimeout="20000" redirectPort="8443" URIEncoding="UTF-8" />