Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.25 KB | None | 0 0
  1. @FXML private Button btnSalvar;
  2. @FXML private TableView<Partida> tabela;
  3. @FXML private TableColumn<Partida, String> clmTime1;
  4. @FXML private TableColumn<Partida, Integer> clmPlacar1;
  5. @FXML private TableColumn<String, String> clmX;
  6. @FXML private TableColumn<Partida, Integer> clmPlacar2;
  7. @FXML private TableColumn<Partida, String> clmTime2;
  8.  
  9. public void initialize(URL location, ResourceBundle resources) {
  10.  
  11. clmTime1.setCellValueFactory(new PropertyValueFactory<>("cod_time1"));
  12. clmPlacar1.setCellValueFactory(new PropertyValueFactory<>("gol_time1"));
  13. clmX.setCellValueFactory(new PropertyValueFactory<>(""));
  14. clmPlacar2.setCellValueFactory(new PropertyValueFactory<>("gol_time2"));
  15. clmTime2.setCellValueFactory(new PropertyValueFactory<>("cod_time2"));
  16. refreshTable();
  17. }
  18.  
  19. @FXML
  20. private void refreshTable() {
  21. ArrayList<Partida> listaPartida = new partidaDAO().listarPartidas();
  22. ObservableList<Partida> observableList = FXCollections.observableArrayList(listaPartida);
  23. tabela.setItems(observableList);
  24. }
  25.  
  26. select t1.`nome`, `gols_time1`, t2.`nome`, `gols_time2` from partida
  27. inner join `time` t1 on (`time1` = t1.`idtime`)
  28. inner join `time` t2 on (`time2` = t2.`idtime`)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement