UC知道jsp+mysql,不能显示数据库中的汉字啊,救命啊,看了教程也没弄好啊
来源：百度知道 编辑：UC知道 时间：2024/07/04 01:16:38
请教高手,看了许多文章还是不行啊,怎么办啊
我的是tomcat(5.027)+jdk(1.42)+mysql(4.1好像)
系统XP
驱动:mysql-connector-java-3.0.17-ga-bin.jar
my.ini是这样的--------------------------------------------------
#This File was made using the WinMySQLAdmin 1.4 Tool
#2006-3-23 21:43:48
[WinMySQLAdmin]
Server=E:/mysql/bin/mysqld-nt.exe
[mysql]
default-character-set=gb2312
[mysqld]
default-character-set=gb2312
basedir=E:/mysql
datadir=E:/mysql/data
port=3306
default-storage-engine=innodb
[WinMySQLadmin]
Server=E:/mysql/bin/mysqld-nt.exe
user=root
password=123
我的测试页面是---------------------------------------------------
<%@ page language="java" contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*"%>
<%@ page import="java.sql.Connection,java.sql.SQLException,javax.sql.DataSource"%>
我的是tomcat(5.027)+jdk(1.42)+mysql(4.1好像)
系统XP
驱动:mysql-connector-java-3.0.17-ga-bin.jar
my.ini是这样的--------------------------------------------------
#This File was made using the WinMySQLAdmin 1.4 Tool
#2006-3-23 21:43:48
[WinMySQLAdmin]
Server=E:/mysql/bin/mysqld-nt.exe
[mysql]
default-character-set=gb2312
[mysqld]
default-character-set=gb2312
basedir=E:/mysql
datadir=E:/mysql/data
port=3306
default-storage-engine=innodb
[WinMySQLadmin]
Server=E:/mysql/bin/mysqld-nt.exe
user=root
password=123
我的测试页面是---------------------------------------------------
<%@ page language="java" contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*"%>
<%@ page import="java.sql.Connection,java.sql.SQLException,javax.sql.DataSource"%>
在mysql中编码用的是ISO8859-1，而你的页面用的是gb2312。
把字符串提取出来后重新编码就行了，如
String s = ... //从数据库中取出字符串
s = new String(\"gb2312\", s);//重新编码就OK了。
再或者你把这行的gb2312改成iso8859-1试一试。
String url =\"jdbc:mysql://localhost/rock_database?useUnicode=true&characterEncoding=gb2312\";