java - 如何将在线 CSV 文件导入 Java 并将每一列用作变量？

Question

我正在尝试在线导入包含 6 个字段的 CSV 文件。我正在尝试从网络链接导入。我可以下载该文件并使用文件名。我想做的是从文件中读取数据并将其输出到我的程序中。到目前为止我有这个:

public class Element {
    public static final String CSV_FILE_URL = "http://www.google.com/File.csv"; //Actual URl not published

    public static void main(String[] args) throws IOException {
        URL url = new URL(CSV_FILE_URL);
        Scanner input =
                new Scanner(url.openConnection().getInputStream());}
    int number ;
    String symbol;
    String name;
    int group;
    int period;
    double weight;

Answer 1

最好不使用扫描仪，而是读取基于行的文件，将行转换为元素，然后像这样处理这些元素:

public static void main(String[] args) {
    try {
        URL url = new URL("http://www.google.com/File.csv");
        try(InputStream in = url.openStream();
                InputStreamReader inr = new InputStreamReader(in);
                BufferedReader br = new BufferedReader(inr)) {
            String line = br.readLine();
            while(line != null) {
                //Best case: no String separation, no ; contained in data items. If not
                //you need some other way to split this
                String[] elements = line.split(";");

                //Deal with that one line 


                //Get next line
                line = br.readLine();
            }
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
}