Jump to content

liee

Members
  • Posts

    1
  • Joined

  • Last visited

liee's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. 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..??
×
×
  • Create New...