MySQL无法写入中文解决方法

时间：2008-10-14 来源：fly928sky

一、配置my.ini文件
将位于...\MySQL\MySQL Server 6.0路径下的my.ini文件中
两处default-character-set设置为utf-8 二、方法处理方法1：java.sql.DriverManager.getConnection中urlString写法
String urlString = "jdbc:mysql://localhost:3306/mysql?user=root&password=123456&characterEncoding=utf-8";
必须添加characterEncoding=utf-8

注意：import java.sql.DriverManager;

方法2：重写java.sql.DriverManager.getConnection方法

package com.yourcompany;
import java.sql.Connection;
import java.sql.SQLException;
public class DriverManager
{
    public static Connection getConnection(String url) throws SQLException
    {
         Connection connection = null;
         connection = java.sql.DriverManager.getConnection(url+"&characterEncoding=utf-8");
         return connection;
    }

    public static Connection getConnection(String url, String user, String password) throws SQLException
    {
         Connection connection = null;
         connection = java.sql.DriverManager.getConnection(url+"?user="+user+"&password="+password+"&characterEncoding=utf-8");
         return connection;
    }
}