初学ssh,向mysql数据库里存入的中文全部变为乱码。如图:

mysql中的字符编码格式都是utf8,如图:


jsp的编码格式也是utf8,
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
按照网上查过的一些资料,还在Web.xml中配置了encodingFilter过滤器,代码:
<filter>
<filter-name>encodeFilter</filter-name>
<filter-class>com.test.common.EncodeFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encodeFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
过滤器代码:
package com.test.common;
import java.io.IOException;
import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter;
public class EncodeFilter extends StrutsPrepareAndExecuteFilter implements
Filter
{
private FilterConfig config = null;
private String encoding = null;
@Override
public void init(FilterConfig config) throws ServletException
{
this.config = config;
}
@Override
public void doFilter(ServletRequest request, ServletResponse response,
FilterChain chain) throws IOException, ServletException
{
if (encoding == null)
{
encoding = config.getInitParameter("encoding");
}
request.setCharacterEncoding(encoding);
response.setCharacterEncoding(encoding);
chain.doFilter(request, response);
}
@Override
public void destroy()
{
config = null;
encoding = null;
}
}
在spring里的applicationContext.xml里的数据库连接也修改过:
<property name="url">
<value>jdbc:mysql://localhost:3306/poll?useUnicode=true&characterEncoding=utf8</value>
</property>
在Tomcat端口的标签"Connector"中添加了URIEncoding属性
<Connector port="8080" protocol="HTTP/1.1"
connectionTimeout="20000"
redirectPort="8443"
URIEncoding="UTF-8"/>
但这些设置后都没有作用,并且对于这些设置我也是似懂非懂,希望哪位大神能答疑解惑下。
mysql shh 中文乱码
------解决方案--------------------
找一下,在哪一步变成乱码了,
是从页面传到后台的时候
还是后台获取的数据没问题插入的时候变成乱码的
再找对应的解决办法
------解决方案--------------------
同意二楼说法,查看下,看哪一步出问题了,找对应方法解决问题。