OFBiz 的中文乱码解决方案

OFBiz开发时遇到乱码的问题，MySQL数据库插入中文数据时出现了一个问题，报告中文错误：incorrect string value ．．．．．

1.这时由于字符编码不一致导致的，应该将数据库对应的表或coloum改成uft-8，所以如果在CustomerExtra这表中存储中文的话，需要将
此表另外还有operationlog表的charset改成utf-8

2.Servlet中字符显示为证券的中文，而且表也设置为utf-8，但是数据库和页面还是乱码，怎么回事？
这里需要修改jdbc url的参数，如将jdbc:mysql://localhost/ccbportal?zeroDateTimeBehavior=convertToNull
改成：jdbc:mysql://localhost/ccbportal?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=UTF-8

3.前台输入的是中文，到后台就变成了乱码，怎么回事？
无论何种表单提交都可以在后台的java文件中通过String des = new String(s.getBytes("iso8859-1"),"UTF-8");
来转换成你想要的UTF－8编码方式。但如果每处都加词句太麻烦，故分post和get两种方式区分提交。
写一个Filter即可解决问题：

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

--> 1
2 import java.io.IOException;
3 import javax.servlet.ServletException;
4 import javax.servlet.Filter;
5 import javax.servlet.FilterChain;
6 import javax.servlet.FilterConfig;
7
8 import javax.servlet.ServletRequest;
9 import javax.servlet.ServletResponse;
10
11 public class SetCharacterEncodingFilter implements Filter {
12
13 protected String encoding = "GBK";
14
15 protected FilterConfig filterConfig = null;
16
17 protected boolean ignore = true;
18
19 public void init(FilterConfig filterConfig) throws ServletException {
20 this.filterConfig = filterConfig;
21 this.encoding = filterConfig.getInitParameter("encoding");
22 String value = filterConfig.getInitParameter("ignore");
23 if (value == null)
24 this.ignore = true;
25 else if (value.equalsIgnoreCase("true"))
26 this.ignore = true;
27 else if (value.equalsIgnoreCase("yes"))
28 this.ignore = true;
29 else
30 this.ignore = false;
31 }
32
33 public void doFilter(ServletRequest request, ServletResponse response,
34 FilterChain chain) throws IOException, ServletException {
35 // Conditionally select and set the character encoding to be used
36 if (ignore || (request.getCharacterEncoding() == null)) {
37 String encoding = selectEncoding(request);
38 if (encoding != null) {
39 request.setCharacterEncoding(encoding);
40 }
41
42 }
43 // Pass control on to the next filter
44 chain.doFilter(request, response);
45 }
46
47 protected String selectEncoding(ServletRequest request) {
48 return (this.encoding);
49 }
50
51 public void destroy() {
52 this.encoding = null;
53 this.filterConfig = null;
54 }
55 }
56

web.xml添加此Filter：

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

--> 1<filter>
2<filter-name>encodeFilter</filter-name>
3<filter-class> com.aicent.ccb.filter.SetCharacterEncodingFilter</filter-class>
4<init-param>
5<param-name>encoding</param-name>
6<param-value>GBK</param-value>
7</init-param>
8<init-param>
9<param-name>ignore</param-name>
10<param-value>true</param-value>
11</init-param>
12</filter>
13<filter-mapping>
14<filter-name>encodeFilter</filter-name>
15<url-pattern>/control/*</url-pattern>
16</filter-mapping>