using queries

[Justin Fox]

i want to compare textfield input with values in the database, this is what i have so far.

    
public static class LoginListener implements ActionListener{
public void actionPerformed(ActionEvent event)
{
if(event.getSource() == login)
{
TYPE = users[userType.getSelectedIndex()];
if(TYPE.equals("Student"))
{
String userlogin = "'"+Sname.getText()+"'";
String userPass  = "'"+SID.getText()+"'";
String whereClause = ("WHERE FName = "+userlogin +" AND "+"SID = "+userPass);
try{
Statement statement = con.createStatement();
ResultSet rs = statement.executeQuery("SELECT FName FROM STUDENTS "+whereClause);
while(rs.next())
{
System.out.println(rs.getString("FName") + " ");
}
 
if(!rs.wasNull())
{
LoginFrame.dispose();
Student.setVisible(true);
}
else { /*show dialog*/ System.out.println("user not found"); }
rs.close();
statement.close();
   }catch(SQLException sqle) 
{
System.out.println("jdbc error: "+sqle);
}
 

}
else
{
        LoginFrame.dispose();
Admin.setVisible(true);
}
 

}
}
}

for some reason the wasnull isnt doing what i thought it would do...

Justin

[Chad Clites]

What do you suppose wasNull() is supposed to do? What did you expect it to do?