public User checkForWinner(int gameid) {
    User u = new User();
    try (PreparedStatement statement = connection.prepareStatement(CHECK_FOR_WINNER)) {
      statement.setInt(1, gameid);
      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.setWinner(rs.getInt("winner"));
      }
    } catch (Exception ex) {
    }
    return u;
  }
  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;
  }
  public List<User> getAllUsers() {
    List<User> users = new ArrayList<User>();
    try (PreparedStatement statement = connection.prepareStatement(SELECT_ALL_USERS)) {

      ResultSet rs = statement.executeQuery();
      while (rs.next()) {
        User u = new User();
        u.setUserID(rs.getInt("userid"));
        u.setFirstName(rs.getString("first"));
        u.setLastName(rs.getString("last"));
        u.setWins(rs.getInt("wins"));
        u.setLoses(rs.getInt("loses"));
        u.setEmail(rs.getString("email"));
        users.add(u);
      }
    } catch (Exception ex) {
    }
    return users;
  }