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 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68
|
final String url = "jdbc:odbc:dbrescue";
Connection con = null;
Statement requete = null;
boolean trouv = false;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
con = DriverManager.getConnection(url,"","");
requete = con.createStatement();
ResultSet resultat1 = requete.executeQuery("select N_INTERINT, DATE_ENTREE, DATE_INTERINT, DATE_FACTURATION, DATE_SORTIE, PROBLEMATIQUE, DESCRIPTION, COUT, MODE_PAIEMENT, INTSTATUT, N_CLIENT from Interventioninter where N_CLIENT ="+Rclient.Nmclient+" ");
Object[] cols = {"N° d'intervention", "Date d'entrée", "Date d'intervention", "Date de facturation", "Date de sortie", "Problèmatique", "Coût", "Mode de paiement", "Statut"};
while (resultat1.next()) {
Nveninter = resultat1.getString(1);
Dentreinter= resultat1.getString(2);
Dinterveninter = resultat1.getString(3);
Dfacturinter =resultat1.getString(4);
Dsorinter =resultat1.getString(5);
Pveninter= resultat1.getString(6);
Descripinter =resultat1.getString(7);
Cveninter =resultat1.getString(8);
Modpinter =resultat1.getString(9);
Statinter =resultat1.getString(10);
Object[][] data =
{{Nveninter, Dentreinter, Dinterveninter, Dfacturinter, Dsorinter, Pveninter, Descripinter, Cveninter, Modpinter,Statinter}};
JTable tab = new JTable (data, cols);
tab.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
tab.setBounds(200,250,800,100);
JScrollPane stop = new JScrollPane(tab);
pan.add(tab); }
try {
if (Nveninter == null)
throw new Exception();
} catch (Exception e) {
JLabel Labeltet=new JLabel("Aucune intervention trouvée");
Labeltet.setFont(new Font("TimesRoman", Font.BOLD, 40));
Labeltet.setForeground(Color.red);
Labeltet.setBounds(500,150,500,35);
pan.add(Labeltet);
}
} catch (ClassNotFoundException e1) {
e1.printStackTrace();
} catch (SQLException e2) {
e2.printStackTrace();
} catch (Exception e3) {
e3.printStackTrace();
}
finally {
try {con.close();
requete.close();
}
catch(final SQLException e1) {e1.printStackTrace();}
} |
Partager