Mysql-中文乱码解决方案

最新推荐文章于 2024-09-08 09:00:00 发布

原创最新推荐文章于 2024-09-08 09:00:00 发布 · 158 阅读

0 ·

CC 4.0 BY-SA版权

Mysql 专栏收录该内容

13 篇文章

订阅专栏

本文介绍了解决数据库中中文乱码的问题，提供了两种方法：一是在URL中添加字符集参数，确保使用UTF-8编码；二是修改数据库的编码方式，以支持中文字符。通过示例代码展示了如何在Java程序中配置连接字符串来避免乱码。

中文乱码解决方案

一、在URL后面添加请求参数

?useUnicode=true&characterEncoding=UTF-8

url变成了

jdbc:mysql://localhost:3306/pagination?useUnicode=true&characterEncoding=UTF-8

package JdbcLearn;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class CharacterTest_1 {
    private final static String DRIVER = "com.mysql.jdbc.Driver";
    private final static String URL = "jdbc:mysql://localhost:3306/pagination?useUnicode=true&characterEncoding=UTF-8";
    private final static String USERNAME = "root";
    private final static String PASSWORD = "zbt123456";

    public static void main(String[] args){
        Connection conn = null;
        PreparedStatement pstmt = null;
        try {
            Class.forName(DRIVER);
            conn = DriverManager.getConnection(URL,USERNAME,PASSWORD);
            String sql = "insert into student(firstname,lastname) values(?,?)";
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1,"走");
            pstmt.setString(2,"你");
            pstmt.executeUpdate();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }finally{
            try{
                if(pstmt != null) {
                    pstmt.close();
                }
                if(conn != null) {
                    conn.close();
                }
            }catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

查看数据库效果

+----+-----------+----------+---------+-------------+
| id | firstname | lastname | address | phone       |
+----+-----------+----------+---------+-------------+
| 22 | 走        | 你       | NULL    | NULL        |
+----+-----------+----------+---------+-------------+