java - JDBC returning a result set -

i have database few columns login screen, trying compare entered email persons password in database.

i have following code, although keep getting error saying column email not exist, although in database. ideas?

    public string getplayerpassword(string emailparameter) throws sqlexception {     loadsqldriver();      string playersemail = null;      prestmt = con.preparestatement("select playerpassword players email = ?");     prestmt.setstring(1, emailparameter);      rs = prestmt.executequery();      if(rs.next()){          playersemail = rs.getstring("email");     }      return playersemail; } 

this may because dint select email in query

prestmt = con.preparestatement("select playerpassword players email = ?"); 

and fetching it

playersemail = rs.getstring("email");