public User getUserByEmail(String email) { User u = new User(); try (PreparedStatement statement = connection.prepareStatement(SELECT_USER_EMAIL)) { statement.setString(1, email); statement.execute(); ResultSet rs = statement.getResultSet(); while (rs.next()) { u.setUserID(rs.getInt("userid")); u.setFirstName(rs.getString("first")); u.setLastName(rs.getString("last")); u.setIsAdmin(rs.getInt("admin") == 1); u.setWins(rs.getInt("wins")); u.setLoses(rs.getInt("loses")); u.setEmail(rs.getString("email")); } } catch (Exception ex) { } return u; }