Java连接过中的MySQL中文乱码问题.docVIP

本文将为大家讲解如何处理Java连接过程中的MySQL中文乱码问题。一般MySQL中文乱码问题都是与字符集有关，这里作者的经历也大致差不多。 MySQL默认编码是latin1 mysql?show?variables?like?character%; ? +--------------------------+--------------------------+ ? |?Variable_name????????????|?Value????????????????????| ? +--------------------------+--------------------------+ ? |?character_set_client?????|?latin1???????????????????| ? |?character_set_connection?|?latin1???????????????????| ? |?character_set_database???|?latin1???????????????????| ? |?character_set_filesystem?|?binary???????????????????| ? |?character_set_results????|?latin1???????????????????| ? |?character_set_server?????|?latin1???????????????????| ? |?character_set_system?????|?utf8?????????????????????| ? |?character_sets_dir???????|?D:\MySQL\share\charsets\?| ? +--------------------------+--------------------------+ ? 创建数据表并插入数据 ? mysql?use?test; ? mysql?create?table?messages?( ? ????-?id?int(4)?unsigned?auto_increment?primary?key, ? ????-?message?varchar(50)?not?null? ????-?)?engine=myisam?default?charset=utf8; ? mysql?insert?into?messages?(message)?values?(测试MySQL中文显示); ? mysql?select?*?from?messages; ? +----+-------------------+ ? |?id?|?message???????????| ? +----+-------------------+ ? |??1?|?测试MySQL中文显示?| ? +----+-------------------+ ? 编写程序（Java） ? import?java.sql.Connection; ? import?java.sql.DriverManager; ? import?java.sql.ResultSet; ? import?java.sql.Statement; ? public?class?JDBCTest?{ ? ????public?static?void?main(String[]?args)?{ ? ????????String?driver?=?com.mysql.jdbc.Driver; ? ????????String?url?=?jdbc:mysql://localhost:3306/test; ? ????????String?user?=?root; ? ????????String?password?=?root; ? ????????try?{ ? ????????????Class.forName(driver); ? ????????????Connection?conn?=?DriverManager.getConnection(url,?user,?password); ? ????????????Statement?stmt?=?conn.createStatement(); ? ????????????stmt.executeUpdate(insert?into?messages?(message)?values?(测试MySQL编码)); ? ????????????ResultSet?rs?=?stmt.executeQuery(select?*?from?messages); ? ????????????while?(r