乱码,struts+hibernate+mysql struts+hibernate+mysql 其中全部是utf—8编码,而且也配置了filter ,其中也为utf-8,但在插入和读取中文数据时仍然是乱码!哪位大哥帮我解决一下可能出现的问题在哪啊?谢谢了!感恩程序员的人生! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 呵呵,调试一上午,终于解决问题,配置处理个小问题,就是没有在jdbc后面加上“?useUnicode=true&characterEncoding=UTF-8 ”,这样的话导致插入数据库的数据时乱码,但查询出来显示在页面上的不是乱码,下面将我的详细步骤写给大家,以供参考:第一步、创建数据库的表,我使用的界面操作是SQL Manager for MySQL,将MySQL的编码设置为utf8,步骤在建库是:CREATE DATABASE `xxx` CHARACTER SET 'utf8' COLLATE 'utf8_bin';。第二步、创建字符过滤器 SetCharacterEncodingFilter.java 内容如下:package 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 SetCharacterEncodingFilter implements Filter { protected String encoding = null; protected FilterConfig filterConfig = null; protected boolean ignore = true; public void destroy() { this.encoding = null; this.filterConfig = null; } public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException { // Conditionally select and set the character encoding to be used if (ignore || (request.getCharacterEncoding() == null)) { String encoding = selectEncoding(request); if (encoding != null) request.setCharacterEncoding(encoding); } // Pass control on to the next filter chain.doFilter(request, response); } public void init(FilterConfig filterConfig) throws ServletException { this.filterConfig = filterConfig; this.encoding = filterConfig.getInitParameter("encoding"); String value = filterConfig.getInitParameter("ignore"); if (value == null) this.ignore = true; else if (value.equalsIgnoreCase("true")) this.ignore = true; else if (value.equalsIgnoreCase("yes")) this.ignore = true; else this.ignore = false; } protected String selectEncoding(ServletRequest request) { return (this.encoding); } } 第三步、配置web.xml , 在web.xml中加入如下代码:<filter> <filter-name>SetCharsetEncodingFilter</filter-name> <filter-class>filter.SetCharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>utf-8</param-value> </init-param> </filter> <filter-mapping> <filter-name>SetCharsetEncodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> 第四步、配置hibernate.cfg.xml文件,在文件中找到下面的代码<property name="connection.url"> jdbc:mysql://192.168.1.61:3306/ytxiu?useUnicode=true&characterEncoding=UTF-8 </property> 添加蓝色的代码,一定要添加,否则插入到库中为乱码,但显示出来到页面的是中文,为了参照数据库数据阅读方便,大家还是依次来做吧!第五步、设置测试页面test.jsp,将页面的编码格式设置如下: <%@ page language="java" pageEncoding="utf-8"%> SQL查询排序问题 mysql 纵表转化横表 谁知道 mysql工具 show profiles 显示的duration的时间的单位是什么,秒,毫秒,微秒,纳秒,皮秒,飞秒 mysql的date类存入问题 求一条sql,语句,高分,ACMAIN_CHM,WWWWA进来帮看一下,谢谢 对于300万数据量的数据库优化问题 请教一sql查询 这样将数据插入到已经建好的基本表里? 我用ASP做了一个程序,用的是SQL server数据库,想用程序实现向Mysql转化如何实现 navicat编写mysql 存储过程 hibernate与mysql开发中的问题? 关于mysql存储过程中游标的问题
,这样的话导致插入数据库的数据时乱码,但查询出来显示在页面上的不是乱码,下面将我的详细步骤写给大家,以供参考:第一步、创建数据库的表,我使用的界面操作是SQL Manager for MySQL,将MySQL的编码设置为utf8,步骤在建库是:CREATE DATABASE `xxx`
CHARACTER SET 'utf8'
COLLATE 'utf8_bin';。第二步、创建字符过滤器 SetCharacterEncodingFilter.java 内容如下:package 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 SetCharacterEncodingFilter implements Filter { protected String encoding = null;
protected FilterConfig filterConfig = null;
protected boolean ignore = true; public void destroy() { this.encoding = null;
this.filterConfig = null; } public void doFilter(ServletRequest request, ServletResponse response,
FilterChain chain)
throws IOException, ServletException { // Conditionally select and set the character encoding to be used
if (ignore || (request.getCharacterEncoding() == null)) {
String encoding = selectEncoding(request);
if (encoding != null)
request.setCharacterEncoding(encoding);
} // Pass control on to the next filter
chain.doFilter(request, response); } public void init(FilterConfig filterConfig) throws ServletException { this.filterConfig = filterConfig;
this.encoding = filterConfig.getInitParameter("encoding");
String value = filterConfig.getInitParameter("ignore");
if (value == null)
this.ignore = true;
else if (value.equalsIgnoreCase("true"))
this.ignore = true;
else if (value.equalsIgnoreCase("yes"))
this.ignore = true;
else
this.ignore = false; } protected String selectEncoding(ServletRequest request) { return (this.encoding); }
} 第三步、配置web.xml , 在web.xml中加入如下代码:<filter>
<filter-name>SetCharsetEncodingFilter</filter-name>
<filter-class>filter.SetCharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>utf-8</param-value>
</init-param>
</filter> <filter-mapping>
<filter-name>SetCharsetEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping> 第四步、配置hibernate.cfg.xml文件,在文件中找到下面的代码<property name="connection.url"> jdbc:mysql://192.168.1.61:3306/ytxiu?useUnicode=true&characterEncoding=UTF-8
</property>
添加蓝色的代码,一定要添加,否则插入到库中为乱码,但显示出来到页面的是中文,为了参照数据库数据阅读方便,大家还是依次来做吧!第五步、设置测试页面test.jsp,将页面的编码格式设置如下:
<%@ page language="java" pageEncoding="utf-8"%>