public class AvaliacaoDAO {
public Avaliacao getAvaliacao(String codigo) {
Connection conexao = Conexao.getSqlConnection();
Avaliacao avaliacao = new Avaliacao();
try {
Statement statement = conexao.createStatement();
statement.executeQuery("SELECT * FROM avaliacao WHERE codigoAvaliacao = " + codigo);
AulaAvaliativaController entrevistaCtrl = new AulaAvaliativaController();
ResultSet resultSet = statement.getResultSet();
while (resultSet.next()) {
AulaAvaliativa aulaAvaliativa = new AulaAvaliativa();
aulaAvaliativa = entrevistaCtrl.getAulaAvaliativa(String.valueOf(resultSet.getInt("codigoAulaAvaliativa")));
avaliacao = new Avaliacao();
avaliacao.setCodigoAvaliacao(resultSet.getInt("codigoAvaliacao"));
avaliacao.setData(Data.converteDataMysqlBr(resultSet.getString("data")));
avaliacao.setHora(resultSet.getString("hora"));
avaliacao.setTema(resultSet.getString("tema"));
avaliacao.setDisciplina(resultSet.getString("disciplina"));
avaliacao.setAulaAvaliativa(aulaAvaliativa);
}
resultSet.close();
statement.close();
} catch (Exception erro) {