java-csvreader

原因

项目中需要导入CSV数据到数据库，手动写太麻烦，于是就利用javacsvRead来写
javacsv2.1 下载地址：http://sourceforge.net/projects/javacsv/files/

数据的样式

| 姓名|年龄|地址|
|--------|--------|
| 张三|李四|东大街3号|

    String filePath = "name.csv";
        Char decollator =",";
        String encode = "GBK";
        CsvReader r =-new CsvReader(filePath,decollator,Charset.forName(encode));
        
        r.readHeaders();
        
        String[] head = r.getHeaders(); //获取表头
        
        while (r.readRecord())
        {
            for (int i = 0; i < head.length; i++)
            {
                System.out.println(head[i] + ":" + r.get(head[i]));
            }
            
        }
        r.close();

写入数据

        String filePath = "name.csv";
        Char decollator =",";
        String encode = "GBK";

    CsvWriter wr =new CsvWriter(filePath ,decollator ,Charset.forName(encode ));
    String[] contents = {"Lily","五一","90","女"};
    wr.writeRecord(contents);
    wr.close();