5分でできる！簡単なcsvデータの加工(read/write)法。(Java編)

key,name,pref,job
key1,name1,pref1,job1
key2,名前2,県2,お仕事2

package jp.koji.bean;
 
public class SampleCsvBean {
 
    String key;
    String name;
    String pref;
    String job;
 
    public SampleCsvBean() {
        this.key = "";
        this.name = "";
        this.pref = "";
        this.job = "";
    }
 
    public String getKey() {
        return key;
    }
 
    public void setKey(String key) {
        this.key = key;
    }
 
    public String getName() {
        return name;
    }
 
    public void setName(String name) {
        this.name = name;
    }
 
    public String getPref() {
        return pref;
    }
 
    public void setPref(String pref) {
        this.pref = pref;
    }
 
    public String getJob() {
        return job;
    }
 
    public void setJob(String job) {
        this.job = job;
    }
 
}

package jp.koji.bean;
 
import java.io.FileOutputStream;
import java.io.FileInputStream;
import java.io.OutputStreamWriter;
import java.io.InputStreamReader;
import java.io.Reader;
import java.io.Writer;
import java.util.Iterator;
import java.util.List;
 
import com.opencsv.CSVReader;
import com.opencsv.CSVWriter;
import com.opencsv.bean.ColumnPositionMappingStrategy;
import com.opencsv.bean.CsvToBean;
 
public class MainCSVUtil {
     
    public static void main(String[] arg) throws Exception {
          
        writeSampleCSV("D:\\SampleOut.csv",readSampleCSV("D:\\SampleIn.csv"));
      
    }
 
     
    public static List readSampleCSV(String inputFilePath){
          
        Reader ioreader = null;
        List tmpNDCsvBean = null;
      
        try {
      
            ioreader = new InputStreamReader(new FileInputStream(inputFilePath),"UTF-8");
      
            ColumnPositionMappingStrategy mappingStrategy = new ColumnPositionMappingStrategy();
            mappingStrategy.setType(SampleCsvBean.class);
      
            String[] columns = new String[]{"key", "name", "pref", "job"};
            mappingStrategy.setColumnMapping(columns);
      
            CsvToBean csv = new CsvToBean();
            CSVReader reader = new CSVReader(ioreader, ',', '"');
            tmpNDCsvBean = csv.parse(mappingStrategy, reader);
      
        } catch (Exception e) {
            e.printStackTrace();
        }finally{
      
            try{
                ioreader.close();
            }catch(Exception e){
                e.printStackTrace();
            }
        }
      
        return tmpNDCsvBean;
    }
     
    public static void writeSampleCSV (String outputFilePath, List listCSVBean){
          
        Writer iowriter = null;
        CSVWriter writer = null;
        try {
      
            iowriter = new OutputStreamWriter(new FileOutputStream(outputFilePath),"UTF-8");
            writer = new CSVWriter(iowriter, ',', CSVWriter.NO_QUOTE_CHARACTER);
      
            Iterator<samplecsvbean> ite = listCSVBean.iterator();
            while(ite.hasNext()){
      
                SampleCsvBean tt = ite.next();
      
                String[] entries = new String[]{tt.getKey(),
                                                tt.getName(),
                                                tt.getPref(),
                                                tt.getJob().replace(",", "、")
                                                };
      
                writer.writeNext(entries);
      
            }
            writer.close();
      
        }catch (Exception e) {
            e.printStackTrace();
        }finally{
      
            try{
                iowriter.close();
            }catch(Exception e){
                e.printStackTrace();
            }
      
        }
      
    }
     
}