Combobox

[asai]

Hi,

I want a ComboBox that gets data from a MySQL table and then I will use the selected value into another table.

Have tried a little my self... First of all i need to get the data into the combo.
How is the code for this?

[camickr]

So what is your problem?

Do you know how to use SQL? Do you know how to create a loop to get all the data from the ResultSet?

Do you know how to hard code data and create a ComboBoxModel?

[DarrylBurke]

Have you decided which GUI toolkit you would like to use for this? AWT? Swing? SWT? JFace? Something else?

db

[asai]

I'm using Netbeans as GUI toolkit. Swing combobox
I know how to use SQL. The problem is the resultset.
An example would be great.

[DarrylBurke]

NetBeans is an IDE, not a GUI toolkit. If you're using Swing, you would be using JComboBox -- not 'combobox'

Now answer camickr's question

Do you know how to hard code data and create a ComboBoxModel?

db

[asai]

Sorry, I have been away for a few days...

First I have a line of query to the database:

public class ComboForm extends javax.swing.JFrame {
    private VectorData vectordata = LedgerTable.SelectAll();

Actually the connection and query is in its own class...

Heres the code generated by Netbeans, including one line of custom code:

 private void initComponents() {

        jComboBox1 = new javax.swing.JComboBox();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        jComboBox1.setModel(vectordata.getData());

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGap(112, 112, 112)
                .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 150, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(138, Short.MAX_VALUE))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGap(83, 83, 83)
                .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addContainerGap(195, Short.MAX_VALUE))
        );

        pack();
    }

The custom line is this one:

jComboBox1.setModel(vectordata.getData());

Hopefully you have enough information to guide me to the correct custom line here...