private void jMenuItem5ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: try{ { String h2=txtrecherche.getText(); h2="'"+h2+"'"; rs=st.executeQuery("select * from commande where Produit="+h2); model.setRowCount(0); } while(rs.next()){ Object [] commande ={rs.getString(1),rs.getString(2),rs.getInt(3),rs.getString(4),rs.getString(5),rs.getString(6).toString()}; model.addRow(commande); }if (model.getRowCount()==0){JOptionPane.showMessageDialog(null,"aucune commande"); }else{int i=0; deplace(i);} }catch(Exception e){ System.out.println(e); JOptionPane.showMessageDialog(null,e.getLocalizedMessage()); } }
private void rechercheKeyReleased(java.awt.event.KeyEvent evt) { String rech = recherche.getText().toUpperCase(); DefaultTableModel model = (DefaultTableModel) stagiaire.getModel(); TableRowSorter<DefaultTableModel> tr = new TableRowSorter<>(model); stagiaire.setRowSorter(tr); tr.setRowFilter(javax.swing.RowFilter.regexFilter(rech)); }