예제 #1
0
  private void LoadAccounts() {

    ObservableList<DropdownData> accountItems = FXCollections.observableArrayList();

    ResultSet rs = main.DM.Execute("SELECT * FROM bank_account ORDER BY title");

    try {
      rs.beforeFirst();

      while (rs.next()) {
        accountItems.add(new DropdownData(rs.getString("id"), rs.getString("title")));
      }
    } catch (SQLException ex) {
      Logger.getLogger(FrontendController.class.getName()).log(Level.SEVERE, null, ex);
    }

    accounts.setItems(accountItems);
  }
예제 #2
0
  /** @param selectedAccount */
  private void LoadProjects(DropdownData selectedAccount) {

    ObservableList<DropdownData> projectItems = FXCollections.observableArrayList();

    ResultSet rs =
        main.DM.Execute(
            "SELECT * FROM bank_project WHERE accountID='"
                + selectedAccount.value
                + "' ORDER BY name");

    try {
      rs.beforeFirst();

      while (rs.next()) {
        projectItems.add(new DropdownData(rs.getString("id"), rs.getString("name")));
      }
    } catch (SQLException ex) {
      Logger.getLogger(FrontendController.class.getName()).log(Level.SEVERE, null, ex);
    }

    projects.setItems(projectItems);
  }