my DB table employee has the following columns in order empid,name,password,job
my code connects well but when i compare the value taken from the db to my string it doesnt recognise that they are similar. when i test the value of the string from the db, the is a space after the string.
Here is my code
Stmt= conn.prepareStatement("SELECT * FROM employee Where password= '"+password+"' and name = '"+username+"'");
results1 = rs.getString("name");
role = rs.getString("job");