Sorting integer in jtable

Question

when i click the 'Price' radiobutton it sorts the Price Row but in this order

1
11
12
13
2
21
200
3
32
300

how can i fix it? im still new in java. please help me. thanks. :D

rdbtnNewRadioButton_2.addActionListener(new ActionListener() {
        public void actionPerformed(ActionEvent e) {
            DefaultRowSorter sorter = ((DefaultRowSorter)table.getRowSorter());
            List <RowSorter.SortKey> sortKeys = new ArrayList<RowSorter.SortKey>();
            sortKeys.add(new RowSorter.SortKey(4, SortOrder.ASCENDING));
            sorter.setSortKeys(sortKeys); 

        }
    });

score 4 · Accepted Answer · answered Dec 19 '13 at 13:38

4

override getColumnClass in your XxxTableModel, default class is String, the your result from RowSorter is correct
use Integer.Class

answered Dec 19 '13 at 13:38

mKorbel

109,525
20
134
319

score 1 · Answer 2 · edited May 23 '17 at 10:10

1

Write your own comparator and then

sorter.setComparator(int column, Comparator<?> comparator)

refer this Why does my JTable sort an integer column incorrectly?

edited May 23 '17 at 10:10

Community

1
1

answered Dec 19 '13 at 11:36

sadhu

1,429
8
14

how to write my own comparator – Rohan21 Dec 19 '13 at 11:59
Take a look at the Class IntComparator in the link provided http://stackoverflow.com/questions/6592192/why-does-my-jtable-sort-an-integer-column-incorrectly – sadhu Dec 19 '13 at 12:01
i don't quite get it. @.@ sorry still new – Rohan21 Dec 19 '13 at 12:57
not neccessary to use custom Comparator, basic stuff about getColumnClass – mKorbel Dec 19 '13 at 13:39

score 0 · Answer 3 · answered Dec 19 '13 at 11:28

0

Convert your data column to an integer type in order to have the correct order.

SELECT
    ...,
    CAST(YourColumnName as INT) as YourColumnName
    ...
FROM...

answered Dec 19 '13 at 11:28

bjnr

3,353
1
18
32

@Rohan21: should you rebinddata after setting sort key?! – bjnr Dec 19 '13 at 11:36

Sorting integer in jtable

3 Answers3