CSV格式

来源：互联网发布：仓库管理优化方案编辑：程序博客网时间：2024/05/17 06:23

今天王师傅给推荐CSV格式，CSV算是一种文本存/取通用规则，主要规则是逗号的运用,Java阵营有一个开源软件(两个类)专门搞CSV格式的转换。

参考资料:

1、http://baike.baidu.com/view/468993.htm#4

2、http://sourceforge.net/projects/javacsv/?source=dlp

示例:

/** * CSV规范测试用例 * @version 2013-04-24 * @author WangYanCheng */public class CSVTest {    private static final File testFile = new File("D:/DEV/900_TEST/CSVWriteTest.csv");    private static String[][] testData;    static {        testData = new String[][]{{"A", "B", "汉", "字"}, {"\"分号", "!@#$%^&*()", "./\\<>`", "`", "/\\//\\////\\\\\\"}};    }    /**     * CSV写入测试     */    public void doWriteTest() {        CsvWriter csvWriter = null;        try {            csvWriter = new CsvWriter(new FileOutputStream(testFile), ',', Charset.forName("GBK"));            for (int i = 0; i < testData.length; i++) {                for (int j = 0; j < testData[i].length; j++) {                    csvWriter.write(testData[i][j]);                }                csvWriter.endRecord();            }            csvWriter.flush();        } catch (FileNotFoundException e) {            e.printStackTrace();        } catch (IOException e) {            e.printStackTrace();        } finally {            if (null != csvWriter) {                csvWriter.close();            }        }    }    /**     * CSV读取测试     */    public void doReadTest() {        CsvReader csvReader = null;        try {            csvReader = new CsvReader(new FileInputStream(testFile), Charset.forName("GBK"));            while (csvReader.readRecord()) {                int colCount = csvReader.getColumnCount();                for (int columnIndex = 0; columnIndex < colCount; columnIndex ++) {                    System.out.print(csvReader.get(columnIndex));                }                System.out.println();            }        } catch (IOException e) {            e.printStackTrace();        } finally {            if (null != csvReader) {                csvReader.close();            }        }    }    /**     * 测试入口     * @param args 参数列表     */    public static void main(String[] args) {        new CSVTest().doWriteTest();        new CSVTest().doReadTest();    }}