Mysql汉字乱码问题

create   database   Friends   default     charset=gbk;

   CREATE TABLE friends(51Testing软件测试网u
v Qs;Zcey-P6`~h

  id int(11) NOT NULL auto_increment,           51Testing软件测试网;_C+}@6aeLX2{4M

  name varchar(50) NOT NULL default '',

  sex varchar(50) NOT NULL default '',

  telno varchar(50) NOT NULL default '', 51Testing软件测试网
|V&T~~

  PRIMARY KEY  (id)51Testing软件测试网 D n@W2]9vRU

) default charset=gbk;

*W2nE*gCEa|0

连接语句为51Testing软件测试网&A3Fu!sH!F~/|

mysqlUrl = “jdbc:mysql://localhost:3306/Friends?useUnicode=true&characterEncoding=gb2312”; 

JSP页面

<%@ page language="java" contentType="text/html; charset=GB2312" pageEncoding="GB2312"%>51Testing软件测试网M Fxr-QPt^"u

51Testing软件测试网] o;g!B*@3g;@

向数据库插入记录51Testing软件测试网p$g`AciCU@m

 String sql = "insert into friends(name,sex,telno) values('"

    + friends.getName()+ "','" + friends.getSex() + "','" + friends.getTelno()+"')";

System.out.println(sql);  51Testing软件测试网YU OEnI'J

sql = new String(sql.getBytes("ISO8859-1"), "GB2312");51Testing软件测试网i$X:Z8R pi

System.out.println(sql);51Testing软件测试网7jw)}iw,K:j*G

int i = stmt.executeUpdate(sql); 51Testing软件测试网T(fR2sv'};O D