content.add(new JTextField(),BorderLayout.SOUTH);
jtextfield1 = new JTextField();
jtextfield1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
Filter();
}
});
String sql ="select * from article";
try {
affiche(sql);
} catch (SQLException ex) {
Logger.getLogger(table_affiche.class.getName()).log(Level.SEVERE, null, ex);
} // TODO add your handlin
}
public void affiche(String sql) throws SQLException{
manipulation m = new manipulation();
try{
m.connect();
m.statement= m.con.createStatement();
java.sql.ResultSet rs = m.statement.executeQuery(sql);
String col[] = { " code_article ", " designation ", " prix de vente " ," quantité de stock "," emplacement "," date de stock "};
int k=nbligne();
String cont[][] = new String[k][6];
int i = 0;
while (rs.next()) {
String code = rs.getString(1);
String des = rs.getString(2);
int p = rs.getInt(3);
int q = rs.getInt(4);
String emp = rs.getString(5);
String d = rs.getString(6);
cont[i][0] = code;
cont[i][1] = des;
cont[i][2] = p+" ";
cont[i][3] = q+" ";
cont[i][4] = emp;
cont[i][5] = d;
i++;
}
tableau = new JTable(cont, col){
public boolean isCellEditable(int row, int column) {
public static void main(String[] args) {
new table_affiche().setVisible(true);
}
public int nbligne()throws SQLException{
manipulation m = new manipulation();
m.connect();
java.sql.Statement s = m.con.createStatement() ;
java.sql.ResultSet r = s.executeQuery("SELECT count(*) AS nbLignes FROM article ");
int nbLignes=0;
r.next();
nbLignes = r.getInt("nbLignes");
s.close();
m.con.close();
return nbLignes;