Overview

Main knowledge points

a.SwingNode class: Encapsulates the Java swing component into a JavaFX Node, so that Java Swing can be nested with JavaFX. JavaSwing is ugly. , but the operation is simple. The table components of JavaFX (TableView, etc.) are a bit complicated, so choose nested JavaSwing to use it. Just be ugly

b.javacsv-2.0.jar: Used to read csv through file address file and can perform a series of operations. Although it will no longer be updated after 2008, it is enough to operate a csv file.

c.FileChoose class: A file selector for JavaFX that can open the local resource manager. Whether the UI is beautiful or not depends on your system version.

d.CsvReader class: A tool class under the javacsv-2.0.jar package, mainly used to operate csv files

e.JTable class: Create a JTable instance to make csv files After opening the display, you need to pay attention to the order of parameters. The table content is a two-dimensional array, and the header is a one-dimensional array

JTable table = new JTable(表格內(nèi)容,表頭);

f. Store the one-digit array into the one-dimensional array:

String[][] arr = new String[10][];//開辟一個10行的二維數(shù)組
String[] row1 = {"id","name","sex","age"};
 
arr[0] = row1;//存進(jìn)二維數(shù)組

g. JTable does not display the header: you need to put the JTable object into a Pane

JTable table = new JTable(表內(nèi)容,表頭);
JScrollPane jScrollPane = new JScrollPane(table);
 
SwingNode swingNode = new SwingNode();
swingNode.setContent(jScrollPane);//使用swingNode封裝swing組件，就可以在Javafx中用了

The main method of CsvReader

• new CsvReader(String filePath) initialization construction When you need to pass in a local csv file address

• boolean readHeaders() read the header and skip

• String[] getHeaders() Get the csv file header (very strange, you need to call the readHeaders() method before you can get it, otherwise a null pointer exception will be reported)

That's it:

CsvReader reader = new CsvReader("xxx.csv");
reader.readHeaders(); //沒有這句話，執(zhí)行下面會報錯
String[] head = reader.getHeaders();

• boolean readRecord() reads a line of csv content. As long as you call it, the next time you call it, it will switch to the next line of csv. Usually we use a while loop to operate all the content line by line in time

• String getRawRecord() Read a row of data

while (reader.readRecord()){
    System.out.println(reader.getRawRecord());//輸出一行內(nèi)容
}

Example - Read a csv file on the local desktop

@Override
    public void start(Stage primaryStage) throws Exception {
        primaryStage.setTitle("文件選擇器");
        primaryStage.setHeight(600);
        primaryStage.setWidth(800);
 
        final FileChooser fileChooser = new FileChooser();
 
        //設(shè)置打開資源管理器后的文件過濾
        fileChooser.getExtensionFilters().addAll(
                new FileChooser.ExtensionFilter("All Images","*.*"),
                new FileChooser.ExtensionFilter("PNG","*.png"),
                new FileChooser.ExtensionFilter("MP4","*.mp4"),
                new FileChooser.ExtensionFilter("CSV","*.csv")
        );
 
        final Button open = new Button("打開文件");
 
        final GridPane inputGridPane = new GridPane();//創(chuàng)建格子布局面板
        GridPane.setConstraints(open,0,0);//第0行0列
 
        inputGridPane.setHgap(6.0);//設(shè)置水平間距
        inputGridPane.setVgap(6.0);//設(shè)置垂直間距
        inputGridPane.getChildren().addAll(open);//添加按鈕
 
        final Pane rootGroup = new VBox(12);//創(chuàng)建一個垂直盒子布局器
        rootGroup.getChildren().addAll(inputGridPane);//把格子面板放進(jìn)來
        rootGroup.setPadding(new Insets(12,12,12,12));
 
        primaryStage.setScene(new Scene(rootGroup));
        primaryStage.show();
 
//設(shè)置點擊-打開文件-的動作事件
open.setOnAction(event -> {
            File file = fileChooser.showOpenDialog(primaryStage);//在當(dāng)前窗口打開文件選擇器
            if (file != null){
                try {
                    FileInputStream inputStream = new FileInputStream(file);
                    BufferedInputStream stream = new BufferedInputStream(inputStream);
                    String fileName = file.getName();
                    String filePath = file.getAbsolutePath();
                    System.out.println("文件路徑 = "+filePath);
                    try {
                        CSVDemo.read(filePath);
                    } catch (IOException e) {
                        e.printStackTrace();
                    }    
                    //封裝JTable，使得JTable和Javafx嵌套在一起    
                    SwingNode swingNode = new SwingNode();
                    try {
                        JTable table = read(filePath);
                        JScrollPane jScrollPane = new JScrollPane(table);
                        swingNode.setContent(jScrollPane);
                    } catch (IOException e) {
                        e.printStackTrace();
                    }
                //設(shè)置JTable打開后表格的相對位置
                GridPane.setConstraints(swingNode,0,1);
                    inputGridPane.getChildren().add(swingNode);
                } catch (FileNotFoundException e) {
                    e.printStackTrace();
                }
            }
        });
}
//讀取csv文件并把它讀取到JTable中返回
public static JTable read(String filePath) throws IOException {
 
            CsvReader reader = new CsvReader(filePath);
            reader.readHeaders();//跳過表頭
            String[] head = reader.getHeaders();
 
            List<String []> list = new ArrayList<>();
            String s = reader.getRawRecord();
            System.out.println("表頭 "+s);
            String[] r1 = dataToArray(s);
//            list.add(r1);
 
            while (reader.readRecord()) {
                System.out.println(reader.getRawRecord());
                list.add(dataToArray(reader.getRawRecord()));
            }
        String[][] data = new String[list.size()][];
        System.out.println("一共"+list.size()+"行數(shù)據(jù)");
        for (int i = 0; i < data.length; i++) {
            data[i] = list.get(i);
        }
            JTable table = new JTable(data,head);
            return table;
 
    }
//將每一行的數(shù)據(jù)從String轉(zhuǎn)為String數(shù)組
    public static String[] dataToArray(String row){
        String[] res = row.split(",");
        return res;
    }

Effect Display

JScrollPane encapsulates JTable, SwingNode encapsulates JScrollPane

The above is the detailed content of How to import CSV files into JTable for display using Java. For more information, please follow other related articles on the PHP Chinese website!