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

[CODE]

Stmt= conn.prepareStatement("SELECT * FROM employee Where password= '"+password+"' and name = '"+username+"'");
Stmt.executeQuery();
rs= Stmt.getResultSet();
while(rs.next())
{
results1 = rs.getString("name");
role = rs.getString("job");

}
if(results1 != null){
//role == "Admin"
String Admin = "Admin ";
if(role.equals(Admin)){
response.sendRedirect("admin_page.jsp?user="+resul ts1);
}
else if(role == "Operator"){
response.sendRedirect("operator_page.jsp?user="+re sults1);
}
else if(role == "Supervisor"){
response.sendRedirect("supervisor_page.jsp?user="+ results1);
}
else if(role == "Auditor"){
response.sendRedirect("auditor_page.jsp?user="+res ults1);
}
else if(role == "Manager"){
response.sendRedirect("manager_page.jsp?user="+res ults1);
}
else{
out.println("User has no roles" + role + "...");
}
}
else{
out.println("Please check your password");
}
[CODE]

output = User has no rolesAdmin ...