السلام عليكم ورحمة الله وبركاته
كيف استطيع ربط الداتا بيس مع الجافا باستخدام الابلت
عندما كتبت الكود ع الفريم اشتغل ولكن عند تحويله الى ابلت اظهر لي الاكسبشن
MYSQL Test
java.lang.ExceptionInInitializerError
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:286)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at NewClass1.init(NewClass1.java:25)
at sun.applet.AppletPanel.run(AppletPanel.java:424)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.security.AccessControlException: access denied (java.util.PropertyPermission file.encoding read)
at java.security.AccessControlContext.checkPermission(AccessControlContext.java:323)
at java.security.AccessController.checkPermission(AccessController.java:546)
at java.lang.SecurityManager.checkPermission(SecurityManager.java:532)
at java.lang.SecurityManager.checkPropertyAccess(SecurityManager.java:1285)
at java.lang.System.getProperty(System.java:650)
at com.mysql.jdbc.StringUtils.<clinit>(StringUtils.java:70)
... 6 moreوهذا هو الكود
import java.sql.*;
import java.awt.BorderLayout;
import javax.swing.*;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import java.util.ArrayList;
import javax.swing.table.DefaultTableModel;
public class NewClass1 extends JApplet{
public static javax.swing.JTable table = new JTable();
static DefaultTableModel jdtm= new DefaultTableModel();
public void init() {
Connection conn = null;
System.out.println("MYSQL Test");
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/example","root","root");
}
catch (Exception e) {
System.out.println(e);
System.exit(0);
}
System.out.println("Connection established");
try {
Statement s = conn.createStatement();
ResultSet r = s.executeQuery
("SELECT studentName, subject,mark FROM student");
while(r.next()) {
System.out.println ("Student name is "+
r.getString("studentName") + " and the Subject is " +
r.getString("subject") );
String a=r.getString("studentName");
String b=r.getString("subject");
String c=r.getString("mark");
Object obj[] = {a,b,c};
jdtm.addRow(obj);
// Object o = new Object();
}
}
catch (Exception e) {
e.printStackTrace();
}
table.setModel(jdtm);
jdtm.addColumn("Name");
jdtm.addColumn("subject");
jdtm.addColumn("mark");
// Make the frame
JFrame frame = new JFrame("JFrame and JTable example 2");
frame.setSize(550, 200);
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); // Action when window closes
// Make table
JScrollPane scrollPane = new JScrollPane(table); // Make scrollpane with table
// Add scrollpane with table to the frame and show the frame to user
frame.getContentPane().add(scrollPane, BorderLayout.CENTER);
frame.getContentPane().add(new JLabel(" Data from studant shcema"+" \n\n\n\n ") , BorderLayout.NORTH);
frame.getContentPane().add(new JLabel(" ") , BorderLayout.EAST);
frame.getContentPane().add(new JLabel(" ") , BorderLayout.WEST);
frame.getContentPane().add(new JLabel(" ") , BorderLayout.SOUTH);
frame.setVisible(true);
}
/*public static void main(String [] args) {
NewClass1 frame = new NewClass1();
Connection conn = null;
System.out.println("MYSQL Test");
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/example","root","root");
}
catch (Exception e) {
System.out.println(e);
System.exit(0);
}
System.out.println("Connection established");
try {
Statement s = conn.createStatement();
ResultSet r = s.executeQuery
("SELECT studentName, subject,mark FROM student");
while(r.next()) {
System.out.println ("Student name is "+
r.getString("studentName") + " and the Subject is " +
r.getString("subject") );
String a=r.getString("studentName");
String b=r.getString("subject");
String c=r.getString("mark");
Object obj[] = {a,b,c};
jdtm.addRow(obj);
// Object o = new Object();
}
}
catch (Exception e) {
e.printStackTrace();
}
}*/
}