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
| Vector<Vector<String>> abonnesVector=new Vector<Vector<String>>();
Statement state = (Statement) Connexion.getInstance().createStatement();
/* String query="SELECT a.matricule, a.nomabon, a.prenomabon, a.telephone, a.somme,SUM( montant ) FROM abonnes AS a, cotisation AS b";
query +="WHERE a.matricule = b.matricule";
query +="GROUP BY a.matricule";*/
String query="SELECT Designation_actes,Montant FROM creation_actes";
check1 = new JCheckBox();
ResultSet result =state.executeQuery(query);
while(result.next()){
Vector<String> abonnes=new Vector<String>();
abonnes.add(javax.swing.check1);
abonnes.add(result.getString("Designation_actes"));
abonnes.add(result.getString("Montant"));
abonnesVector.add(abonnes);
}
if(state!=null);
state.close();
return abonnesVector;
}
public Test() throws SQLException {
data=getAbonnes();
header=new Vector<String>();
header.add("Cocher");
header.add("La Designation");
header.add("Le Montant");
initComponents();
} |
Partager