1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
| String sql="";
try
{
Statement requete = ConnectionBD.createStatement();
sql="select DISTINCT annee from etudiant ORDER BY annee DESC";
ResultSet resultat = requete.executeQuery(sql);
while (resultat.next())
{
annee.ajoute(resultat.getString(1));
}
try
{
Statement requete1 = ConnectionBD.createStatement();
sql="select DISTINCT * from options,etudiant WHERE etudiant.code_option=options.code_option AND annee=+resulta.getString(1)+" ORDER BY options.code_option";
ResultSet resulta = requete1.executeQuery(sql);
while (resulta.next())
{
option.ajoute(resulta.getString(1)+" - "+resulta.getString(2));
}
}
catch (SQLException se)
{
JOptionPane.showMessageDialog(this,sql+"\n"+se.getMessage(),"Chargement de la table impossible !",JOptionPane.ERROR_MESSAGE);
}
}
catch (SQLException se)
{
JOptionPane.showMessageDialog(this,sql+"\n"+se.getMessage(),"Chargement de la table impossible !",JOptionPane.ERROR_MESSAGE);
} |
Partager