1 2 3 4 5 6 7 8 9 10 11
|
Statement instruction = con.createStatement();
String sql = " SELECT A.Dte, A.N_piece, A.Piece, CAST( A.Item AS integer ) Item, A.RUBRIC, R.LIBELLE, A.Montant, P.NOM, P.PRENOM FROM Avances A INNER JOIN Personnel P ON (P.MATRICULE = A.MATR) INNER JOIN Rubrique R ON ( A.RUBRIC = R.CODE) WHERE ( A.MATR = '10063') AND (R.Affect = '559') ; ";
ResultSet resultat1 = instruction.executeQuery(sql);
String valeur1;
while (resultat1.next()) {
valeur1= resultat1.getString("A.Dte");
System.out.println("la valeur de la stratégie"+valeur1);
} |
Partager