public ArrayList<Turma> listarTurmaPorProfessor(String cpfProfessor) throws SQLException {
ResultSet rs;
PreparedStatement pstm;
ArrayList<Turma> listaTurmas = new ArrayList<>();
try {
pstm =
conexaoMySQL()
.prepareStatement(
"SELECT dp.codigo_disciplina, dp.codigo_professor, dp.codigo_turma,d.nome_disciplina,u.nome, t.nome_turma FROM disciplina_por_professor dp inner join professor p on p.codigo_professor = dp.codigo_professor inner JOIN usuario u on u.cpf = p.cpf inner JOIN turma t on t.codigo_turma = dp.codigo_turma inner join disciplina d on d.codigo_disciplina = dp.codigo_disciplina where p.cpf = "
+ cpfProfessor);
rs = pstm.executeQuery();
while (rs.next()) {
Turma turma = new Turma();
turma.setCodigoDisciplina(Integer.parseInt(rs.getString("codigo_disciplina")));
turma.setCodigoProfessor(Integer.parseInt(rs.getString("codigo_professor")));
turma.setCodigoTurma(Integer.parseInt(rs.getString("codigo_turma")));
turma.setNomeDisciplina(rs.getString("nome_disciplina"));
turma.setNomeProfessor(rs.getString("nome"));
turma.setNomeTurma(rs.getString("nome_turma"));
listaTurmas.add(turma);
}
return listaTurmas;
} catch (SQLException e) {
throw new SQLException("Erro ao criar lista de alunos - " + e.getMessage());
}
}
public ArrayList<Turma> listarTurmas() throws SQLException {
ResultSet rs;
PreparedStatement pstm;
ArrayList<Turma> listaTurmas = new ArrayList();
try {
pstm =
conexaoMySQL()
.prepareStatement(
"select dpp.codigo_turma,t.nome_turma,dpp.codigo_disciplina,d.nome_disciplina,dpp.codigo_professor,u.nome \n"
+ "from disciplina_por_professor as dpp \n"
+ "inner join turma as t on t.codigo_turma = dpp.codigo_turma \n"
+ "INNER join disciplina as d on d.codigo_disciplina = dpp.codigo_disciplina \n"
+ "inner join professor as p on p.codigo_professor = dpp.codigo_professor \n"
+ "inner join usuario as u on u.cpf = p.cpf");
rs = pstm.executeQuery();
while (rs.next()) {
Turma turma = new Turma();
turma.setCodigoDisciplina(Integer.parseInt(rs.getString("codigo_disciplina")));
turma.setCodigoProfessor(Integer.parseInt(rs.getString("codigo_professor")));
turma.setCodigoTurma(Integer.parseInt(rs.getString("codigo_turma")));
turma.setNomeDisciplina(rs.getString("nome_disciplina"));
turma.setNomeProfessor(rs.getString("nome"));
turma.setNomeTurma(rs.getString("nome_turma"));
listaTurmas.add(turma);
}
} catch (SQLException e) {
JOptionPane.showMessageDialog(null, "Erro ao consultar turmas" + e.getMessage());
}
return listaTurmas;
}
