Mysql 关于乱码

来源：互联网发布：乔任梁的半途人生知乎编辑：程序博客网时间：2024/05/07 01:23

再次列出能找的解决办法：

1、连接数据库的时候

jdbc.properties: jdbc:mysql://localhost:3306/myproject?useUnicode=true&characterEncoding=utf8
applicationContext.xml: jdbc:mysql://localhost:3306/myproject?useUnicode=true&characterEncoding=utf8

2、设置mysql字符集

show variableslike'character_set_%';

把显示的character_set_**全都设置成utf8，即是：set character_set_serve='utf8'

show variables like '%collation%';

把显示的都设置成为如下：set collation_server='utf8_general_ci'

3、修改mysql配置文件my.ini

default-character-set=utf8

4、建一个过滤类

package com.broadengate.crm.filter;

import java.io.IOException;

import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
importjavax.servlet.ServletRequest;
import javax.servlet.ServletResponse;

public class CharacterEncodingFilter implements Filter {

public void destroy() {
}

    public void doFilter(ServletRequest request, ServletResponse response,
                             FilterChain chain) throws IOException, ServletException {
                               request.setCharacterEncoding("utf-8");
                               chain.doFilter(request, response);
    }

public void init(FilterConfig arg0) throws ServletException {

}

}

web.xml配置加
<filter>
   <filter-name>encodefilter</filter-name>
       <filter-class>com.broadengate.crm.filter.CharacterEncodingFilter</filter-class>
   </filter>
   <filter-mapping>
           <filter-name>encodefilter</filter-name>
           <url-pattern>/*</url-pattern>
   </filter-mapping>

5、修改tomcat中的配置文件server.xml

改为

6、在web.xml配置spring过滤器

<filter-name>char</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>char</filter-name>

<url-pattern>/*</url-pattern>

</filter-mapping>

1、jar更换为5.1.15

2、2003mysql中my.cnf修改默认编码。

3、在mysqlClick中配置utf-8编码

4、oa端进行URLEncoder.encode(user.getHumanname(), "utf-8") 编码

5、论坛登录方法进行：username = new String(username.getBytes("ISO-8859-1"),"UTF-8"); 解码

0 0