ssh架構中插入資料到mysql出現亂碼

文章目錄

• 再次列出能找的解決辦法：
• 1、串連資料庫的時候
• 2、設定mysql字元集
• show variables like'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;
• public class CharacterEncodingFilter implements Filter {
• }
• 5、修改tomcat中的設定檔server.xml
•         改為
•  
• 6、在web.xml配置spring過濾器
• <filter>
•     <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、串連資料庫的時候jdbc.properties: jdbc:mysql://localhost:3306/myproject?useUnicode=true&characterEncoding=utf8
applicationContext.xml: jdbc:mysql://localhost:3306/myproject?useUnicode=true&amp;characterEncoding=utf8

 

2、設定mysql字元集

 show variables like'character_set_%';

把顯示的character_set_**全都設定成utf8，即是：set character_set_serve='utf8'

 show variables like '%collation%'; 

把顯示的都設定成為如下：set collation_server='utf8_general_ci'

 

3、修改mysql設定檔my.inidefault-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;
import javax.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       <Connector port="8080" protocol="HTTP/1.1"
               connectionTimeout="20000"
               redirectPort="8443" />        改為      <Connector port="8080" protocol="HTTP/1.1"
               connectionTimeout="20000"
               redirectPort="8443" URIEncoding="UTF-8"/> 6、在web.xml配置spring過濾器<filter>    <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>