This Java library read, search, alter and delete data from a CSV files.
To use this library download de Jar file and import in your project, or clone the source code in your project folder:
import crudcsv.CrudCSV;
import java.util.Map;
Open the file:
// CrudCSV(String path, String delimiter)
// CrudCSV(String path)
CrudCSV db = new CrudCSV("data1.csv");
To search in the file and print all results (by default, the first column are the INTEGER PRIMARE_KEY column):
// Map<Integer, String[]> search(String column, String value)
// Map<Integer, String[]> search(String column, int value)
Map<Integer,String[]> results = db.search("first_name", "Phil");
for (String[] result : results.values()){
System.out.println(Arrays.toString(result));
}
Inserting one row (by default, the id column are AUTO_INCREMENT):
// Boolean insert(String[] value)
String[] values = {"Jason", "Heinlen", "[email protected]", "Male"};
db.insert(values)
Modifying a existing row:
// Boolean alter(int id, String[] value)
// Boolean alter(int id, String column, String value)
db.alter(1002, "email", "[email protected]"))
To delete a row:
// Boolean delete(int id)
db.delete(1002);