中文乱码解决方案
一、在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 |
+----+-----------+----------+---------+-------------+