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
| private void MonComboItemStateChanged(java.awt.event.ItemEvent evt) {
try{
stmt=maconnexion.con.createStatement();
String req=("SELECT DATE_ECRITURE,NUM_FICHE,SENS_ECRITURE,MONTANT_ECRITURE,ECRITURE_LIBELLE,CODE_PIECE,NUM_PIECE,MANDAT,IMPUTATION_BUDGETAIRE from DGTCP2014.RO_ECRITURES WHERE COMPTE='"+MonCombo.getSelectedItem()+"'");
rs=stmt.executeQuery(req);
while(rs.next()){
DATE_ECRITURE=rs.getDate("DATE_ECRITURE");
NUM_FICHE=rs.getString("NUM_FICHE");
//SENS_ECRITURE=rs.getString("SENS_ECRITURE");
ECRITURE_LIBELLE=rs.getString("ECRITURE_LIBELLE");
MONTANT_ECRITURE=rs.getInt("MONTANT_ECRITURE");
CODE_PIECE=rs.getString("CODE_PIECE");
NUM_PIECE=rs.getString("NUM_PIECE");
MANDAT=rs.getInt("MANDAT");
IMPUTATION_BUDGETAIRE=rs.getString("IMPUTATION_BUDGETAIRE");
Object []line={DATE_ECRITURE,NUM_FICHE,MONTANT_ECRITURE,ECRITURE_LIBELLE,CODE_PIECE,NUM_PIECE,MANDAT,IMPUTATION_BUDGETAIRE};
dt.addRow(line);
Table1.setModel(dt);
}
}
catch(Exception e){
System.out.println(e.getMessage());
}
} |
Partager