Add a sample code for readiing csv file by java

[Zhziyao]

/**

• this sample code is not for new fish
• 1st u need to add dependency to ur maven project
• com.opencsv
• opencsv
• 5.6
• 2nd u need replace the file path with yours
• 3rd copy the sample code to ur project and run test and
• u can see the data of words, then u can write the data to mysql db by yourself

• */ public class DictionaryDataInitService {

  public static void main(String[] args) { try { ArrayList<String[]> csvList = new ArrayList<String[]>(); Reader reader = Files.newBufferedReader(Paths.get("YOUR FILE PATH")); CSVReader csvReader = new CSVReader(reader); String[] line = null; line = csvReader.readNext(); int i = 0; List<List> results = Lists.newArrayList(); while (line != null && i <= 3000) { //filter the word if (!line[0].contains("-")){ if (!line[0].contains(".")) { if (!line[0].startsWith("'")) { if (line[0].charAt(0) > '9' || line[0].charAt(0) < '0') { if (line[0].length() > 1) { results.add(Arrays.asList(line)); } } } } } i++; line = csvReader.readNext(); } for (List item : results) { System.out.println(item.get(4)); } csvReader.close(); } catch (Exception e) { System.out.println(e); } }

}