private Player resultSetToPlayer(ResultSet rs) throws SQLException {
        Player player = new Player();
        player.setId(rs.getLong("id"));
        player.setName(rs.getString("name"));
        player.setSurname(rs.getString("surname"));
        player.setPlayerNumber(rs.getByte("number"));
        player.setTeamID(rs.getLong("teamid"));
        player.setHome(rs.getInt("home") != 0);
        player.setAway(rs.getInt("away") != 0);
        switch (rs.getString("position")){
            case "GOALTENDER" :
                player.setPlayerPosition(PlayerPosition.GOALTENDER);
                break;
            case "DEFENCEMAN" :
                player.setPlayerPosition(PlayerPosition.DEFENCEMAN);
                break;
            case "FORWARD" :
                player.setPlayerPosition(PlayerPosition.FORWARD);
                break;
            case "ALTERNATE" :
                player.setPlayerPosition(PlayerPosition.ALTERNATE);
                break;            
        }
        
        return player;
    }