Display Value in JcomboBox

[daina]

Hi,
I am new to java.Can u Plz help me.I have a JcomboBox. I want to display all the ItemId from the database in that JComboBox. I don't know how to do that.Can any one plz help me.Can anybody give some sample code

The code is:-
public Iterator selectItemID(){
Iterator itemNo;
ArrayList itemNumber = null;
try {
statement = dbConnection.prepareStatement("select ItemId from ItemDetails");
ResultSet itemNumberResult = statement.executeQuery();
while(itemNumberResult.next())
{
itemNo = (Iterator) itemNumberResult.getString(1);
System.out.println("itemNo " +itemNo);
return (Iterator) itemNo ;
}
} catch (SQLException e) {
e.printStackTrace();
}
return (Iterator) itemNumber;

}

itemno=new JComboBox();
DbActivity dbconnection = new DbActivity();

Iterator result= dbconnection.selectItemID();
itemno.addItem(result);


Regards
Diana

[NPH]

I believe the while loop is running only one time. Comment the return statement out.

For more help, www.NeedProgrammingHelp.com

[daina]

Hi ,
I commented the return statement. It is printing all the itemId in the Console.but in the combobox it is printing only the last record id. Can u please tell me what to do.

The code is:-

public String selectItemID(){
String itemNo = null;

try {
statement = dbConnection.prepareStatement("select ItemId from ItemDetails");
ResultSet itemNumberResult = statement.executeQuery();
while(itemNumberResult.next())
{
itemNo = itemNumberResult.getString(1);
System.out.println("itemNo " +itemNo);
//return itemNo ;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return itemNo;

}
itemno=new JComboBox();
DbActivity dbconnection = new DbActivity();

String result= dbconnection.selectItemID();
itemno.addItem(result);
System.out.println("Result "+result);

[nspils]

You are creating a new comboBox every time you run through the loop.

Have you tried to create one comboBox (called something, say "myComboBox"), and then when a new item number is chosen, call myComboBox.addItem(itemNo)? You won't create a new combo box, and you'll be adding the new item numbers to the item list in the box.

[NaveenVooka]

Hi,
I am new to java.Can u Plz help me.I have a JcomboBox. I want to display all the ItemId from the database in that JComboBox. I don't know how to do that.Can any one plz help me.Can anybody give some sample code

http://www.codeguru.com/forum/showthread.php?t=356834

---------------
Naveen Vooka
www.devsquare.com
DevSquare - Online Application Development

[daina]

Hi

I used Vector.but the records are not displaying in the jcombobox.It is printing the values in the console. I think the problem is with the line ' itemno=new JComboBox(result);' I am getting the values from the selectItemID() method.but it is not assigning it to the jcombobox.

the code is:-
public Vector selectItemID(){
Vector result = new Vector();

try {
statement = dbConnection.prepareStatement("select ItemId from ItemDetails");
ResultSet itemNumberResult = statement.executeQuery();
while(itemNumberResult.next())
{
String itemNo = itemNumberResult.getString(1);
System.out.println("itemNo " +itemNo);
result.add(itemNo); // add all found itemNos
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return result;

}


DbActivity dbconnection = new DbActivity();

Vector result= dbconnection.selectItemID();
itemno=new JComboBox(result); // construct Combo with Vector
//System.out.println("Result "+result);

[nspils]

You have the line "return result;" in your code. To what are you "returning" the Vector "result"?

It sounds like you are populating the Vector - (have you tried to print out the values stored in the Vector to make sure that it is populated) - but it looks to me that there is no connection between the Vector "result" you are populating and the "result" you are passing to the JComboBox constructor.

[bavishek]

Actually I am inserting vlaue into Vector() in one class and I want to extract particular item out of it into JCombox()