import org.apache.commons.csv.CSVFormat; import org.apache.commons.csv.CSVParser; import org.apache.commons.csv.CSVRecord; import java.io.FileReader; import java.io.IOException; import java.nio.charset.StandardCharsets; public class CSVParserExample { public static void main(String[] args) { String csvFile = "data.csv"; try (FileReader fileReader = new FileReader(csvFile, StandardCharsets.UTF_8); CSVParser csvParser = new CSVParser(fileReader, CSVFormat.DEFAULT)) { for (CSVRecord csvRecord : csvParser) { String name = csvRecord.get(0); String email = csvRecord.get(1); } } catch (IOException e) { e.printStackTrace(); } } } import org.apache.commons.csv.CSVFormat; import org.apache.commons.csv.CSVParser; import org.apache.commons.csv.CSVRecord; import java.io.FileReader; import java.io.IOException; import java.nio.charset.StandardCharsets; public class CSVValidatorExample { public static void main(String[] args) { String csvFile = "data.csv"; try (FileReader fileReader = new FileReader(csvFile, StandardCharsets.UTF_8); CSVParser csvParser = new CSVParser(fileReader, CSVFormat.DEFAULT)) { for (CSVRecord csvRecord : csvParser) { String name = csvRecord.get(0); String email = csvRecord.get(1); boolean valid = validate(name, email); if (!valid) { System.out.println("Invalid record: " + csvRecord.toString()); } } } catch (IOException e) { e.printStackTrace(); } } private static boolean validate(String name, String email) { return email.matches("[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\.[a-zA-Z]{2,}"); } } import org.apache.commons.csv.CSVFormat; import org.apache.commons.csv.CSVParser; import org.apache.commons.csv.CSVRecord; import java.io.FileReader; import java.io.FileWriter; import java.io.IOException; import java.nio.charset.StandardCharsets; public class CSVValidatorResultProcessor { public static void main(String[] args) { String csvFile = "data.csv"; String resultFile = "validation_result.csv"; try (FileReader fileReader = new FileReader(csvFile, StandardCharsets.UTF_8); CSVParser csvParser = new CSVParser(fileReader, CSVFormat.DEFAULT); FileWriter fileWriter = new FileWriter(resultFile)) { for (CSVRecord csvRecord : csvParser) { String name = csvRecord.get(0); String email = csvRecord.get(1); boolean valid = validate(name, email); if (!valid) { String invalidRecord = csvRecord.toString(); fileWriter.append(invalidRecord); fileWriter.append(" "); } } } catch (IOException e) { e.printStackTrace(); } } private static boolean validate(String name, String email) { } }


上一篇:
下一篇:
切换中文