三、导入csv格式的excel

一时失言乱红尘 2024-02-17 14:22 58阅读 0赞

package com.cmdi.dataloader;
    
    import java.io.BufferedReader;
    import java.io.DataInputStream;
    import java.io.File;
    import java.io.FileInputStream;
    import java.io.FileNotFoundException;
    import java.io.IOException;
    import java.io.InputStreamReader;
    import java.util.ArrayList;
    import java.util.List;
    import java.util.StringTokenizer;
    
    import org.springframework.context.annotation.Scope;
    import org.springframework.stereotype.Service;
    @Service
    @Scope("singleton")
    public class CsvImport extends ImportData {
    	private List<String> rowList = new ArrayList<String>(); 
    	private List<List<String>> list = new ArrayList<List<String>>();
    	private CsvImport(){
    		get_import_list().add(this);
    	}
    	//private static CsvImport csvImport=new CsvImport();
    	
    	public List<List<String>> read(String filePath){
    //		验证文件的合法性
    			if(!validateExcel(filePath)){
    				return null;
    			}
    		try { 
                File csv = new File(filePath); // CSV文件
    
    //            BufferedReader br = new BufferedReader(new FileReader(csv));
                DataInputStream in = new DataInputStream(new FileInputStream(csv)); 
                BufferedReader br= new BufferedReader(new InputStreamReader(in,"GBK"));//设置输出的编码
    
                // 读取直到最后一行 
                String line = ""; 
    //            当前行
                int cur = 0;
                while ((line = br.readLine()) != null) { 
                    // 把一行数据分割成多个字段 
                    StringTokenizer st = new StringTokenizer(line, ",");
                    List<String> tempList = new ArrayList<String>();
                    while (st.hasMoreTokens()) { 
                        // 每一行的多个字段用TAB隔开表示 
    //                    System.out.print(st.nextToken() + "/t");
                        rowList.add(st.nextToken());
                    } 
                    if(cur>0){
                    	for (int i = 1; i < rowList.size(); i++) {//i是指当前行
                    		tempList.add(rowList.get(i));//将每行数据放进tempList
                    	}
                    	rowList.clear();
                    	list.add(tempList);//将每行的数据 存进 list
                    }else{
                    	rowList.clear();
                    }
                    cur++;
                } 
                br.close();
    
            } catch (FileNotFoundException e) { 
                // 捕获File对象生成时的异常 
                e.printStackTrace(); 
            } catch (IOException e) { 
                // 捕获BufferedReader对象关闭时的异常 
                e.printStackTrace(); 
            } 
    		//返回csv的所有数据
    		return list;
    	}
    	public boolean validateExcel(String filePath) {
    		// TODO Auto-generated method stub
    		if (filePath == null
    				|| !(isCsv(filePath))) {
    			return false;
    
    		}
    
    		/** 检查文件是否存在 */
    
    		File file = new File(filePath);
    
    		if (file == null || !file.exists()) {
    			return false;
    		}
    		return true;
    	}
    	public static boolean isCsv(String filePath) {
    		
    		return filePath.matches("^.+\\.(?i)(csv)$");
    	}
    }