connot check customer id in database...

[liee]

public void check() { String nama=name.getText(); String icnom=icno.getText(); String idnum=idno.getText(); String user = ""; String pass = ""; String url = "JDBC:ODBC:8cc"; String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; try{ stmt=con.createStatement(); String query="Select * FROM customer WHERE idno=('"+idnum+"')"; ResultSet rs=stmt.executeQuery(query); if(rs.next()) { String dbpass=rs.getString(idnum); if(dbpass.equals("")) { JOptionPane.showMessageDialog(this, "you are members", "Success", JOptionPane.INFORMATION_MESSAGE); } else { JOptionPane.showMessageDialog(this, "you are not member", "Success", JOptionPane.QUESTION_MESSAGE); } } } catch(SQLException e) { System.out.println(e.getMessage()); } } *cannot check customer id in my database...why..??

[justsomeguy]

That is not a Javascript question, but you should verify all of your variables as the first step, make sure they all have the correct values. Things like name, icno, and idno might not be set to what you think they are. A SQL error might also be going somewhere you don't expect, maybe print that message in the same place as the other dialogs.