Search in SQL table through JTextField key released with both UPPERCASE or LOWERCASE

Question

I want to search customer name in SQL table through JTextField key released in NetBeans.

Here is my code of JTextField key released :

DefaultTableModel table = (DefaultTableModel)jTable1.getModel(); 
String search = jTextField1.getText(); 
TableRowSorter<DefaultTableModel> tr = new  TableRowSorter<DefaultTableModel>(table);

jTable1.setRowSorter(tr);
tr.setRowFilter(RowFilter.regexFilter(search));

For example, If I want to find a customer name " RoNaldo " when I write starting word like that " ronaldo " then it's not working. Actually when writing the same word like that " RoNaldo " then it would be shown in the table. So, please provide me the right code for this.

score 0 · Answer 1 · 2019-03-01T04:28:39.490

0

You have to use something like this,

DefaultTableModel table = (DefaultTableModel)jTable1.getModel();
TableRowSorter<DefaultTableModel> tr = new  TableRowSorter<DefaultTableModel>(table);

String search = jTextField1.getText().toLowerCase();
if (search.trim().length() == 0) {
      tr.setRowFilter(null);
   } else {
      tr.setRowFilter(RowFilter.regexFilter("(?i)" + search));
 }

edited Mar 01 '19 at 04:28

answered Mar 01 '19 at 04:04

Did you put that in jTextField1 key released event? – Mar 01 '19 at 04:21
YES, BUT IT'S NOT SEARCHING ANY THING – Umair Zubairi Mar 01 '19 at 04:24
Updated my answer. – Mar 01 '19 at 04:40

score 0 · Answer 2 · answered Mar 01 '19 at 04:14

0

Esto le ayudará: How can I perform a case-insensitive filter on a JTable?

Pero sin mas nada, la expresión regular que debe usar es "(?i)"+search :

tr.setRowFilter(RowFilter.regexFilter("(?i)" + search));

answered Mar 01 '19 at 04:14

José Eras

90
4

Amigo, en el link que le proporcioné, las dos respuestas propuestas puede implementar. La segunda respuesta es una buena opción también. – José Eras Mar 01 '19 at 04:25
pero lo comprobé en jtext keyreleased ... no está buscando nada – Umair Zubairi Mar 01 '19 at 04:34

score 0 · Answer 3 · answered Mar 01 '19 at 08:07

0

Besides a case-insensitive search, also sorting on that column should be case-insensitive ideally.

final int nameColumn = 1;
tr.setComparator(nameColumn, (lhs, rhs) -> ((String)lhs).compareToIgnoreCase((String) rhs));

The above assumes the column to be 1, adapt it to the correct one.

answered Mar 01 '19 at 08:07

Joop Eggen

107,315
7
83
138

I checked this code in JTextField key released but it's not working ... please provide me complete code – Umair Zubairi Mar 01 '19 at 17:54

Search in SQL table through JTextField key released with both UPPERCASE or LOWERCASE

3 Answers3