英文:
How do i populate list of values to a Checkcombobox (ControlsFX) from database
问题
我正在尝试从我的数据库中填充外键值列表到一个 CheckComboBox 中，自昨晚以来我没有取得任何进展。我正在使用 ControlsFX 8.40.15。
以下是我一直在做的：
@FXML
private CheckComboBox<String> privilages;
final ObservableList<String> privList = FXCollections.observableArrayList();
@FXML
private void loadPrivilages(MouseEvent event) {
try {
String quy = "SELECT `idPermission` FROM `Permission`";
setPs(datahandler.prepareStatement(quy));
setRs(getPs().executeQuery());
} catch (SQLException ex) {
Logger.getLogger(StaffController.class.getName()).log(Level.SEVERE, null, ex);
}
try {
while (getRs().next()) {
privilages.getItems().addAll(getRs().getString("idPermission"));
}
ObservableList privListing = privilages.getCheckModel().getCheckedItems();
//privilages.setItems(privList);
} catch (SQLException ex) {
Logger.getLogger(StaffController.class.getName()).log(Level.SEVERE, null, ex);
}
}
英文:
I am trying to populate list of foreign key values to a Checkcombobox from my database since last night i have not made any progress. i am using ControlsFX 8.40.15
this is what i have been doing:
@FXML
private CheckComboBox<String> privilages;
final ObservableList<String> privList = FXCollections.observableArrayList();
@FXML
private void loadPrivilages(MouseEvent event) {
try {
String quy = "SELECT `idPermission` FROM `Permission`";
setPs(datahandler.prepareStatement(quy));
setRs(getPs().executeQuery());
} catch (SQLException ex) {
Logger.getLogger(StaffController.class.getName()).log(Level.SEVERE, null, ex);
}
try {
while (getRs().next()) {
privilages.getItems().addAll(getRs().getString("idPermission"));
}
ObservableList privListing = privilages.getCheckModel().getCheckedItems();
//privilages.setItems(privList);
} catch (SQLException ex) {
Logger.getLogger(StaffController.class.getName()).log(Level.SEVERE, null, ex);
}
}
专注分享java语言的经验与见解，让所有开发者获益！
评论