Java 连接 mySQL demo function UTF8 避免乱码方法

 

Java连接mySQl

 

要防止乱码发生,一方面在安装mySQL时要正确制定编码的类型

 

如果发生乱码可以尝试在连接字符串中编码设置信息:

 

"jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8";

 

另外还可以尝试在建立连接之后立即设置编码类型:

 

执行SQL语句 "set names utf8"

 

    private Connection getConnection() {String driver = "com.mysql.jdbc.Driver";try {Class.forName(driver);String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8";String user = "root";String password = "root";try {Connection conn = DriverManager.getConnection(url, user,password);Statement stat=conn.createStatement();stat.execute("set names utf8");System.out.println("connection ok");return conn;} catch (SQLException e) {e.printStackTrace();return null;}} catch (ClassNotFoundException e) {e.printStackTrace();return null;}}

 

参考:

http://student.csdn.net/space.php?uid=14032&do=blog&id=36249