Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void GetSelected()
- {
- try {
- Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","system","9844941149");
- String query = "Select *from Magnet_Master order by Cust_Id asc";
- PreparedStatement stmt=con.prepareStatement(query);
- ResultSet rs=stmt.executeQuery();
- table.setModel(DbUtils.resultSetToTableModel(rs));
- }
- catch(Exception e)
- {
- System.out.println(e);
- }
- }
- The below is the code for search in Jtable or Model. tf_Search_12 is my Textfield.
- tf_Search_12.getDocument().addDocumentListener( new DocumentListener() {
- @Override public void insertUpdate(DocumentEvent e)
- {
- Search(tf_Search_12.getText().toUpperCase());
- }
- @Override public void removeUpdate(DocumentEvent e)
- {
- Search(tf_Search_12.getText().toUpperCase());
- }
- @Override public void changedUpdate(DocumentEvent e)
- {
- Search(tf_Search_12.getText().toUpperCase());
- }
- public void Search(String s)
- {
- final TableRowSorter<TableModel> Sorter1 = new TableRowSorter<>(Model);
- JTable table = new JTable(Model);
- table.setRowSorter(Sorter1);
- JTable_Scroll.setViewportView(table);
- table.setModel(Model);
- String copyString = s;
- copyString.toUpperCase();
- if(copyString.length()==0) {
- Sorter1.setRowFilter(null);
- Sorter1.getModelRowCount();
- }
- else {
- Sorter1.setRowFilter(RowFilter.regexFilter(copyString));
- }
- }
- });`
Add Comment
Please, Sign In to add comment