如何使用java将阿拉伯语单词插入mysql数据库 [英] How can I insert arabic word to mysql database using java

问题描述

我有一个java应用程序，想要将阿拉伯语单词插入mysql数据库，我的代码看起来像

I have a java application, want to insert arabic words to mysql database, my code looks like

Connection con = null;
    String url = "jdbc:mysql://localhost/";
    String db = "students";
    String driver = "com.mysql.jdbc.Driver";
    try {
        Class.forName(driver);
        con = DriverManager.getConnection(url+db,"root","");
        Statement st = con.createStatement();
        String name = new String(txtName.getText().getBytes(), "UTF-8");
        int val = st.executeUpdate("insert into student(name, roll) VALUES('"+name+"','"+txtRoll.getText()+"')");
    } catch (Exception ex) {
        ex.printStackTrace();
    }

但它只插入'??????'。我现在该怎么办？

But it only insert '??????'. what can i do now?

推荐答案

在db变量声明后添加此变量：

add this variable after db variable declaration:

String unicode= "?useUnicode=yes&characterEncoding=UTF-8";

然后修改你的行：

con = DriverManager.getConnection(url+db,"root","");

到

con = DriverManager.getConnection(url+db+unicode,"root","");

这篇关于如何使用java将阿拉伯语单词插入mysql数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！