Search code examples
javacsvjavafxfxmlscenebuilder

How to import .csv or .txt files to be displayed on tableview of High Score Menu created with Scenebuilder and JavaFX


I'm trying to design a high score menu for a project I've been maintaining and I would like to be able to use a .txt or .csv file to store and retrieve all of the top scores for this project to be displayed on a highscore menu I built with Scenebuilder but I'm having trouble doing so. So far I've tried using the traditional method of reading from a file but I can't seem to get that to input into the the text area of scenebuilder. Any help is appreciated. Thanks.

Highscore.fxml:

<?xml version="1.0" encoding="UTF-8"?>

<?import javafx.scene.control.Label?>
<?import javafx.scene.control.TableColumn?>
<?import javafx.scene.control.TableView?>
<?import javafx.scene.layout.AnchorPane?>
<?import javafx.scene.layout.StackPane?>
<?import javafx.scene.layout.VBox?>
<?import javafx.scene.text.Font?>

<AnchorPane prefHeight="400.0" prefWidth="600.0" xmlns="http://javafx.com/javafx/11.0.1" xmlns:fx="http://javafx.com/fxml/1" fx:controller="Controller.HighscoreController">
   <children>
      <VBox prefHeight="400.0" prefWidth="601.0">
         <children>
            <StackPane prefHeight="77.0" prefWidth="601.0" style="-fx-background-color: #242322;">
               <children>
                  <Label text="Highscores" textFill="#045a61">
                     <font>
                        <Font name="Wingdings" size="62.0" />
                     </font>
                  </Label>
               </children>
            </StackPane>
            <StackPane layoutX="10.0" layoutY="10.0" prefHeight="327.0" prefWidth="601.0">
               <children>
                  <TableView fx:id="table">
                    <columns>
                      <TableColumn fx:id="numColumn" prefWidth="322.6665954589844" text="No." />
                      <TableColumn fx:id="nameColumn" prefWidth="201.33331298828125" text="Name" />
                        <TableColumn fx:id="scoreColumn" prefWidth="81.3333740234375" text="Score" />
                    </columns>
                     <columnResizePolicy>
                        <TableView fx:constant="CONSTRAINED_RESIZE_POLICY" />
                     </columnResizePolicy>
                  </TableView>
               </children>
            </StackPane>
         </children>
      </VBox>
   </children>
</AnchorPane>

Highscore.java

package Model;

import java.io.File;
import java.util.Scanner;

public class Highscore {

    int numColumn, ScoreColumn;
    String nameColumn;

    public int getNumColumn() {
        return numColumn;
    }

    public void setNumColumn(int numColumn) {
        this.numColumn = numColumn;
    }

    public int getScoreColumn() {
        return ScoreColumn;
    }

    public void setScoreColumn(int scoreColumn) {
        ScoreColumn = scoreColumn;
    }

    public String getNameColumn() {
        return nameColumn;
    }

    public void setNameColumn(String nameColumn) {
        this.nameColumn = nameColumn;
    }

    public Highscore(int numColumn, int ScoreColumn, String nameColumn){
        this.numColumn = numColumn;
        this.ScoreColumn = ScoreColumn;
        this.nameColumn = nameColumn;
    }




}

HighscoreController.java:

package Controller;

import Model.Highscore;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.fxml.FXML;
import javafx.fxml.Initializable;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;
import javafx.scene.control.cell.PropertyValueFactory;

import java.io.File;
import java.io.FileNotFoundException;
import java.net.URL;
import java.util.ResourceBundle;
import java.util.Scanner;

public class HighscoreController implements Initializable {

    @FXML
    private TableView<Highscore> table;

    @FXML
    private TableColumn<Highscore, Integer> numColumn;

    @FXML
    private TableColumn<Highscore, String> nameColumn;

    @FXML
    private TableColumn<Highscore, Integer> scoreColumn;

    String fileName = "src/main/resources/Misc/Highscore.csv";
    File file = new File(fileName);



    {
        try {
            Scanner inputStream = new Scanner(file);
            while ((inputStream.hasNext())){
                String data = inputStream.next();
                Object[] values = data.split("\n");
                Object[] values_line = data.split(",");
//                Name[0] = (String)values[0];
//                Score[0] = (Integer)values[1];
//                Num[0] = (Integer)values[2];
            }
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        }
    }


    ObservableList<Highscore> list = FXCollections.observableArrayList(
            new Highscore(1, 200, "Bob")
    );

    @Override
    public void initialize(URL url, ResourceBundle resourceBundle) {
        numColumn.setCellValueFactory(new PropertyValueFactory<Highscore, Integer>("numColumn"));
        nameColumn.setCellValueFactory(new PropertyValueFactory<Highscore, String>("nameColumn"));
        scoreColumn.setCellValueFactory(new PropertyValueFactory<Highscore, Integer>("scoreColumn"));

        table.setItems(list);
    }
}

Solution

  • you need to put it in the list, the list is your item source, and it ObservableList so a change in the list will trigger a change in the view, the bind done in: table.setItems(list);

    ObservableList<Highscore> list = FXCollections.observableArrayList(
                new Highscore(1, 200, "Bob")
        );
    
        {
            try {
                Scanner inputStream = new Scanner(file);
                while ((inputStream.hasNext())){
                    String data = inputStream.next();
                    Object[] values = data.split("\n");
                    Object[] values_line = data.split(",");
    //                Name[0] = (String)values[0];
    //                Score[0] = (Integer)values[1];
    //                Num[0] = (Integer)values[2];
                    list.add(new Highscore(Integer.valueOf(values_line[0].toString()),Integer.valueOf(values_line[1].toString()),values_line[2].toString()));
                }
            } catch (FileNotFoundException e) {
                e.printStackTrace();
            }
        }
    

    and cleaner:

    //list of Highscore items
        ObservableList<Highscore> list = FXCollections.observableArrayList();
    
        public void initList(){
            try {
                Scanner inputStream = new Scanner(file);
                while ((inputStream.hasNext())){
                    String data = inputStream.next();
                    String[] values_line = data.split(",");
    //                Name[0] = (String)values[0];
    //                Score[0] = (Integer)values[1];
    //                Num[0] = (Integer)values[2];
                    list.add(new Highscore(Integer.valueOf(values_line[0]),Integer.valueOf(values_line[1]),values_line[2]));
                }
            } catch (FileNotFoundException e) {
                e.printStackTrace();
            }
        }
    
    
        @Override
        public void initialize(URL url, ResourceBundle resourceBundle) {
            //fill the list with values
            initList();
            numColumn.setCellValueFactory(new PropertyValueFactory<Highscore, Integer>("numColumn"));
            nameColumn.setCellValueFactory(new PropertyValueFactory<Highscore, String>("nameColumn"));
            scoreColumn.setCellValueFactory(new PropertyValueFactory<Highscore, Integer>("scoreColumn"));
            //bind list into the table
            table.setItems(list);
        }