السلام عليكــم ورحمة الله ..
أنشأت قاعدة بيانات للطلاب ثم ربطها بكود الجافا ..لكن ظهر عندي إكسبشن وماعرفت إيش بالضبط ؟؟
SEVERE: null java.sql.SQLException: No data found at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7137) at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3072) at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:323) at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174) at java.sql.DriverManager.getConnection(DriverManager.java:579) at java.sql.DriverManager.getConnection(DriverManager.java:243) at javaapplication105.login.connect(login.java:49) at javaapplication105.login.<init>(login.java:33) at javaapplication105.login.main(login.java:120) Exception in thread "main" java.lang.NullPointerException at javaapplication105.login.connect(login.java:54) at javaapplication105.login.<init>(login.java:33) at javaapplication105.login.main(login.java:120) Java Result: 1
أعتذر عن طرح المشكله لكن هذا أول محاوله لي بالربط .... ؟؟
وهذا الكـــود مبسط :::
public class login {
Connection connect;
Statement statement;
ResultSet resualt;
JFrame f=new JFrame(" User Login ");
JLabel l=new JLabel("StudentID:");
JLabel l1=new JLabel(" studentName:");
JTextField t=new JTextField(10);
JTextField t1=new JTextField(10);
JButton b=new JButton("login");
public login() {
connect();
creatFrame();
}
public void connect()
{
try {
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
Class.forName(driver);
String db="jdbc:odbc:loginSystem";
connect=DriverManager.getConnection(db);
statement=connect.createStatement();
} catch (Exception ex) {
Logger.getLogger(login.class.getName()).log(Level.SEVERE, null, ex);
}
}
public void creatFrame()
{
f.setSize(600,400);
f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
f.setVisible(true);
JPanel p=new JPanel();
p.add(l);
p.add(t);
p.add(l1);
p.add(t1);
p.add(b);
b.addActionListener(new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
try {
String user=t.getText().trim();
String pass=t1.getText().trim();
String sql="select student-id,studentName from student where student-id='"+ user +"' and studentName= '" + pass +"'";
//execute sql quary
resualt=statement.executeQuery(sql);
int count=0;
while( resualt.next())
{
count+=1;
}
if (count ==1)
{
JOptionPane.showMessageDialog(null,"User Found");
}
else
JOptionPane.showMessageDialog(null,"User NOT Found!");
} catch (Exception ex) {
}
}});
f.add(p);
}
public static void main(String[]args)
{
new login();
}
}جزاكم رب خير
