Guest User

Untitled

a guest
Apr 25th, 2018
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.97 KB | None | 0 0
  1. public void GetSelected()
  2. {
  3.  
  4. try {
  5. Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","system","9844941149");
  6. String query = "Select *from Magnet_Master order by Cust_Id asc";
  7. PreparedStatement stmt=con.prepareStatement(query);
  8. ResultSet rs=stmt.executeQuery();
  9. table.setModel(DbUtils.resultSetToTableModel(rs));
  10. }
  11. catch(Exception e)
  12. {
  13. System.out.println(e);
  14. }
  15. }
  16.  
  17. The below is the code for search in Jtable or Model. tf_Search_12 is my Textfield.
  18.  
  19. tf_Search_12.getDocument().addDocumentListener( new DocumentListener() {
  20.  
  21.  
  22. @Override public void insertUpdate(DocumentEvent e)
  23. {
  24. Search(tf_Search_12.getText().toUpperCase());
  25. }
  26.  
  27. @Override public void removeUpdate(DocumentEvent e)
  28. {
  29. Search(tf_Search_12.getText().toUpperCase());
  30.  
  31. }
  32. @Override public void changedUpdate(DocumentEvent e)
  33. {
  34. Search(tf_Search_12.getText().toUpperCase());
  35. }
  36. public void Search(String s)
  37. {
  38. final TableRowSorter<TableModel> Sorter1 = new TableRowSorter<>(Model);
  39. JTable table = new JTable(Model);
  40. table.setRowSorter(Sorter1);
  41. JTable_Scroll.setViewportView(table);
  42. table.setModel(Model);
  43.  
  44. String copyString = s;
  45. copyString.toUpperCase();
  46. if(copyString.length()==0) {
  47. Sorter1.setRowFilter(null);
  48. Sorter1.getModelRowCount();
  49. }
  50. else {
  51. Sorter1.setRowFilter(RowFilter.regexFilter(copyString));
  52. }
  53. }
  54. });`
Add Comment
Please, Sign In to add comment