How to populate a JcomboBox with dynamic data from database

[Manfizy]

Hi guyz,
I want to populate a jcomboBox with data from database everytime i run y program. I am able to get the list from a database but am unable to display it in the combobox.

Any ideas on how i can achieve this will be highly appreciated.

Am using netbeans.

Cheerz!!

[Fubarable]

How do you try to display it in the JComboBox? Do you use a DefaultComboBoxModel object? Can we see your code?

[Manfizy]

How do you try to display it in the JComboBox? Do you use a DefaultComboBoxModel object? Can we see your code?

Well; i have not used the DefaultComboBoxModel object because i do not know how to use it.
Below is the code that am using

public void populateComboBox(){
        String query;
       // Vector fileList = new Vector();
        try {
            statement = getConn.getConnection().createStatement();
            query = "SELECT AcademicYears FROM PathConfig ";

            resultSet = statement.executeQuery(query);

            ResultSetMetaData rsmdt = resultSet.getMetaData();
            int columns = rsmdt.getColumnCount();

            while(resultSet.next()){
            Vector row = new Vector();

            for(int i = 1; i <= columns; i++){
               //row.addElement(resultSet.getString(i));
               fileList.addElement(resultSet.getString(i));
             }
            //fileList.addElement(row);
            }
            statement.close();
            getConn.conn.close();
        } catch (SQLException ex) {
            Logger.getLogger(FrmTranscript.class.getName()).log(Level.SEVERE, null, ex);
        }
        System.out.println("FILE LIST :"+fileList);
               
        jComboBox3 = new JComboBox(fileList);
        
    }

[Fubarable]

I would create a class to hold each row's worth of data and give the class a meaningful toString() method for this is what the combo box will display. I'd then create a DefaultComboBoxModel object and iterate through the resultset creating a new object of the row class and then placing these objects into the model via its addElement method. I'd then make my combo box's model my filled model object.

[Manfizy]

I would create a class to hold each row's worth of data and give the class a meaningful toString() method for this is what the combo box will display. I'd then create a DefaultComboBoxModel object and iterate through the resultset creating a new object of the row class and then placing these objects into the model via its addElement method. I'd then make my combo box's model my filled model object.

Thanks for your reply. Used the DefaultComboBoxModel and got my problem solved.