java - 将数据库列添加到 JComboBox

Question

我四处寻找这个问题的答案，但没有结果。当我编译它时，它只返回数据库中表的最后一行，而不是我期望的整个列的列表。我相信问题出在这儿..如果我能让它列出该栏中的所有内容，我将不胜感激您的帮助。

String query = "SELECT contact_id, first_name, last_name FROM my_contacts";
ResultSet rs = statement.executeQuery(query);

while (rs.next())
{
    System.out.println(rs.getInt(1) + " " + rs.getString(2) + " " + rs.getString(3));
    String name = rs.getString(2) + " " + rs.getString(3);
        names = new JComboBox();
        names.addItem(rs.getString("first_name"));
}//end while

Answer 1

When I compile this, it just returns the last row of my table in the database and not a list of the entire column as I expect. I believe the problem is from here..

while (rs.next())
{
    System.out.println(rs.getInt(1) + " " + rs.getString(2) + " " + rs.getString(3));
    String name = rs.getString(2) + " " + rs.getString(3);
        names = new JComboBox();
        names.addItem(rs.getString("first_name"));
}

• 您的代码在 while (rs.next()){

  内的每个循环中创建了 JComboBox 的新实例

• 创建 JComboBox 作为局部变量，然后只需将 while-loop 中的 Items 添加到已经存在并已初始化的实例

• 最好的方法是使用 DeafultComboBoxModel 来添加/删除/修改项目JComboBox