while循环的问题（JTextField 和JComboBox组件可以放在一个while里吗？）

Question

String sql = "select name,price from db where userid='" + tfQueryid.getText() + "'";
ResultSet rs = wdb.executeQuery(sql);
while(rs.next()){
    tfName.setText(rs.getString("name"));
    jlPrice.addItem(rs.getString("price"));
}

Answer 1

这样就可以了吗？？
我想把里面的所有字段都显示出来实际的程序是这样的：        String sql = "select * from db where userid=\'" + tfQueryid.getText() +
            "\'";
        ResultSet rs = wdb.executeQuery(sql);
        
       while(rs.next())
        {
          tfUserid.setText( rs.getString("userid"));
          tfName.setText(rs.getString("name"));
          tfAddress.setText(rs.getString("address"));
          tfCardinalnum.setText(rs.getString("cardinalnum"));          jlCategory.addItem(rs.getString(4));
          jlPrice.addItem(rs.getString("price"));
          jlTollgatherer.addItem(rs.getString("tollgatherer"));
        }

Answer 2

问题已解决 多谢nimifeng及各位朋友,问题的关键是 按字段顺序来取....