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
| import javax.swing.JPanel;
import javax.swing.table.TableModel;
import javax.swing.JTable;
import javax.swing.JScrollPane;
import javax.swing.table.DefaultTableModel;
import java.awt.Dimension;
import java.sql.ResultSet;
public class TableEtsModel extends JTable{
Object[][] donnees=new Object[10][6];
public TableEtsModel(){
}
public DefaultTableModel creaTable(String nomClt){
//Création du tableau
String sql="select denominationEts,siegeSocial,adr1Ets,adr2Ets,cpEts,villeEts from etablissements where denominationClt='"+nomClt+"'";
BaseDonnees BD=new BaseDonnees();
ResultSet rst=BD.selectionBD(sql);
int i=0;
try{
while(rst.next())
{
donnees[i][0]=rst.getString("denominationEts");
donnees[i][1]=rst.getString("siegeSocial");
donnees[i][2]=rst.getString("adr1Ets");
donnees[i][3]=rst.getString("adr2Ets");
donnees[i][4]=rst.getString("cpEts");
donnees[i][5]=rst.getString("villeEts");
i++;
}
}
catch(Exception ex){
System.out.println("echec lors de la création de donnees:"+ex.getMessage());
}
String[] nomsColonne={"Nom","Siège social","adresse","","Code postal","Ville"};
DefaultTableModel tableEts=new DefaultTableModel(donnees,nomsColonne);
return tableEts;
}
} |