mysql jdbc 中文_jdbc 对mysql插入中文乱码

public class Test {

public static void main(String[] args) {

Connection conn = null;

Statement stat = null;

ResultSet rs = null;

try {

Class.forName("org.gjt.mm.mysql.Driver").newInstance();

String connStr = "jdbc:mysql://localhost:3306?useUnicode=true&characterEncoding=UTF-8";

String dbUser = "root";

String dbPassword = "123456";

conn = DriverManager.getConnection(connStr, dbUser, dbPassword);

if (conn != null) {

System.out.println("连接成功");

stat = conn.createStatement();

stat.execute("drop database test_db");

stat.execute("create database test_db CHARACTER SET UTF8");

stat.execute("use test_db");

stat.execute("create table if not exists test_info(  role_id int primary key auto_increment, role_name varchar(50) not null)default charset=UTF8");

stat.execute("insert into test_info(role_name) values ('测试')");

rs = stat.executeQuery("select * from test_info");

while (rs.next()) {

System.out.println(rs.getInt("role_id")+" : "+rs.getString("role_name"));

}

} else {

System.out.println("连接失败");

}

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

rs.close();

stat.close();

conn.close();

} catch (Exception e2) {

e2.printStackTrace();

}

}

}

}

兄弟们帮忙看看，为什么上面段代码查询出来的是乱码呢？搞不太懂~我数据库、连接字符串、表等等都是UTF-8的

2012年9月09日 22:27