前台提交servlet存入数据库乱码问题

首先必须统一所有为utf-8模式，设置表和数据库都为utf-8

修改my.ini,加入两句character_set_server=utf8和default-character-set=utf8,
[mysqld]
datadir=C:/Program Files/MariaDB 5.5/data
port=3306
sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
default_storage_engine=innodb
innodb_buffer_pool_size=383M
innodb_log_file_size=50M
character_set_server=utf8
[client]
port=3306
default-character-set=utf8
PS:直接用set character_set_server='utf8'只能临时修改字符集，重启服务后就失效，必须修改my.ini才能永久修改,然后重启Mysql服务。

然后可以创建以个filter,

@Override
public void doFilter(ServletRequest arg0, ServletResponse arg1,
FilterChain arg2) throws IOException, ServletException
{
HttpServletRequest request = (HttpServletRequest) arg0;
HttpServletResponse response = (HttpServletResponse) arg1;
request.setCharacterEncoding("UTF-8");
// System.out.println("aa");
response.setContentType("text/html;charset=UTF-8");
arg2.doFilter(request, response);

}

但是如果你使用了commons.fileupload框架，则以上修改并不能满足

还需要你自己将普通表单字段自己解码编码

item为遍历得到的FileItem

String name = item.getFieldName();
String value = new String(item.getString().getBytes("ISO-8859-1"),"UTF-8");
switch(name){
case "CircleName":
CircleName=value;
break;
case "CircleType":
CircleType=value;
break;
case "CircleNotes":
CircleNotes=value;
break;
case "createrID":
createrID=value;
break;

}

处理完之上步骤，应该不会有乱码问题