青春无处安放表达什么:mysql 中文无法显示

来源:百度文库 编辑:高考问答 时间:2024/04/29 21:16:31
请教高手,看了许多文章还是不行啊,怎么办啊

我的是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"%>
<html> <title>connecting</title>
<body>
<%
Class.forName("org.gjt.mm.mysql.Driver");
String url ="jdbc:mysql://localhost/rock_database?useUnicode=true&characterEncoding=gb2312";
Connection conn= DriverManager.getConnection(url,"root","123");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from sanshizi_t1";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
%>

信息组:<br>

<%
String[] mes={"ID号","昵称","姓名","姓别","年龄","E-mail","地址","QQ号","另一个QQ号","UC号"};

for(int i=0;i<4;i++){
%>
您的<%=mes[i]%>是:

<%=rs.getString(i+1)%>
<br>
<%}%>
<br>

<%}%>

<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
<body>
<html>

我的数据库(rock-datebase),表(sanshizi_t1)的内容是:---------------
id-name-qq-addr
1-sanshzi-123123123-chianese
2-三石子-30316306464-中华人民共和国

但是测试结果:就是汉字显示不正常,在数据库中汉字显示都是正常的,关闭再打开还是正常的.高手快来救我啊,我不能就死在这了啊!!!!!!!!!!!!!