opencsv csv 数据解析通用包

opencsv是一个很不错的java 版本csv 解析包，使用简单，而且比较灵活

参考代码

• pom.xml

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0"

         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

    <modelVersion>4.0.0</modelVersion>

​

    <groupId>com.dalong</groupId>

    <artifactId>opencsv-app</artifactId>

    <version>1.0-SNAPSHOT</version>

    <properties>

        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

        <encoding>UTF-8</encoding>

        <java.version>1.8</java.version>

        <maven.compiler.source>1.8</maven.compiler.source>

        <maven.compiler.target>1.8</maven.compiler.target>

    </properties>

    <dependencies>

        <dependency>

            <groupId>com.opencsv</groupId>

            <artifactId>opencsv</artifactId>

            <version>5.2</version>

        </dependency>

    </dependencies>

    <build>

        <plugins>

            <plugin>

                <groupId>org.apache.maven.plugins</groupId>

                <artifactId>maven-shade-plugin</artifactId>

                <version>2.3</version>

                <executions>

                    <execution>

                        <phase>package</phase>

                        <goals>

                            <goal>shade</goal>

                        </goals>

                        <configuration>

                            <transformers>

                                <transformer

                                        implementation="org.apache.maven.plugins.shade.resource.ManifestResourceTransformer">

                                    <mainClass>com.dalong.Application</mainClass>

                                </transformer>

                            </transformers>

                        </configuration>

                    </execution>

                </executions>

            </plugin>

        </plugins>

    </build>

</project>

• java code

package com.dalong;

​

import com.opencsv.bean.CsvToBean;

import com.opencsv.bean.CsvToBeanBuilder;

​

import java.io.BufferedReader;

import java.io.IOException;

import java.io.InputStream;

import java.io.InputStreamReader;

import java.util.function.Consumer;

​

public class Application {

    public static void main(String[] args) throws IOException {

            try (InputStream inputStream = Application.class.getClassLoader().getResourceAsStream("demoapp.txt");) {

                BufferedReader inputStreamReader = new BufferedReader(new InputStreamReader(inputStream));

                CsvToBean<Bank> csvToBean = new CsvToBeanBuilder(inputStreamReader).withType(Bank.class).withSeparator('|').withSkipLines(0).build();

                csvToBean.parse().forEach(new Consumer<Bank>() {

                    public void accept(Bank bank) {

                        System.out.println(bank.toString());

                    }

                });

                inputStreamReader.close();

            }

    }

}

 

Bank.java

package com.dalong;

​

import com.opencsv.bean.CsvBindByPosition;

​

public class Bank {

​

​

    @CsvBindByPosition(required = false,position = 0)

    private String id;

​

    public String getId() {

        return id;

    }

​

    @Override

    public String toString() {

        return "Bank{" +

                "id='" + id + '\'' +

                ", desc='" + desc + '\'' +

                ", name='" + name + '\'' +

                '}';

    }

​

    public void setId(String id) {

        this.id = id;

    }

​

    public String getDesc() {

        return desc;

    }

​

    public void setDesc(String desc) {

        this.desc = desc;

    }

​

    public String getName() {

        return name;

    }

​

    public void setName(String name) {

        this.name = name;

    }

    @CsvBindByPosition(required = false,position = 1)

​

    private String desc;

    @CsvBindByPosition(required = false,position = 2)

​

    private String name;

}

• 写入操作

package com.dalong;

​

import com.opencsv.CSVWriter;

import com.opencsv.bean.CsvToBean;

import com.opencsv.bean.CsvToBeanBuilder;

import com.opencsv.bean.StatefulBeanToCsv;

import com.opencsv.bean.StatefulBeanToCsvBuilder;

import com.opencsv.exceptions.CsvDataTypeMismatchException;

import com.opencsv.exceptions.CsvRequiredFieldEmptyException;

​

import java.io.*;

import java.util.List;

import java.util.function.Consumer;

​

public class Application {

    public static void main(String[] args) throws IOException, CsvDataTypeMismatchException, CsvRequiredFieldEmptyException {

            try (InputStream inputStream = Application.class.getClassLoader().getResourceAsStream("demoapp.txt");) {

                BufferedReader inputStreamReader = new BufferedReader(new InputStreamReader(inputStream));

                CsvToBean<Bank> csvToBean = new CsvToBeanBuilder(inputStreamReader).withType(Bank.class).withSeparator('|').withSkipLines(1).build();

                List<Bank> list =  csvToBean.parse();

                list.forEach(new Consumer<Bank>() {

                    public void accept(Bank bank) {

                        System.out.println(bank.toString());

                    }

                });

                inputStreamReader.close();

                Writer writer = new FileWriter("yourfile.csv");

                StatefulBeanToCsv beanToCsv = new StatefulBeanToCsvBuilder(writer).withSeparator('|').withQuotechar('\u0000').build();

                beanToCsv.write(list);

                writer.close();

            }

        }

}

说明

opencsv支持的操作还是比较多的，同时也支持sql 的处理，可以参考官方文档学习

参考资料

http://opencsv.sourceforge.net/#reading_into_beans