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 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117
| public class RechercheTableModel extends AbstractTableModel {
private int colnum=10;
private int rownum;
private String[] colNames={
"codeclient",...."ville"
};
public ArrayList<String[]> ResultSets;
public ArrayList<String[]> ResultSets1;
int num;
/** Creates a new instance of FoodTableModel */
public RechercheTableModel(ResultSet rs,int a, String r )
{
ResultSets=new ArrayList<String[]>();
ResultSets1=new ArrayList<String[]>();
try{
while(rs.next()){
String[] row={
rs.getString("e_mail"), rs.getString("fax"),rs.getString("telephone1"),rs.getString("ville"),rs.getString("pays"),rs.getString("nomsociete"),rs.getString("nom"),rs.getString("prenom"),rs.getString("typeclient"),rs.getString("codeclient")
};
else
if(a==4)//Recherche selon le ville
{
if (row[3].startsWith(r))
{
ResultSets.add(row);
}
}
else
if(a==5)//Recherche selon le type du client
{
if (row[8].startsWith(r))
{
ResultSets.add(row);
}
}
}
}
catch(Exception e){
System.out.println("Exception in RechercheTableModel");
}
}
public Object getValueAt(int rowindex, int columnindex) {
String[] row=ResultSets.get(rowindex);
return row[columnindex];
}
public int getRowCount() {
return ResultSets.size();
}
public int getColumnCount() {
return colnum;
}
public String getColumnName(int param) {
return colNames[param];
}
}
et voici lecode de la méthode dans la classe ListeClient où il y a la jTable
private void jTextField1KeyReleased(java.awt.event.KeyEvent evt) {
if(jComboBox1.getSelectedItem().equals("Type client"))
{
String enteredText = jTextField1.getText();
ResultSet rs = getResultFromClient();
if ( enteredText.equals(""))
{
cltTable.setModel(new CarTableModel(rs));
}
else
{
cltTable.setModel(new RechercheTableModel(rs,5,enteredText.toString()));
}
}
if(jComboBox1.getSelectedItem().equals("اville"))
{
String enteredText = jTextField1.getText();
ResultSet rs = getResultFromClient();
if ( enteredText.equals(""))
{
cltTable.setModel(CarTableModel(rs));
}
else
{
cltTable.setModel(new RechercheTableModel(rs,4,enteredText.toString()));
}
}
} |
Partager