Example usage for org.apache.commons.csv CSVRecord size

Introduction

In this page you can find the example usage for org.apache.commons.csv CSVRecord size.

Prototype

public int size()

Source Link

Document

Returns the number of values in this record.

Usage

From source file:phonedirectory.PhoneDirectoryModel.java

public void csvToDatabase(String csv, String column[]) {

    try {/*  w ww .  j a  va  2  s .c  om*/
        Connection con = DriverManager.getConnection(url, user, password);
        stmt1 = con.createStatement();
        int i;
        CSVParser parser = new CSVParser(new FileReader(csv), format);
        for (CSVRecord record : parser) {
            stmt = con.prepareStatement("insert into person(name,address) values(?,?)");
            stmt.setString(1, record.get(0));
            stmt.setString(2, record.get(1));
            stmt.executeUpdate();
            stmt.close();

            rs = stmt1.executeQuery("select person_id from person");
            rs.last();
            int person_id = rs.getInt(1);

            stmt = con.prepareStatement("insert into phone values(?,?,?)");
            for (i = 2; i < record.size(); i++) {
                stmt.setString(1, record.get(i));
                stmt.setString(2, column[i]);
                stmt.setInt(3, person_id);
                stmt.executeUpdate();

            }
            stmt.close();

        }
        parser.close();
        con.close();
    } catch (Exception e) {
        e.printStackTrace();
    }

}

From source file:ro.dabuno.office.integration.Data.java

private void readCSVFile(File csvFile) throws IOException {
    // open file//w  w  w  . j  av a  2 s .co  m
    // List<String> lines = FileUtils.readLines(file, null);
    try (Reader reader = new FileReader(csvFile)) {
        CSVFormat strategy = CSVFormat.DEFAULT.withHeader().withDelimiter(',').withQuote('"')
                .withCommentMarker((char) 0).withIgnoreEmptyLines().withIgnoreSurroundingSpaces();

        try (CSVParser parser = new CSVParser(reader, strategy)) {
            Map<String, Integer> headerMap = parser.getHeaderMap();
            for (Map.Entry<String, Integer> entry : headerMap.entrySet()) {
                headers.add(entry.getKey());
                log.info("Had header '" + entry.getKey() + "' for column " + entry.getValue());
            }

            List<CSVRecord> lines = parser.getRecords();
            log.info("Found " + lines.size() + " lines");
            for (CSVRecord line : lines) {
                List<String> data = new ArrayList<>();
                for (int pos = 0; pos < headerMap.size(); pos++) {
                    if (line.size() <= pos) {
                        data.add(null);
                    } else {
                        data.add(line.get(pos));
                    }
                }

                values.add(data);
            }
        }
    }
}

From source file:StatisticLearningProject.DataGrid.java

public DataGrid(File f) {
    Reader in = null;/* ww  w  . j av  a2s  .  co m*/

    try {
        in = new FileReader(f.getAbsolutePath());
    } catch (FileNotFoundException e) {
        loadError = e.getMessage();
        return;
    }

    try {
        ArrayList<CSVRecord> records = Lists.newArrayList(CSVFormat.EXCEL.parse(in));
        CSVRecord headerRec = records.remove(0);
        int columns = headerRec.size();
        String[] headers = new String[columns];
        for (int i = 0; i < columns; i++) {
            headers[i] = (String) headerRec.get(i);
        }
        int rows = records.size();
        Object[][] data = new Object[rows][columns];
        int count = 0;
        for (CSVRecord record : records) {
            for (int i = 0; i < columns; i++) {
                data[count][i] = record.get(i);
            }
            count++;
        }
        tableModel = new DefaultTableModel(data, headers);
    } catch (IOException e) {
        loadError = e.getMessage();

    }
}

From source file:us.parr.animl.data.DataTable.java

public static DataTable loadCSV(String fileName, String formatType, VariableType[] colTypesOverride,
        String[] colNamesOverride, boolean hasHeaderRow) {
    try {//ww  w.  jav a  2  s . c  om
        // use apache commons io + csv to load but convert to list of String[]
        // byte-order markers are handled if present at start of file.
        FileInputStream fis = new FileInputStream(fileName);
        final Reader reader = new InputStreamReader(new BOMInputStream(fis), "UTF-8");
        CSVFormat format;
        if (formatType == null) {
            format = hasHeaderRow ? CSVFormat.RFC4180.withHeader() : CSVFormat.RFC4180;
        } else {
            switch (formatType.toLowerCase()) {
            case "tsv":
                format = hasHeaderRow ? CSVFormat.TDF.withHeader() : CSVFormat.TDF;
                break;
            case "mysql":
                format = hasHeaderRow ? CSVFormat.MYSQL.withHeader() : CSVFormat.MYSQL;
                break;
            case "excel":
                format = hasHeaderRow ? CSVFormat.EXCEL.withHeader() : CSVFormat.EXCEL;
                break;
            case "rfc4180":
            default:
                format = hasHeaderRow ? CSVFormat.RFC4180.withHeader() : CSVFormat.RFC4180;
                break;
            }
        }
        final CSVParser parser = new CSVParser(reader, format);
        List<String[]> rows = new ArrayList<>();
        int numHeaderNames = parser.getHeaderMap().size();
        try {
            for (final CSVRecord record : parser) {
                String[] row = new String[record.size()];
                for (int j = 0; j < record.size(); j++) {
                    row[j] = record.get(j);
                }
                rows.add(row);
            }
        } finally {
            parser.close();
            reader.close();
        }

        VariableType[] actualTypes = computeColTypes(rows, numHeaderNames);

        Set<String> colNameSet = parser.getHeaderMap().keySet();
        String[] colNames = colNameSet.toArray(new String[colNameSet.size()]);
        if (colNamesOverride != null) {
            colNames = colNamesOverride;
        }
        if (colTypesOverride != null) {
            actualTypes = colTypesOverride;
        }
        return fromStrings(rows, actualTypes, colNames, false);
    } catch (Exception e) {
        throw new IllegalArgumentException("Can't open and/or read " + fileName, e);
    }
}