一步一步全面解决mysql+jsp的中文问题

整个过程应实现如下代码

1.jsp页面字符设置

<%@ page contentType="text/html;charset=gbk"%>

2。jdbc driver:

jdbc:mysql://localhost/test?user=root&password=&useUnicode=true&characterEncoding=GBK

3。中间层的字符转换：

  public static String toGBK(String str)
 {
  try
  {
   if(str==null)
    str = "";
   else
    str=new String(str.getBytes("ISO-8859-1"),"GBK");
  }catch (Exception e) {System.out.println("DealString::toGBK(String)运行时出错：错误为："+e);}
  return str;
 }

 4.修改mysql.ini配置文件为default-character-set=GBK

5.use databasename;

  set names gbk;

  

• mysql> SHOW VARIABLES LIKE 'char%';
  +--------------------------+----------------------------------------+
  | Variable_name | Value |
  +--------------------------+----------------------------------------+
  | character_set_client | utf8 |
  | character_set_connection | utf8 |
  | character_set_database | latin1 |
  | character_set_filesystem | binary |
  | character_set_results | utf8 |
  | character_set_server | latin1 |
  | character_set_system | utf8 |
  | character_sets_dir | /usr/local/mysql/share/mysql/charsets/ |
  +--------------------------+----------------------------------------+
  8 rows in set (0.03 sec)
  Mysql> Set names gbk;

    Mysql>set character_set_client=gbk;