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
| public PRODUIT() {
initComponents();
this.setTitle("GESTION DES STOCKS");
dtm = new DefaultTableModel();
dtm.addColumn("REFERENCE");
dtm.addColumn("DESIGNATION");
dtm.addColumn("QUANTITE ENTREE");
dtm.addColumn("PRIX UNITAIRE");
dtm.addColumn("STOCK MINIMAL");
dtm.addColumn("STOCK D'ALERTE");
dtm.addColumn("STOCK MAXIMUM");
tab.setModel(dtm);
}
void liste() {
try {
Statement st;
String sql = "SELECT * FROM PRODUIT ORDER BY REF_PROD";
st = con.createStatement();
ResultSet rs = st.executeQuery(sql);
for (int i = dtm.getRowCount() - 1; i >= 0; i--) {
dtm.removeRow(i);
}
while (rs.next()) {
String[] list_dat = new String[7];
list_dat[0] = rs.getString("ref_prod");
list_dat[1] = rs.getString("designation_prod");
list_dat[2] = rs.getString("quantite_entree");
list_dat[3] = rs.getString("prix_achat_prod");
list_dat[4] = rs.getString("stock_mini_prod");
list_dat[5] = rs.getString("stock_alerte_prod");
list_dat[6] = rs.getString("sotck_maxi_prod");
dtm.addRow(list_dat);
}
} catch (SQLException ex) {
JOptionPane.showMessageDialog(rootPane, ex.getMessage());
}
} |
Partager