opencsv解析文件

opencsv解析csv文件到bean对象

import com.opencsv.bean.CsvToBeanBuilder;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.InputStreamReader;
import java.io.UnsupportedEncodingException;
import java.util.List;

public class CsvUtil {

    public static List readFile(String fileName, Class clazz) throws FileNotFoundException, UnsupportedEncodingException {

        InputStreamReader is = new InputStreamReader(new FileInputStream(fileName), "utf-8");
        List<Object> beans = new CsvToBeanBuilder(is)
                .withType(clazz).build().parse();
        return beans;
    }

}

public class TT1 {
    @CsvBindByName(column = "WKT")
    private String the_geom;
    @CsvBindByName(column = "OBJECTID_1")
    private String OBJECTID_1;
    @CsvBindByName(column = "BH")
    private String BH;
            @CsvBindByName(column = "ADDRESS")
    private String ADDRESS;

    public String getThe_geom() {
        return the_geom;
    }

    public void setThe_geom(String the_geom) {
        this.the_geom = the_geom;
    }

    public String getOBJECTID_1() {
        return OBJECTID_1;
    }

    public void setOBJECTID_1(String OBJECTID_1) {
        this.OBJECTID_1 = OBJECTID_1;
    }

    public String getBH() {
        return BH;
    }

    public void setBH(String BH) {
        this.BH = BH;
    }

    public String getADDRESS() {
        return ADDRESS;
    }

    public void setADDRESS(String ADDRESS) {
        this.ADDRESS = ADDRESS;
    }


}

测试数据

public class ReadCsvTest {

    @Test
    public void t1() throws IOException {
        List<TT1> list = CsvUtil.readFile("C:\\Users\\admin\\Desktop\\qzjj.csv", TT1.class);
    }


}