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
| public void AffichageTableau (Clients oClients)
{
{
try {
db = new Database();
db.Ouverture();
//CREATION DE LA TABLE
DefaultTableModel TableClient = new DefaultTableModel()
{
@Override
public boolean isCellEditable (int row, int col)
{
return false;
}
};
//EN TETE DU TABLEAU
TableClient.setColumnIdentifiers(new String [] {"NOM", "PRENOM", "TELEPHONE", "MAIL"});
Requete = "SELECT * FROM `gestionrestaurant`.`client` ORDER BY `NomClient`";
db.Requete(Requete);
Resultat = db.getRs();
while (Resultat.next())
{
//ajout de ligne
TableClient.addRow(new Object[]{Resultat.getString(2), Resultat.getString(3),Resultat.getInt(4),Resultat.getString(5)});
}
if (TableClient.getRowCount()<0)
{
while (TableClient.getRowCount()<0)
{
TableClient.addRow(new Object[]{"",""});
}
}
oClients.getTb_ListeClient().setModel(TableClient);
db.Fermeture();
} catch (SQLException ex) {
Logger.getLogger(MethodeClient.class.getName()).log(Level.SEVERE, null, ex);
}
} |
Partager