mysql的latin1_查询mysql latin1表乱码问题

packagetest;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.Statement;public classTestDB {private staticConnection connection;static{try{

Class.forName("com.mysql.jdbc.Driver") ;//?useUnicode=true&characterEncoding=utf8

connection = DriverManager.getConnection("jdbc:mysql://xxxx.db.com:3306/database", "xxxxx", "xxxxxx6");

}catch(Exception ex){

ex.printStackTrace();

}

}public static void main(String[] args)throwsException {//connection.createStatement().execute("set names latin1");

/*connection.createStatement().execute("SET character_set_results=latin1;");

connection.createStatement().execute("set character_set_connection=latin1;");

connection.createStatement().execute("set character_set_client=latin1;");*/Statement stm=connection.createStatement();

ResultSet rs1= stm.executeQuery("show VARIABLES like '%char%'");while(rs1.next()){

System.out.println(rs1.getString("Variable_name")+"\t"+rs1.getString("Value"));

}//PreparedStatement pstmt = connection.prepareStatement("select nick from t_login where uid = 9714") ;//select owner as info from t_info_5 where uid = 5859

PreparedStatement pstmt = connection.prepareStatement("select owner as nick from xxxx_table where uid = 225 ") ;

ResultSet rs=pstmt.executeQuery();while(rs.next()){

String val= rs.getString("nick");

System.out.println(val);

System.out.println("========================");

String val1= new String(val.getBytes("latin1"),"utf8");

System.out.println(val1);

String val2= new String(val.getBytes("latin1"),"gbk");

System.out.println(val2);

String val3= new String(val.getBytes("utf8"),"gbk");

System.out.println(val3);

String val4= new String(val.getBytes("utf8"),"latin1");

System.out.println(val4);

String val5= new String(val.getBytes("gbk"),"latin1");

System.out.println(val5);

String val6= new String(val.getBytes("gbk"),"utf8");

System.out.println(val6);

}

connection.close();

}

}