Mysql-中文乱码解决方案

中文乱码解决方案

一、在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        |
+----+-----------+----------+---------+-------------+

二、修改数据库编码方式

参考文章

https://blog.csdn.net/qq_30832659/article/details/52623775