populate jCombobox with database data

[joeyxaza]

i would like to populate a jcombobox with data from a database (using two columns, the firstname and lastname). can anyone provide a solution

[markw8500]

After you initiate your connection this should work:

public class TestComboBox {

    private JComboBox combo;
    private Connection sqlCon;
    private Statement st;

    public TestComboBox() {
        initComponents();

    }

    private void initComponents() {

        combo = new JComboBox();


        try {
            
            st = sqlCon.createStatement();

        } catch (SQLException sqle) {
            System.out.println(sqle);
        }

    }

    public JComboBox getComboBox() {

        combo.removeAllItems();
        combo.addItem("Please Select...");

        try {
            
            ResultSet rs = st.executeQuery("select firstname, lastname from myTable");

            while (rs.next()) {
                combo.addItem(rs.getString("firstname") + " " + rs.getString("lastname"));
            }



        } catch (SQLException sqle) {
            System.out.println(sqle);
        }


        return combo;
    }
}

If you want tobe really slick you can override the JComboBox class...

Like so:

public class TestComboBox extends JComboBox {

    private Connection sqlCon;
    private Statement st;
    
    public TestComboBox() {
        super();
        
        initComponents();

    }

    private void initComponents() {

        try {

            
            st = sqlCon.createStatement();

            loadCombobox();


        } catch (SQLException sqle) {
            System.out.println(sqle);
        }

    }



    public void loadCombobox(){

        this.removeAllItems();
        this.addItem("Please Select...");

        try {

            ResultSet rs = st.executeQuery("select firstName, lastName from myTable");

            while (rs.next()) {
                this.addItem(rs.getString("firstname") + " " + rs.getString("lastname"));
            }



        } catch (SQLException sqle) {
            System.out.println(sqle);
        }

    }


}