How to add multiple items to the DefaultComboBoxModel

Question

I have the following code but I don't know how to add all of the items to my combobox.

DefaultTableModel rs = MyDB.DataTable("SELECT `Activity` FROM `transactions` WHERE `Group` = '" + Gname.getText()+ "' OR `Group` = 'ALL'");

DefaultComboBoxModel dmc = new DefaultComboBoxModel();

dmc.addElement("");

if (rs.getRowCount() > 0) {
    dmc.addElement(rs.getValueAt(0,0).toString());
}

cboItem.setModel(dmc);

It only adds one item to my DefaultTableModel, how can I add all of them?

You want to add values to `DefaultComboBoxModel ` or `DefaultTableModel` ? — Apurv, Mar 19 '13 at 03:58
1) Use a consistent and logical indent for code blocks. The indentation of the code is intended to help people understand the program flow. 2) For better help sooner, post an [SSCCE](http://sscce.org/). — Andrew Thompson, Mar 19 '13 at 04:00
See [*Using a Combo Box as an Editor*](http://docs.oracle.com/javase/tutorial/uiswing/components/table.html#combobox). — trashgod, Mar 19 '13 at 04:01
the list of rs are in MySQL, so when I call the items I want I Will put it all in the ITEMS of my combobox @Apurv — kelvzy, Mar 19 '13 at 04:35

Apurv · Accepted Answer · 2013-03-19T04:39:05.953

3

The constructor of DefaultComboBoxModel takes Object[]. You can first iterate over the rs values prepare an array (or list) and then pass this array to DefaultComboBoxModel constructor. Like this ...

DefaultTableModel rs = MyDB.DataTable("SELECT `Activity` FROM `transactions` WHERE `Group` = '" + Gname.getText()+ "' OR `Group` = 'ALL'");
int columnCount = rs.getColumnCount();
int rowCount = rs.getRowCount();

List <Object> values = new ArrayList<Object>();
for (int rowIndex = 0; rowIndex < rowCount; rowIndex ++){
    for(int columnIndex = 0; columnIndex < columnCount; columnIndex++){
         Object value = rs.getValueAt(rowIndex , columnIndex );
         values.add(value);
    }
}
DefaultComboBoxModel dmc = new DefaultComboBoxModel(values.toArray());

edited Mar 19 '13 at 04:39

answered Mar 19 '13 at 04:02

Apurv

3,723
3
30
51

non-static method getValueAt(int,int) cannot be referenced from a static context – kelvzy Mar 19 '13 at 04:25
With `defaultTableModel` I mean object of `DefaultTableModel` which in your case is `rs` – Apurv Mar 19 '13 at 04:27
the list of `rs` are in MySQL, so when I call the items I want I Will put it all in the ITEMS of my combobox @Apurv – kelvzy Mar 19 '13 at 04:33
type List does not take parameters @Apurv `List – kelvzy Mar 19 '13 at 04:44
What do you mean by this ? – Apurv Mar 19 '13 at 04:47
There is no issue with the code I posted. `List – Apurv Mar 19 '13 at 05:04
`type List does not take parameters` thats the error it red line in my netbeans – kelvzy Mar 19 '13 at 05:07
1

It's common courtesy to "accept" an answer here on SO. Feel free to check the answer you feel that solves your problem. – Apurv Mar 19 '13 at 06:53

How to add multiple items to the DefaultComboBoxModel

1 Answers1

Linked