java - retrieving data from database and display using JcomboBox

Question

I would like to be able to select a data from database and display it using the comboBox.

I have the following code but it does not display the data in the comboBox. I do realize there is codes missing to display the data and my SQL statement is not correct. I am just not sure what I can do any advise is appreciated.

try { Statement st = db.con.createStatement(); ResultSet rs = st.executeQuery("SELECT Name, Size, Price FROM item WHERE Name=" + comboBox_1.getToolkit());

                JOptionPane.showMessageDialog(frame, "displayed");

                while (rs.next()) {
                    String name  = rs.getString("Name");
                    String size  = rs.getString("size");
                    String price  = rs.getString("price");
                    textArea_Name.append(name);
                    textArea_size.append(size);
                    textArea_price.append(price);
                    comboBox_1.addItem(rs.getString("Name"));
                    comboBox_1.getSelectedItem();

                }}              


                 catch (SQLException e ) {
                    System.out.println("user not added");
                    e.printStackTrace();
                 }              

            }
        });

You really need to add more information. What have you got so far? — garyamorris
– garyamorris, Commented Feb 17, 2012 at 16:31

mustangDC · Accepted Answer · 2015-06-11 14:32:09Z

2

try {  
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  

Connection conn= DriverManager.getConnection("jdbc:odbc:driverName");  
Statement st = conn.createStatement();

 ResultSet r=st.executeQuery("select * from tableName");

 while (r.next()) {  

     JComboBox.addItem(r.getString("Key_Coloumn_Name"));  
 }


    conn.close();
    } catch (Exception e) {  
JOptionPane.showMessageDialog(null,"Failed to Connect to Database","Error Connection", JOptionPane.WARNING_MESSAGE);  
System.exit(0);  
}

edited Jun 11, 2015 at 14:32

mustangDC

9571 gold badge12 silver badges36 bronze badges

answered Apr 15, 2014 at 7:29

Rahul Sharma

213 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sid · Accepted Answer · 2012-02-17 16:29:48Z

1

Try this tutorial. It does exactly that.

http://www.roseindia.net/tutorial/java/swing/comboboxwithdatabaseValues.html

answered Feb 17, 2012 at 16:29

Sid

7,6412 gold badges31 silver badges42 bronze badges

1 Comment

f1sh Over a year ago

...but afterwards, never visit roseindia ever again. ever.

Aseez Liverpool · Accepted Answer · 2015-03-26 05:17:49Z

1

        try {
             Statement stmt = db.con.createStatement();
        ResultSet rs = stmt5.executeQuery("select * from tbl_your_table");
        while (rs.next()) {
            String pat = rs.getString("name");
            jComboBox.addItem(pat);
        }

    } catch (Exception e) {

        JOptionPane.showMessageDialog(null, e);
    }

answered Mar 26, 2015 at 5:17

Aseez Liverpool

318 bronze badges

Comments

user2130173 · Accepted Answer · 2013-03-20 16:33:13Z

0

    con = DriverManager.getConnection("jdbc:mysql://:3306/database","user","password");
    stat = con.createStatement();
    ResultSet rs = stat.executeQuery("select name from student;");
    while(rs.next()){
        jComboBox1.addItem(rs.getString("name"));
        }
    rs.close();
    stat.close();
    con.close();

answered Mar 20, 2013 at 16:33

user2130173

Comments

Temidayo Omotayo · Accepted Answer · 2018-12-04 11:04:10Z

comb = new JComboBox();
  DefaultComboBoxModel dftm = (DefaultComboBoxModel) comb.getModel();
    ArrayList<stock_data> list = userLists();
     row = new Object[1];
    for (int i = 0; i < list.size(); i++) {
        row[0] = list.get(i).get_item();
        dftm.addElement(row);
        // comb.setModel(dftm);
    }

Then create your method and also remember you need a stock_data Class

private ArrayList<stock_data> userLists() {
    try {

        connection = localhost.dbConnector();
        ArrayList<stock_data> usersList = new ArrayList();
        try {
            String query = "Select * from itemlist";
            Statement st = connection.createStatement();
            ResultSet rs = st.executeQuery(query);
            stock_data users;
            while (rs.next()) {
                // users = new stock_data(rs.getString("name"));
                // usersList.add(users);
                comb.addItem(rs.getString("name"));

            }
            rs.close();
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, "blah blah");
            e.printStackTrace();
        }
        return usersList;
    } catch (Exception e1) {
        e1.printStackTrace();
    }
    return null;
}

Collectives™ on Stack Overflow

java - retrieving data from database and display using JcomboBox

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related