package dao.impl;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;

import javax.sql.DataSource;

import model.Player;
import model.Team;

import org.springframework.jdbc.core.SqlParameter;
import org.springframework.jdbc.object.MappingSqlQuery;

class PlayerListQuery extends MappingSqlQuery<Player> {

    private static String SQL_PLAYER_LIST_QUERY = "SELECT player_id, player.name AS playerName, "
            + " team.team_id, team.name AS teamName "
            + " FROM player, team WHERE player.team_id = team.team_id AND team.team_id = ?";

    public PlayerListQuery(DataSource ds) {
        super(ds, SQL_PLAYER_LIST_QUERY);
        super.declareParameter(new SqlParameter("team_id", Types.INTEGER));
        compile();
    }

    protected Player mapRow(ResultSet rs, int rowNum) throws SQLException {
        // ResultSet¿¡¼­ ÃëµæÇÑ °ªÀ» °´Ã¼¿¡ ³Ö±â
        Player player = new Player();
        player.setId(rs.getInt("player_id"));
        player.setName(rs.getString("playerName"));
        Team team = new Team();
        team.setId(rs.getInt("team_id"));
        team.setName(rs.getString("teamName"));
        player.setTeam(team);

        return player;
    }
}