Databse items to Jcombobox

[pra.deep]

Hi...Everyone..:)

I need to know how to add database items to jcombobox....

Help me.. to solve this ...

[r035198x]

What have you tried and where exactly are you stuck?

[pra.deep]

I have Purchase table, i like add purchaseorder no column to combobox...whenever i put new purchase order that purchase order no should be automatically updated in the combo box...

  JComboBox PONO;

   rs1=stmt6.executeQuery("select * from Purchase");
                
                while(rs1.next()) 
                {
                      
               uni[]=(rs1.getString(5)); // this column show error
                PONO=new  JComboBox(uni);        
              }

[r035198x]

What did you hope to achieve with that line that shows an error?
Write a method that (inside some data access class) returns the array of data items to put into your comboxes.
Use the array returned to create a DefaultComboBoxModel that you set as the model for your combobox. The result is that SQL code does not get mixed with swing code.

[pra.deep]

shall i use getSelected item() to get the database item .... just give me one example to understand better...

Plz.....


Thanks & Regards

Pra.deep

[r035198x]

The getSelectedItem method has nothing to do with getting values from your database. Write a separate class with a method that gets the values from the database. That method should no nothing about Comboboxes. It must just get the values you want from the database and return the data as an array. Test that method and make sure it works as required.
You then read the API specs link I posted above to find out how to use a constructor to create a model that holds the arrays values. Set that model as your combobox's model.

[pra.deep]

Ok... i ll try... Thanks....