mysql表中插中文报错_jsp向mysql表中插入中文数据乱码解决

Jsp 向Mysql表中添加中文文字乱码报错，解决方案

1．首先设置页面charset=gb2312 和 保证要所用提交页面格式为gb2312，

如果只操作这一步，在控制台打印提交数据有可以出现乱码情况，必须添加下面配置2．创建Filter类，配置web.xml

创建一个名为txtFilter类，实现Filter接口，用来设置页面代码格式

package com.rongtianxinxijishu.book.util;

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 javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class txtFiter implements Filter {

public void destroy() {

// TODO Auto-generated method stub

}

public void doFilter(ServletRequest arg0, ServletResponse arg1, FilterChain arg2) throws IOException, ServletException { // TODO Auto-generated method stub

//主要步骤如下

HttpServletRequest req = (HttpServletRequest) arg0;

HttpServletResponse res = (HttpServletResponse) arg1;

req.setCharacterEncoding("gb2312");

res.setCharacterEncoding("gb2312");

arg2.doFilter(req, res);

}

public void init(FilterConfig arg0) throws ServletException { // TODO Auto-generated method stub