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; }