java读取CSV表格数据放在实体类中的

来源：互联网发布：达内linux 编辑：程序博客网时间：2024/06/05 17:49

CsvReader reader = new CsvReader("C:\\Users\\DuoNuo\\Desktop\\新三板\\财务\\财务报表.csv", ',',                  Charset.forName("GBK"));reader.readHeaders();          String[] headers = reader.getHeaders();         List<Object[]> list = new ArrayList<Object[]>();          while (reader.readRecord()) {              list.add(reader.getValues());          }          Object[][] datas = new String[list.size()][];          for (int i = 0; i < list.size(); i++) {              datas[i] = list.get(i);          }                  for (int i = 0; i < datas.length; i++) {              Object[] data = datas[i]; // 取出一行数据              FinancialReportEntity entity=new FinancialReportEntity();            for (int j = 0; j < data.length; j++) {                  Object cell = data[j];                   switch(j){                 case 0:                 entity.setGrossIncome(String.valueOf(cell));                 break;                 case 1:                 entity.setNetProfit(String.valueOf(cell));                 break;                 case 2:                 entity.setStockCode(String.valueOf(cell));                 }            }             System.out.println(entity.toString()); }

可做相应更改,仅做参考

0 0