requestbean.java

java书 java书 java书 java书 java书 java书

            players = (List<Player>) em.createNamedQuery(
                        "roster.entity.Player.findPlayersBySport")
                                       .setParameter("sport", sport)
                                       .getResultList();

            return copyPlayersToDetails(players);
        } catch (Exception ex) {
            throw new EJBException(ex);
        }
    }

    @SuppressWarnings("unchecked")
    public List<PlayerDetails> getPlayersByCity(String city) {
        logger.info("getPlayersByCity");

        List<Player> players = null;

        try {
            players = (List<Player>) em.createNamedQuery(
                        "roster.entity.Player.findPlayersByCity")
                                       .setParameter("city", city)
                                       .getResultList();

            return copyPlayersToDetails(players);
        } catch (Exception ex) {
            throw new EJBException(ex);
        }
    }

    @SuppressWarnings("unchecked")
    public List<PlayerDetails> getAllPlayers() {
        logger.info("getAllPlayers");

        List<Player> players = null;

        try {
            players = (List<Player>) em.createNamedQuery(
                        "roster.entity.Player.findAllPlayers")
                                       .getResultList();

            return copyPlayersToDetails(players);
        } catch (Exception ex) {
            throw new EJBException(ex);
        }
    }

    @SuppressWarnings("unchecked")
    public List<PlayerDetails> getPlayersNotOnTeam() {
        logger.info("getPlayersNotOnTeam");

        List<Player> players = null;

        try {
            players = (List<Player>) em.createNamedQuery(
                        "roster.entity.Player.findPlayersNotOnTeam")
                                       .getResultList();

            return copyPlayersToDetails(players);
        } catch (Exception ex) {
            throw new EJBException(ex);
        }
    }

    @SuppressWarnings("unchecked")
    public List<PlayerDetails> getPlayersByPositionAndName(
        String position,
        String name) {
        logger.info("getPlayersByPositionAndName");

        List<Player> players = null;

        try {
            players = (List<Player>) em.createNamedQuery(
                        "roster.entity.Player.findPlayersByPositionAndName")
                                       .setParameter("name", name)
                                       .setParameter("position", position)
                                       .getResultList();

            return copyPlayersToDetails(players);
        } catch (Exception ex) {
            throw new EJBException(ex);
        }
    }

    @SuppressWarnings("unchecked")
    public List<LeagueDetails> getLeaguesOfPlayer(String playerId) {
        logger.info("getLeaguesOfPlayer");

        List<LeagueDetails> detailsList = new ArrayList<LeagueDetails>();
        List<League> leagues = null;

        try {
            Player player = em.find(Player.class, playerId);
            leagues = (List<League>) em.createNamedQuery(
                        "roster.entity.Player.findLeaguesByPlayer")
                                       .setParameter("player", player)
                                       .getResultList();
        } catch (Exception ex) {
            throw new EJBException(ex);
        }

        Iterator<League> i = leagues.iterator();

        while (i.hasNext()) {
            League league = (League) i.next();
            LeagueDetails leagueDetails = new LeagueDetails(
                        league.getId(),
                        league.getName(),
                        league.getSport());
            detailsList.add(leagueDetails);
        }

        return detailsList;
    }

    @SuppressWarnings("unchecked")
    public List<String> getSportsOfPlayer(String playerId) {
        logger.info("getSportsOfPlayer");

        List<String> sportsList = new ArrayList<String>();
        List<String> sports = null;

        try {
            Player player = em.find(Player.class, playerId);
            logger.info(
                    "RequestBean.getSportsOfPlayer: finding sports of "
                    + player.getName());
            sports = (List<String>) em.createNamedQuery(
                        "roster.entity.Player.findSportsByPlayer")
                                      .setParameter("playerId", playerId)
                                      .getResultList();

            if (sports.isEmpty()) {
                logger.info(
                        "RequestBean.getSportsOfPlayer: no sports returned");
            }
        } catch (Exception ex) {
            throw new EJBException(ex);
        }

        Iterator<String> i = sports.iterator();

        while (i.hasNext()) {
            String sport = (String) i.next();
            sportsList.add(sport);
        }

        return sportsList;
    }

    public void createTeamInLeague(
        TeamDetails teamDetails,
        String leagueId) {
        logger.info("createTeamInLeague");

        try {
            League league = em.find(League.class, leagueId);
            Team team = new Team(
                        teamDetails.getId(),
                        teamDetails.getName(),
                        teamDetails.getCity());
            em.persist(team);
            team.setLeague(league);
            league.addTeam(team);
        } catch (Exception ex) {
            throw new EJBException(ex);
        }
    }

    public void removeTeam(String teamId) {
        logger.info("removeTeam");

        try {
            Team team = em.find(Team.class, teamId);
            em.remove(team);
        } catch (Exception ex) {
            throw new EJBException(ex);
        }
    }

    public TeamDetails getTeam(String teamId) {
        logger.info("getTeam");

        TeamDetails teamDetails = null;

        try {
            Team team = em.find(Team.class, teamId);
            teamDetails = new TeamDetails(
                        team.getId(),
                        team.getName(),
                        team.getCity());
        } catch (Exception ex) {
            throw new EJBException(ex);
        }

        return teamDetails;
    }

    public void createLeague(LeagueDetails leagueDetails) {
        logger.info("createLeague");

        try {
            League league = new League(
                        leagueDetails.getId(),
                        leagueDetails.getName(),
                        leagueDetails.getSport());
            em.persist(league);
        } catch (Exception ex) {
            throw new EJBException(ex);
        }
    }

    public void removeLeague(String leagueId) {
        logger.info("removeLeague");

        try {
            League league = em.find(League.class, leagueId);
            em.remove(league);
        } catch (Exception ex) {
            throw new EJBException(ex);
        }
    }

    public LeagueDetails getLeague(String leagueId) {
        logger.info("getLeague");

        LeagueDetails leagueDetails = null;

        try {
            League league = em.find(League.class, leagueId);
            leagueDetails = new LeagueDetails(
                        league.getId(),
                        league.getName(),
                        league.getSport());
        } catch (Exception ex) {
            throw new EJBException(ex);
        }

        return leagueDetails;
    }

    private List<PlayerDetails> copyPlayersToDetails(List<Player> players) {
        List<PlayerDetails> detailsList = new ArrayList<PlayerDetails>();
        Iterator<Player> i = players.iterator();

        while (i.hasNext()) {
            Player player = (Player) i.next();
            PlayerDetails playerDetails = new PlayerDetails(
                        player.getId(),
                        player.getName(),
                        player.getPosition(),
                        player.getSalary());
            detailsList.add(playerDetails);
        }

        return detailsList;
    }
}