Question

如何将数据库中获得的数据ResultSet结果添加到JComboBox中做下拉项？

JComboBox airCompanycb = new JComboBox();
Class.forName("com.mysql.jdbc.Driver");
java.sql.Connection conn1 = DriverManager.getConnection("jdbc:mysql://localhost:3306/airsystemmssgdb","root","123");
Statement stat1 = conn1.createStatement();
String aircompany = "select distinct 航空公司 from airmsg ";
ResultSet aircompanyrs = stat1.executeQuery(aircompany);
大虾们，请问怎么将上面的aircompanyrs结果添加给airCompanycb做下拉项？希望有详细代码！谢谢了！

Answer 1

while( aircompanyrs.next() ) {
airCompanycb.addItem( aircompanyrs.getString(1) );
}

追问

可是我把combobox加到JPanel中去，但是内容还是显示不出来啊？怎么会这样呢

追答

import javax.swing.*;
public class T6
{
  public static void main(String[] args) throws Exception {
    JFrame frame = new JFrame("t1");
    frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    JPanel panel = new JPanel();
    frame.getContentPane().add("Center", panel);
    JComboBox cb = new JComboBox();
    cb.addItem("00001");
    cb.addItem("00002");
    cb.addItem("00003");
    cb.addItem("00004");
    panel.add(cb);
    frame.setLocation(200,200);
    frame.setSize(300, 300);
    frame.setVisible(true);  
  }
} 
没讲的问题呀

追问

已经搞定了！谢谢你了！