In the daily situation, there is often a situation in parsing / write CSV (Comma Separated Value), especially in the old application system, when chaotic is open, there is no XML between the world, and the database, which can be accessed anytime, anywhere, etc. The method of transferring data between two physical separated systems is to export files in a format, put it into another local import (the ear suddenly sounded the prior colleagues: Guide to guide the guide. . CSV is a text file, which can be opened directly, and it is convenient to parse, often be the first choice for intermediate format (of course, there is also an Excel).
So resolve / write CSV is the functionality that should be included in a common system toolkit.
In Java, I think there is still the following:
1, should be converted into a common data format to ensure the needs of the thousand variable applications, that is, the data format directly inherits the collection or is one of the basic collection frames.
2. In addition to CSV, other structured types of data file format (XSL, XML, DBF ...) should be parsed / written in a similar method, and users do not need to learn to resolve / write various data files.
3. Considering the number of records in the document, the number of records may be thousands, the efficiency of the resolution will be low, may need to consider a policy of parsing / reading / modifying records, there is a solution to the CSV file as a JDBC Data source
4, CSV file coding problem
reference:
1, Java Collection Framework
http://www.dalianit.com/edu/|80|85|90|49|80|66|62|62|.html
2, java.sql.resultset how to operate data
3, a document code complete parsing package
http://ostermiller.org/utils/csv.html
