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
|
modeleArticle.clear();
Article article ;
try {
Statement state = ArticleDAO.connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY );
ResultSet result = state.executeQuery("SELECT * FROM article LEFT JOIN famille_article ON id_famille_article = famille_article.id LEFT JOIN categorie_article ON id_categorie_article = categorie_article.id "
);
while(result.next())
{
article = new Article(result.getInt("id"), result.getInt("n_papillon"), result.getString("code"),result.getString("gisement_secondaire"), result.getString("label"), result.getString("unite"), result.getFloat("stock"), result.getFloat("prix_unitaire"), result.getInt("rang"), result.getInt("stock_mini"), result.getDate("date_creation"),result.getDate("date_modification"), result.getString("checkout"));
Object[] temp = {article.getId_article(),article.getN_papillon(),article.getGisement_secondaire(),article.getCode_article(), "",article.getLabel_article(),article.getUnite_article(),article.getStock_article(),article.getPrix_article(),article.getRang_article(),article.getStockmini_article(),article.getDate_creation(),article.getDate_modification(),article.getCheckout_article(),"","", ""};
modeleArticle.addRow(temp);
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
tableauArticle.setModel(modeleArticle);
calculer_total();
sorter = new TableRowSorter<TableModel>(tableauArticle.getModel());
tableauArticle.setRowSorter(sorter); |
