السلام عليكم ورحمة الله وبركاته,
عندما أستخدم insert لقاعدة البيانات, تتم العملية بنجاح... لكن الكتابة العربية تظهر على هية علامات استفهام؟
هل مرت هذه المشكلة بأي شخص من الاخوان؟
import java.sql.*;
class ConnectAndInsert {
public static void main (String args[]) {
Connection dbConn = null;
String stdName=new String("أحمد علي الساحلي");
String stdNumber=new String("16276556221");
try {
Driver d = (Driver)Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String URL = "jdbc:odbc:" + "JDBC DB";
dbConn = DriverManager.getConnection(URL, "nouser", "nopassword");
// Java SQL objects...
Statement stmt,stmtInsrt;
ResultSet rs;
stmt = stmtInsrt = dbConn.createStatement();
stmtInsrt.executeUpdate("insert into Names(stdName,stdNumber) values(\'" + stdName +"\',\'"+ stdNumber +"\')");
rs = stmt.executeQuery("SELECT * FROM Names");
while (rs.next())
System.out.println ( rs.getString("stdName") + " \"" + rs.getString("stdNumber") +"\"" );
dbConn.close();
System.out.println("db connection closed.");
}
catch (Exception e) {
System.out.println("خطأ في الاتصال. \n");
e.printStackTrace();
}
} // end main
} // end classimport java.sql.*;
class ConnectAndInsert {
public static void main (String args[]) {
Connection dbConn = null;
String stdName=new String("أحمد علي الساحلي");
String stdNumber=new String("1122221");
try {
Driver d = (Driver)Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String URL = "jdbc:odbc:" + "JDBC Energy";
dbConn = DriverManager.getConnection(URL, "nouser", "nopassword");
System.out.println("db Connected...\n");
Statement stmt,stmtInsrt;
ResultSet rs;
stmt = stmtInsrt = dbConn.createStatement();
stmtInsrt.executeUpdate("insert into Names(stdName,stdNumber) values(\'" + stdName +"\',\'"+ stdNumber +"\')");
rs = stmt.executeQuery("SELECT * FROM Names");
while (rs.next())
System.out.println ( rs.getString("stdName") + " \"" + rs.getString("stdNumber") +"\"" );
dbConn.close();
System.out.println("db connection closed.");
}
catch (Exception e) {
System.out.println("خطأ في الاتصال. \n");
e.printStackTrace();
}
} // end main
} // end class