List of usage examples for org.apache.commons.csv CSVParser parse
public static CSVParser parse(final URL url, final Charset charset, final CSVFormat format) throws IOException
From source file:parser_owl.ParserOwl.java
public static void startMontpellierWithData(String inputData) { try {//from w ww . j ava 2s. c o m System.out.println("Starting Montpellier (input file: " + inputData + ")..."); File csvData = new File(inputData); CSVParser parser = CSVParser.parse(csvData, Charset.defaultCharset(), CSVFormat.EXCEL.withHeader()); for (CSVRecord csvRecord : parser) { Film film = new Film(csvRecord.get("titre"), OMDB_PROXY.getMovieInfos(csvRecord.get("titre")).get("Director"), csvRecord.get("date_debut_evenement"), csvRecord.get("date_fin_evenement"), "", csvRecord.get("lieu"), csvRecord.get("lieu"), "", csvRecord.get("lieu"), "", OMDB_PROXY.getMovieInfos(csvRecord.get("titre")).get("imdbRating"), OMDB_PROXY.getMovieInfos(csvRecord.get("titre")).get("Runtime"), OMDB_PROXY.getMovieInfos(csvRecord.get("titre")).get("Country"), OMDB_PROXY.getMovieInfos(csvRecord.get("titre")).get("Actors"), OMDB_PROXY.getMovieInfos(csvRecord.get("titre")).get("Year")); MANAGER.store(film); } System.out.println("Ending Montpellier."); } catch (IOException e) { System.out.println("error: " + e); } }
From source file:proci.gui.Importa.java
private void doImport() { jepData.setText(""); text = new StringBuilder("<html><body>"); try {// w ww . j av a 2 s .co m conn = DBHandler.getInstance().getConnection(); stmt = conn.createStatement(); conn.setAutoCommit(false); int delRec = 0; delRec = stmt.executeUpdate("delete from SOCIO"); text.append("Cancellati: ").append(delRec).append(" soci!<br>"); delRec = stmt.executeUpdate("delete from DOTAZIONE"); text.append("Cancellate: ").append(delRec).append(" dotazioni!<br>"); delRec = stmt.executeUpdate("delete from INTERVENTO"); text.append("Cancellati: ").append(delRec).append(" interventi!<br>"); delRec = stmt.executeUpdate("delete from ESERCITAZIONE"); text.append("Cancellate: ").append(delRec).append(" esercitazioni!<br>"); delRec = stmt.executeUpdate("delete from SPECIALIZZAZIONE"); text.append("Cancellate: ").append(delRec).append(" specializzazioni!<br>"); delRec = stmt.executeUpdate("delete from SODO"); delRec = stmt.executeUpdate("delete from SOIN"); delRec = stmt.executeUpdate("delete from SOES"); delRec = stmt.executeUpdate("delete from SOSP"); // elimina foto dei soci File imagedir = new File(app.getAppPath(EDirectories.IMAGES_PHOTOS)); File[] images = imagedir.listFiles(); for (File f : images) { f.delete(); } text.append("Eliminate: ").append(images.length).append(" immagini<br>"); // elimina miniature imagedir = new File(app.getAppPath(EDirectories.IMAGES_THUMBS)); images = imagedir.listFiles(); for (File f : images) { f.delete(); } text.append("Eliminate: ").append(images.length).append(" miniature<br>"); // psSocio = conn .prepareStatement("insert into SOCIO values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); psDot = conn.prepareStatement("insert into DOTAZIONE values (?,?,?)"); psInt = conn.prepareStatement("insert into INTERVENTO values (?,?)"); psEse = conn.prepareStatement("insert into ESERCITAZIONE values (?,?)"); psSpe = conn.prepareStatement("insert into SPECIALIZZAZIONE values (?,?)"); psSodo = conn.prepareStatement("insert into SODO values (?,?,?)"); psSoin = conn.prepareStatement("insert into SOIN values (?,?)"); psSoes = conn.prepareStatement("insert into SOES values (?,?)"); psSosp = conn.prepareStatement("insert into SOSP values (?,?)"); // File csvData = new File(filename); CSVParser parser = CSVParser.parse(csvData, Charset.forName("UTF-8"), CSVFormat.RFC4180); for (CSVRecord csvRecord : parser) { // trappola intestazione if (csvRecord.get(0).equalsIgnoreCase("IDSocio")) { continue; } logger.info("Insert Socio: {}", csvRecord); insertSocio(csvRecord); // break; // case 2: // insertDot(line); // break; // case 3: // insertInt(line); // break; // case 4: // insertEse(line); // break; // case 5: // insertSpe(line); // break; // case 6: // insertSodo(line); // break; // case 7: // insertSoin(line); // break; // case 8: // insertSoes(line); // break; // case 9: // insertSosp(line); // break; // } } } catch (Exception e) { JOptionPane.showMessageDialog(this, "<html><font color='red'>ERRORE!</font>" + e, "ERRORE", JOptionPane.ERROR_MESSAGE); text.append("ERRORE: " + e); jepData.setText(text.toString()); return; } try { conn.commit(); } catch (SQLException e) { } jepData.setText(text.toString()); }
From source file:testes.CveCsvReader.java
public static void main(String[] args) { int contCandidate = 0, contEntry = 0, contReserved = 0, contReject = 0, contDisputed = 0, contEqual = 0; String last = ""; try {/* w w w. ja va2 s.c o m*/ File csvData = new File("dataset/base_dados_cve.csv"); // File csvDataOut = new File("dataset/cve_out.csv"); // FileWriter outFile = new FileWriter(csvDataOut); // CSVPrinter csvPrinter = new CSVPrinter((Appendable) outFile, CSVFormat.RFC4180); CSVParser parser = CSVParser.parse(csvData, Charset.forName("ISO-8859-1"), CSVFormat.RFC4180); for (CSVRecord csvRecord : parser) { //System.out.println("Nmero de campos: " + csvRecord.size()); //System.out.println(csvRecord.get(0)); if (csvRecord.get(1).equals("Candidate")) { contCandidate++; } else if (csvRecord.get(1).equals("Entry")) { contEntry++; } if (csvRecord.get(2).startsWith("** RESERVED **")) { contReserved++; } else if (csvRecord.get(2).startsWith("** REJECT **")) { contReject++; } else if (csvRecord.get(2).startsWith("** DISPUTED **")) { contDisputed++; } else { if (last.equals(csvRecord.get(2))) { contEqual++; } else { // csvPrinter.printRecord(csvRecord); } last = csvRecord.get(2); } } System.out.println("Nmero de Registros: " + parser.getRecordNumber()); //csvPrinter.close(); } catch (IOException ex) { Logger.getLogger(CveCsvReader.class.getName()).log(Level.SEVERE, null, ex); } System.out.println("Nmero CANDIDATE: " + contCandidate); System.out.println("Nmero ENTRY: " + contEntry); System.out.println("Nmero REJECT: " + contReject); System.out.println("Nmero RESERVED: " + contReserved); System.out.println("Nmero DISPUTED: " + contDisputed); System.out.println("Nmero IGUAIS: " + contEqual); }