how can i update my table with Jtextfield filtering?

[sungirl]

Hi all
I have a big problem :( and i accept any help .
I have a Jtable that show the all customers list that there are in database.
On this table there is textfield for filtering. When a user type a character in the textfield , table must be update and show all customers that their names started by that character same time. For example when i type 's' in textfield ,table would synchronize show all customer list that start with s like 'sara' without pressing any key . I write this code , but it don't work and hass DBexeption.I want use of typedkey event .Please help



// below code is in myFrame.java
private void jTextField1KeyTyped(java.awt.event.KeyEvent evt) {
String st=evt.getKeyText(2);
newCall(st);




}


// Variables declaration - do not modify
private javax.swing.JTable customerTable;
private javax.swing.JButton jButton1;
private javax.swing.JLabel jLabel1;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTextField jTextField1;
// End of variables declaration


private void newCall(String st){
newFill();
try {
List<Customer> customerList = CustomerDAO.getInstance().listCustomersWithName(st );
Vector customerData = new Vector();

for (Customer c : customerList) {
Vector v = c.getCustomerData();
customerData.add(v);
}

Vector column = new Vector();

column.add("pass");
column.add("phone");
column.add("assress");
column.add("name");
column.add("id");


DefaultTableModel model = new DefaultTableModel(customerData, column);

customerTable.setModel(model);

} catch (DBException ex) {
JOptionPane.showMessageDialog(null, "database exception .");
}

}



//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~
private void newFill(){
Vector customerData = new Vector();
customerData=null;
Vector column = new Vector();
column=null;
DefaultTableModel model = new DefaultTableModel(customerData, column);
customerTable.setModel(model);
}

//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~
private void fillCustomerList() {
try {
List<Customer> customerList = CustomerDAO.getInstance().listCustomers();

Vector customerData = new Vector();

for (Customer c : customerList) {
Vector v = c.getCustomerData();
customerData.add(v);
}

Vector column = new Vector();
column.add("pass");
column.add("phone");
column.add("assress");
column.add("name");
column.add("id");

DefaultTableModel model = new DefaultTableModel(customerData, column);

customerTable.setModel(model);

} catch (DBException ex) {
JOptionPane.showMessageDialog(null, "database exception .");
}
}


Regars,

[eRaaaa]

Simple thing.
Use the TableRowSorter!

final TableRowSorter<TableModel> sorter = new TableRowSorter<TableModel>(model);

And add a DocumentListener to your textfield - in insertUpdate and removeUpdate you call sorter.setRowFilter(RowFilter.regexFilter(yourtext field.getText(),indeces));

[sungirl]

Thanks for your reply , but I don't have removeupdate and insertupdate in my code. What is your mean exactly ?please explain more . tanx a lot

[eRaaaa]

yeah, the insertUpdate method belongs to the listener :)
so you have to add a documentlistener to your textfield !!

here is a simple example

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.RowFilter;
import javax.swing.SwingUtilities;
import javax.swing.event.DocumentEvent;
import javax.swing.event.DocumentListener;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;
import javax.swing.table.TableRowSorter;

public class FilterSnippet {
	
	private final TableRowSorter<TableModel> sorter;
	private JTextField field;

	public FilterSnippet(){
		JFrame frame = new JFrame();
		JPanel panel = new JPanel(new BorderLayout());
		field = new JTextField(10);
		field.getDocument().addDocumentListener(new DocumentListener() {  // <---
			@Override
			public void removeUpdate(DocumentEvent e) {
				filter();
			}
			
			@Override
			public void insertUpdate(DocumentEvent e) {
				filter();
			}
			
			@Override
			public void changedUpdate(DocumentEvent e) {}
		});
		DefaultTableModel model = new DefaultTableModel(new String[][]{{"Sarah","foo"}, {"Abc","bar"}, {"def","foobar"}}, new String[]{"Name","Nickname"});
		JTable table = new JTable(model);
		sorter = new TableRowSorter<TableModel>(model);  // <-- 
		table.setRowSorter(sorter);  // <-- 
		panel.add(field, BorderLayout.PAGE_START);
		panel.add(new JScrollPane(table),BorderLayout.CENTER);
		frame.add(panel);
		frame.pack();
		frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		frame.setLocationRelativeTo(null);
		frame.setVisible(true);
	}

	protected void filter() {
		sorter.setRowFilter(RowFilter.regexFilter("^(?i)"+field.getText(),0));  // <--
	}

	public static void main(String[] args) {
		SwingUtilities.invokeLater(new Runnable() {
			public void run() {
				new FilterSnippet();
			}
		});
	}
}

the important rows are marked. these rows(similar) you have to put into your code!

[sungirl]

Oh yes , you r right :)
but i want connect to the database and from there the table's data be update.
For example when i type A the program must be connect to database and get all customer with name that started A and then show them in table. yor code is right but how can i connect to this database?:(

can i email to you all my code ?