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

最新推荐文章于 2025-12-03 14:39:35 发布

原创最新推荐文章于 2025-12-03 14:39:35 发布 · 720 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #jsp #character #string #variables #jdbc

jsp 专栏收录该内容

3 篇文章

订阅专栏

本文详细介绍如何在JSP页面、MySQL数据库及Java应用中全面配置GBK字符集，确保中文字符正确显示与存储。从JSP页面编码设置到数据库连接参数调整，再到Java中间层字符串处理，全方位解决GBK编码问题。

整个过程应实现如下代码

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;